Insert HTML wrapper after every third in while loop in php

Question

I have some 'html' contents to display in php while loop. However, I want to have only 3 content blocks in every row and rendered html should be something like below:

<div class="row">
  <div>Content Block</div>
  <div>Content Block</div>  
  <div>Content Block</div>
</div>
<div class="row">
  <div>Content Block</div>
  <div>Content Block</div>
  <div>Content Block</div>
</div>
<div class="row">
  <div>Content Block</div>
  <div>Content Block</div>
  <div>Content Block</div>
</div>

This is how I tried it:

$output=[];    
$i=0; 
$html='';
while($row = $stmt->fetch()) {    

  if($i % 3 == 0) {
    $html .= "<div class='row'>\n";
  }

  $html.="<div class='col-sm-4'>
            <div class='room-box'>
              <img src='$thumb' class='img-responsive' >
              <h4>$name</h4>
            </div>
          </div>\n";

  if($i++ % 3 == 2) { 
    $html .= "</div>\n";
    $output[] = $html;
  }
}

But its not working for me. Can anybody tell me What am I doing wrong? Thank you

What are you getting so far with the code you're testing?

dvr
– dvr

2018-01-28 08:03:44 +00:00
Commented Jan 28, 2018 at 8:03 — dvr
– dvr, Commented Jan 28, 2018 at 8:03

The fourth bird · Accepted Answer · 2018-01-28 13:46:44Z

1

I think you have to reset the $html = ''; in the while loop after you have added it to the $output=[];

while($row = $stmt->fetch()) {

    if($i % 3 === 0) {
        $html .= "<div class='row'>\n";
    }

    $html.="<div class='col-sm-4'>
            <div class='room-box'>
              <img src='$thumb' class='img-responsive' >
              <h4>$name</h4>
            </div>
          </div>\n";

    if($i++ % 3 === 2) {
        $html .= "</div>\n";
        $output[] = $html;
        $html = '';
    }
}

Test output

Note: When you have for example 11 items, you will miss the last 2.

If you also want to add the last 2, you could add this after the while loop which will check if $html is not an empty string :

if ($html !== '') {
    $html .= "</div>\n";
    $output[] = $html;
}

Output php

edited Jan 28, 2018 at 13:46

answered Jan 28, 2018 at 10:01

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

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

2 Comments

user3733831 Over a year ago

yes, it miss the last 2. can you tell how its get last 2 also?

The fourth bird Over a year ago

@user3733831 I have updated my answer on how to include the last 2.

Sohel0415 · Accepted Answer · 2018-01-28 11:27:36Z

1

try this-

$output=[];    
$i=0; 
$html='';
while($row = $stmt->fetch()) {    

  if($i % 3 == 0) {
    $html .= "<div class='row'>\n";
  }

$html .="<div class='col-sm-4'>
        <div class='room-box'>
          <img src='$thumb' class='img-responsive' >
          <h4>$name</h4>
        </div>
      </div>\n";

   if($i % 3 == 2) { 
      $html .= "</div>\n";
      $output[] = $html;
      $html = '';
   }
  $i++;
}
if($i%3!=0){
  $html .= "</div>\n";
  $output[] = $html;
  $html = '';
}

edited Jan 28, 2018 at 11:27

answered Jan 28, 2018 at 8:04

Sohel0415

9,89124 silver badges32 bronze badges

Comments

sorak · Accepted Answer · 2018-01-28 08:36:17Z

0

Maybe the issue is mostly how you're trying to access the variables:

$output=[];    
$i=0; 
$html='';
while($row = $stmt->fetch()) {    

  if($i % 3 == 0) {
    $html .= "<div class='row'>\n";
  }

  $html.="<div class='col-sm-4'>
            <div class='room-box'>
              <img src='{$row['thumb']}' class='img-responsive'>
              <h4>{$row['name']}</h4>
            </div>
          </div>\n";

  if ($i % 3 == 2) { 
    $html .= "</div>\n";
    $output[] = $html;
  }
  $i++;
}

Do the records have fields called thumb and name?

answered Jan 28, 2018 at 8:36

sorak

2,6332 gold badges19 silver badges24 bronze badges

Collectives™ on Stack Overflow

Insert HTML wrapper after every third in while loop in php

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related