同时在PHP中获取行

Question

我有那个

<?php
   $new=get_records("tbl_item","status=1 AND idshop='{$idshop}' AND special","id DESC", $startRow.",".$pageSize, " ");
   $dem=1;
   while($row_new=mysql_fetch_assoc($new)){
?>  
<div class=""row>
   <div class="col-3">
   </div>
</div>
<?php } ?>

我希望当这段代码运行时，它将显示1行带有4 col-3的行，直到循环结束。

我想要这样的输出

<div class=""row>
   <div class="col-3">
   </div>
   <div class="col-3">
   </div>
   <div class="col-3">
   </div>
   <div class="col-3">
   </div>
</div>
<div class=""row>
   <div class="col-3">
   </div>
   <div class="col-3">
   </div>
   <div class="col-3">
   </div>
   <div class="col-3">
   </div>
</div>

请帮帮我!谢谢大家！

Answer 1

这应该是可行的：

<?php
    $new=get_records("tbl_item","status=1 AND idshop='{$idshop}' AND special","id DESC", $startRow.",".$pageSize, " ");
    $i=0;
    while($row_new=mysql_fetch_assoc($new)){
        if($i % 4 == 0) {
?>  
<div class="row">
<?php
        }
?>  
    <div class="col-3">
    </div>
<?php
        if($i % 4 == 3) {
?>  
</div>
<?php
        }
?>  
<?php 
        $i++;
    }
    $i--;
    if ($i % 4 != 3) {
?>  
</div>
<?php
    }
?>

最后一个if是在记录总数不是4的倍数的情况下，那么我们需要关闭div标记。

而且，更不用说，您肯定应该使用MySQLi。Why should I use MySQLi?

Answer 2

试试这个兄弟：

更新，如果计数行小于4：

$new = get_records("tbl_item", "status=1 AND idshop='{$idshop}' AND special", "id DESC", $startRow . "," . $pageSize, " ");
$dem = 1;
$x = 0;
$count = count($new);
while ($row_new = mysql_fetch_assoc($new)) {
    $x++;
    if ($x==1 || $x % 4 == 1) { ?>
        <div class="row">
    <?php } ?>
    <div class="col-3">
        <?= "x: $x" ?>
    </div>
    <?php if ($x % 4 == 0 || $x == $count) { ?>
        </div>
        <?php
    }
}

Answer 3

试试这个：

<?php

   $new=get_records("tbl_item","status=1 AND idshop='{$idshop}' AND special","id DESC", $startRow.",".$pageSize, " ");
   $dem=1;

   while($row_new=mysql_fetch_assoc($new)){

?>  
<div class="row">

    <?php for($i = 1; $i <= 4; $i++){?>
       <div class="col-3">
       </div>
    <?php } ?>

</div>
<?php } ?>