将返回的数据拆分为相等的 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){

    $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