我正在嘗試使用 div 顯示我的數據庫中的數據。我想將返回的數據拆分為 3 列，目前我只能將數據拆分為 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貢獻1848條經驗 獲得超2個贊
將數據分成塊，然后添加<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 關注
- 93 瀏覽
添加回答
舉報
0/150
提交
取消