While fetch row in PHP

Question

I have that

<?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 } ?>

I want when this code run, it'll display 1 row with 4 col-3 until the end of the loop.

I want output like this

<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>

Please help me! Thanks all!

i want when this loop run, it have display

@hungrykoala – Nam Nguyen Oct 20 '17 at 08:04 — Nam Nguyen, Oct 20 '17 at 08:04
`mysql_*` is deprecated. You should switch to mysqli or PDO – Filnor Oct 20 '17 at 08:05 — Filnor, Oct 20 '17 at 08:05

Jacky Supit · Answer 1 · 2017-10-20T08:30:59.217

0

try this bro:

update, if count rows less then 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
    }
}

edited Oct 20 '17 at 08:30

answered Oct 20 '17 at 08:06

Jacky Supit

469
3
15

can you show us the result? and you expect? anyway, you should move to mysqli, mysql is already depreceated – Jacky Supit Oct 20 '17 at 08:19
– Nam Nguyen Oct 20 '17 at 08:19
I want result like this. – Nam Nguyen Oct 20 '17 at 08:20
have you tried my codes? can you show us the result of my codes? – Jacky Supit Oct 20 '17 at 08:20
please check again – Nam Nguyen Oct 20 '17 at 08:27
sorry bro, i forgot about the first row. please check my codes again – Jacky Supit Oct 20 '17 at 08:31
make sure you implement this: if ($x==1 || $x % 4 == 1) { – Jacky Supit Oct 20 '17 at 08:32
can you teamviewer? – Nam Nguyen Oct 20 '17 at 08:44
sure. just let me know if you still need it. sorry was outside before – Jacky Supit Oct 20 '17 at 09:19

Xpleria · Accepted Answer · 2017-10-20T09:09:34.730

0

This should work:

<?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
    }
?>

The last if is in case the total number of records weren't a multiple of 4, then we need to close the div tag.

And, not to mention, you should definitely use MySQLi. Why should I use MySQLi?

edited Oct 20 '17 at 09:09

answered Oct 20 '17 at 08:38

Xpleria

5,472
5
52
66

Updated again... The code is fairly simple and clean to read. Hope it helped. – Xpleria Oct 20 '17 at 08:55
still not working bro, here full code https://github.com/namntx/MinCSS/blob/master/stack.php – Nam Nguyen Oct 20 '17 at 09:07
Ah missed a php tag just before the `if($i % 4 == 3)`. Corrected it. Let me know if it works. – Xpleria Oct 20 '17 at 09:10
Please ^ upvote my answer if you liked it. Thank you! – Xpleria Oct 20 '17 at 09:13
Do you have skype? – Nam Nguyen Oct 20 '17 at 09:17
Email me. I'll write to you there. – Xpleria Oct 20 '17 at 09:19

score -1 · Answer 3 · answered Oct 20 '17 at 08:28

-1

Try this:

<?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 } ?>

answered Oct 20 '17 at 08:28

Minsher

11
2

product have been duplicate 4 – Nam Nguyen Oct 20 '17 at 08:31

While fetch row in PHP

3 Answers3