PHP while loop echo every 3 rows

Question

I am trying to display something after 3 rows from my database, but having a hard time to get this to work.

this is my code at the moment

<?php 
$query = "SELECT * FROM articles ORDER BY id DESC LIMIT 6";
$stmt = $con->prepare($query);
$stmt->execute();
$num = $stmt->rowCount();
if ($num>0) {
   while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
      extract($row);

      echo "DATA FROM DATABASE";

      if (($num % 3) == 0) {
         echo '<h1>code every 3 rows</h1>';
      }
      $num++;
   }
}
// if no records found
else{
   echo "no data found";
}
?>

Currently, this is outputting after every row 1 and 4.

I have tried the following.

if ($num % 3) {
   echo '<h1>code every 3 rows</h1>';
}
$num++;

This outputs after rows 2 3 5

I am sure its something simple I'm over looking but any help in pointing me in the right direction would be great.

I would suggest dropping the extract($row); and use the values from the array directly instead. — Nigel Ren
– Nigel Ren, Commented Feb 12, 2023 at 10:22

Wisdom Ighofose · Accepted Answer · 2023-02-12 10:21:17Z

3

Your error can be found where you initialized $num. you set it to row count and start increasing the $num in the loop. You code should be refactor like so:

<?php 
$query = "SELECT * FROM articles ORDER BY id DESC LIMIT 6";
$stmt = $con->prepare($query);
$stmt->execute();
$count = $stmt->rowCount();

//$num should start from 1 and increase in the loop
$num = 1;
if($count>0){
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
extract($row);

echo "DATA FROM DATABASE";


if( ($num % 3) == 0){
echo '<h1>code every 3 rows</h1>';
}
$num++;
}
}
// if no records found
else{
echo "no data found";
}
?>

edited Feb 12, 2023 at 10:21

answered Feb 12, 2023 at 10:18

Wisdom Ighofose

3573 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nashie Over a year ago

thanks that makes perfect sense; I have a habit of over thinking things. thanks again.

Syscall · Accepted Answer · 2023-02-12 10:13:51Z

2

You can use ($num - 1) % 3 == 2:

if (($num - 1) % 3 == 2) {
   echo '<h1>code every 3 rows</h1>';
}
$num++;
echo "DATA FROM DATABASE";

Example:

foreach (range(0, 6) as $k => $i) {
    if (($k - 1) % 3 == 2) {
        echo "---\n";
    }
    echo "$i\n";
}

output:

0
1
2
---
3
4
5
---
6

Or $k % 3 == 2 if you do the echo before:

foreach (range(0, 6) as $k => $item) {
    echo "$item\n";
    if ($k % 3 == 2) {
        echo "---\n";
    }
}

edited Feb 12, 2023 at 10:13

answered Feb 12, 2023 at 10:07

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

Collectives™ on Stack Overflow

PHP while loop echo every 3 rows

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related