将数据(动态结果)拆分为3列- php mysql

Question

需要将结果( dynamic - mysql )拆分为列(按照$cols下面的定义)

注:如果有人有任何其他格式的解决方案，请告诉我.

$cols=3; // note i can change this to 4,5 ..2 etc..

echo "<table border='0'  align='center' valign='top' >";
do{
        echo "<tr>";
                    for($i=1;$i<=$cols;$i++){    
            $rowsA=data_fetch($sqlquery);
                        if($rowsA){
        echo'<td align="center" valign="top">
                    <table  border="1px" cellspacing="0" cellpadding="0" style="border-collapse:collapse;">
                        <tr align="center" valign="top">';
                                echo '<td class="dateis" align="center" valign="top" width="35px"> <strong>'.$srno.'</strong> </td>';
                                echo '<td class="dateis" align="center" valign="top" width="100px">'.$rowsA['prdname'].'</td>';
                                echo '<td class="dateis" align="center" valign="top" width="50px">'.number_format($rowsA['prdwgh'],3,'.','').'</td> 
                                    </tr>';
                                   $srno++;
                       echo'</tr>
                    </table>
        </td>';
    } else{
          }
      }
    } while($rowsA);
    echo "</table>";

因此，从上面我得到了显示： :。

1 Prda 1.4  |  2 prdan  2.3  |  3  prdbc  3.1
4 prdf 0.02 |  5 prdcv  1.0  |  6  prdd   0.9
7 prdc 0.3  |  8 prdbn  2.8  |  9  prdf   0.5

，但我需要如下所示:

1 Prda 1.4     |  4 prdf   0.02    |  7  prdc   0.3 
2 prdan  2.3   |  5 prdcv  1.0     |  8  prdbn  2.8
3 prdbc  3.1   |  6 prdd   0.9     |  9  prdf   0.5

最新情况：

如果有10条记录:

1 Prda 1.4     |  5 prdcv  1.0    |  9  prdf   0.5
2 prdan  2.3   |  6 prdd   0.9    |  10 prdf   2.5
3 prdbc  3.1   |  7 prdc   0.3    |  
4 prdf   0.02  |  8 prdbn  2.8    | 

如果有11条记录:

1 Prda 1.4     |  5 prdcv  1.0    |  9  prdf   0.5
2 prdan  2.3   |  6 prdd   0.9    |  10 prdf   2.5
3 prdbc  3.1   |  7 prdc   0.3    |  11 prdfd  2.1
4 prdf   0.02  |  8 prdbn  2.8    | 

谢谢

Answer 1

cols = 3的示例。请使用db名称及其列进行调整。希望结果如你所料。

$NoOfColumns = 3;
$dataArr = $matrixArr = array();

$query = "SELECT * FROM testDb ORDER BY prdname";
$result = mysqli_query($conn, $query) or die("error getting data");
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    array_push($dataArr, $row);
}
$totalCnt = count($dataArr);
$NoOfRows = floor($totalCnt / $NoOfColumns);
if ($havRem = $totalCnt % $NoOfColumns) {
    $NoOfRows++;
}
$matrixArr = array_chunk($dataArr , $NoOfRows);

//echo "<pre>";print_r($dataArr);echo "</pre>";
//echo "<pre>";print_r($matrixArr);echo "</pre>";

echo "<table border=1>";
for ($row = 0; $row < $NoOfRows; $row++) {
    echo "<tr>";
    $srno = $row+1;
    for ($col = 0; $col < $NoOfColumns; $col++) {        
    echo'<td align="center" valign="top">';
            if ($srno<=$totalCnt) {
             echo   '<table  border="1px" cellspacing="0" cellpadding="0" style="border-collapse:collapse;">
                    <tr align="center" valign="top">';
                            echo '<td class="dateis" align="center" valign="top" width="35px"> <strong>'.$srno.'</strong> </td>';
                            echo '<td class="dateis" align="center" valign="top" width="100px">'.$matrixArr[$col][$row]['prdname'].'</td>';
                            echo '<td class="dateis" align="center" valign="top" width="50px">'.$matrixArr[$col][$row]['prdwgh'].'</td> 
                                </tr>';

                   echo'</tr>
                </table>';
            }
    echo '</td>';
    $srno = $srno+$NoOfRows;
}
echo "</tr>";
}
echo "</table>";