How to echo every after 9th iteration of a loop? First echo only counted 8 items

Question

My code is below:

function portfolio_gallery() {
    global $conn;   
    $query = $conn->query("SELECT codename, namegroup, features, title, showimage FROM portfolio ORDER BY id DESC");

    if ($query->num_rows > 0) {
        // output data of each row
        echo '<div>';
        $i = 0; 
        while($row = $query->fetch_assoc()) {
            $i++;
            if ($row["showimage"]) {

               if($i % 9 == 0){
                     echo '</div><div>';
            }

              echo '<a class="imgpop" href="images/portfolio/large/'.$row["codename"].'.jpg" rel="'.$row["namegroup"].'" title="'.$row["title"].' - '.$row["features"].'"><img src="images/portfolio/thumb/'.$row["codename"].'.jpg" alt="'.$row["title"].'" width="348"/><span class="imgpop-caption">'.$row["title"].'</span></a>';
              }

        }
        echo '</div>';
    }
}

portfolio_gallery();

I wanted to echo </div><div> for every after 9th item of the loop but every time I executed the code, the first echo only happened after 8 items instead of 9, but the rest was every 9th.

declare $i = 1 instead of 0; and write $i++ at the end of while loop. — Ravi Hirani, Jul 04 '16 at 10:05
By the way, you should move the `showimage` condition to your sql; there is no point in getting rows you are not going to use anyway. — jeroen, Jul 04 '16 at 10:07
@jeroen I forgot about that.. though it didn't solve the problem, but you're right. I changed it. Thanks. — hello, Jul 04 '16 at 10:40

score 0 · Answer 1 · answered Jul 04 '16 at 10:04

0

You have to increment

$i

after

if($i % 9 == 0)

answered Jul 04 '16 at 10:04

Zimm1

433
5
16

Ravi Hirani · Answer 2 · 2016-07-04T10:46:50.577

declare $i = 1 and Write $i++ at the end of while loop.

if ($query->num_rows > 0) {
    // output data of each row
    echo '<div>';
    $i = 1; // declare $i = 1 here
    while($row = $query->fetch_assoc()) {

        if ($row["showimage"]) {
           if($i % 9 == 1){ // 10 , 19 ,28
                 echo '</div><div>';
           }
           echo '<a class="imgpop" href="images/portfolio/large/'.$row["codename"].'.jpg" rel="'.$row["namegroup"].'" title="'.$row["title"].' - '.$row["features"].'"><img src="images/portfolio/thumb/'.$row["codename"].'.jpg" alt="'.$row["title"].'" width="348"/><span class="imgpop-caption">'.$row["title"].'</span></a>';
        }
        $i++; // increment at end of the loop
    }
    echo '</div>';
}

I did this and it counted every 9th, except for the first which echoed after no items, like so:`
` — hello, Jul 04 '16 at 10:34

score 0 · Answer 3 · answered Jul 04 '16 at 10:10

0

follow the syntax example i worked out its working

    <?php
    $j=0; 
    for($i=0;$i<=50;$i++)
    {
        if($j==9)
        {

            echo $j.'hioiiiiiii<br/>';  //echo "</div><div>";
         $j=-1; 
        }
       $j++;
    }

    ?>

answered Jul 04 '16 at 10:10

JYoThI

11,977
1
11
26

score 0 · Answer 4 · answered Jul 04 '16 at 10:13

Please try this :)

<?php 
 function portfolio_gallery() {
    global $conn;   
    $query = $conn->query("SELECT codename, namegroup, features, title, showimage FROM portfolio ORDER BY id DESC");

if ($query->num_rows > 0) {
    // output data of each row
    echo '<div>';
    $i = 0;
    while($row = $query->fetch_assoc()) {
        if ($row["showimage"]) {

           if($i % 9 == 0){
                echo '</div><div>';
            }

            echo '<a class="imgpop" href="images/portfolio/large/'.$row["codename"].'.jpg" rel="'.$row["namegroup"].'" title="'.$row["title"].' - '.$row["features"].'"><img src="images/portfolio/thumb/'.$row["codename"].'.jpg" alt="'.$row["title"].'" width="348"/><span class="imgpop-caption">'.$row["title"].'</span></a>';
        }
    $i++;
    }
    echo '</div>';
}

}

I tried this but the first echo returned after 4 items. – hello Jul 04 '16 at 10:22 — hello, Jul 04 '16 at 10:22

hello · Accepted Answer · 2016-07-05T08:52:47.063

0

I was able to solve it by modifying the condition:

So instead of: if($i % 9 == 0) {...}

I used: if($i!=0 && $i % 9 == 0) {...}

And also placing $i++ at the end of while loop.

edited Jul 05 '16 at 08:52

answered Jul 05 '16 at 08:24

hello

351
3
4
16

How to echo every after 9th iteration of a loop? First echo only counted 8 items

5 Answers5