将返回的数据拆分为相等的 3 div 列

Question

我正在尝试使用 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;

Answer 1

将数据分成块，然后添加<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){&nbsp; &nbsp; $divideCount = ceil(count($nrows)/3);&nbsp; &nbsp; $results = array_chunk($res ,$divideCount);&nbsp; &nbsp; foreach($results as $result){&nbsp; &nbsp; &nbsp; &nbsp; $column .= '<div class="col-lg-6">';&nbsp; &nbsp; &nbsp; &nbsp; foreach($result as $res){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $modulecounter++;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $moduleid = "m". $modulecounter;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $column .= '<div class="col-lg-auto">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="custom-control custom-checkbox">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <input type="checkbox" class="custom-control-input modulerights" id="'. $moduleid .'">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <label class="custom-control-label" for="'. $moduleid .'">'. $res['MODULEDESC'] .'</label>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; $column .= '</div>';&nbsp; &nbsp; }}echo $column;示例输出：-&nbsp;https://3v4l.org/TlJT2