我正在嘗試使用 div 顯示我的數(shù)據(jù)庫(kù)中的數(shù)據(jù)。我想將返回的數(shù)據(jù)拆分為 3 列，目前我只能將數(shù)據(jù)拆分為 2 列。$column = '<div class="col-lg-6">';$modulecounter = 0;$moduletotalquery = "SELECT COUNT(MODULEID) AS MODULEID FROM ASMODULERIGHTS";$moduletotalsql = oci_parse($conn, $moduletotalquery);oci_execute($moduletotalsql);$moduletotalrow = oci_fetch_array($moduletotalsql);$modulequery = "SELECT MODULEID, MODULEDESC FROM ASMODULERIGHTS ORDER BY MODULEID";$modulesql = oci_parse($conn, $modulequery);$moduleexec = oci_execute($modulesql);if($moduleexec){ while($modulerow = oci_fetch_array($modulesql)){ $modulecounter++; $moduleid = "m". $modulecounter; $column .= '<div class="col-lg-auto"> <div class="custom-control custom-checkbox"> <input type="checkbox" class="custom-control-input modulerights" id="'. $moduleid .'"> <label class="custom-control-label" for="'. $moduleid .'">'. $modulerow['MODULEDESC'] .'</label> </div> </div>'; if ($modulecounter == floor($moduletotalrow['MODULEID'] / 2)) { $column .= '</div><div class="col-lg-6">'; } }}$column .= '</div>';echo $column;
1 回答
慕尼黑5688855
TA貢獻(xiàn)1848條經(jīng)驗(yàn) 獲得超2個(gè)贊
將數(shù)據(jù)分成塊，然后添加<div>到塊中：
<?php
$modulecounter = 0;
$moduletotalquery = "SELECT COUNT(MODULEID) AS MODULEID FROM ASMODULERIGHTS";
$moduletotalsql = oci_parse($conn, $moduletotalquery);
oci_execute($moduletotalsql);
$moduletotalrow = oci_fetch_array($moduletotalsql);
$modulequery = "SELECT MODULEID, MODULEDESC FROM ASMODULERIGHTS ORDER BY MODULEID";
$modulesql = oci_parse($conn, $modulequery);
$moduleexec = oci_execute($modulesql);
$nrows = oci_fetch_all($modulesql, $res, null, null, OCI_FETCHSTATEMENT_BY_ROW+OCI_ASSOC);
$column = '';
if(count($nrows) > 0){
$divideCount = ceil(count($nrows)/3);
$results = array_chunk($res ,$divideCount);
foreach($results as $result){
$column .= '<div class="col-lg-6">';
foreach($result as $res){
$modulecounter++;
$moduleid = "m". $modulecounter;
$column .= '<div class="col-lg-auto">
<div class="custom-control custom-checkbox">
<input type="checkbox" class="custom-control-input modulerights" id="'. $moduleid .'">
<label class="custom-control-label" for="'. $moduleid .'">'. $res['MODULEDESC'] .'</label>
</div>
</div>';
}
$column .= '</div>';
}
}
echo $column;
示例輸出：- https://3v4l.org/TlJT2
- 1 回答
- 0 關(guān)注
- 92 瀏覽
添加回答
舉報(bào)
0/150
提交
取消