Problem with while loop and html output

[saynotojava]

I have currently this code:

echo'<table border="1">';


    while($row = $ret->fetchArray(SQLITE3_ASSOC) ){

      echo '<tr><td>' .$row['Domain'].'</td><td><input type="checkbox" name="a[]" value="n"></td></tr>';


}
echo'</table>';

Which will output query from database and it will show output in that table format.But the problem is, when there is a lot of info pulled of,it look bad as a lot of space in unused then,so

i want to make it every fifth output to show in new line(compared to current where every output goes to new line).Also,output does'nt need to be with tables,i just want to make it look normaly aligned.

Edited October 9, 2013 by saynotojava

[PravinS]

Try replacing while loop using below code

$i = 1;
echo '<tr>';
while($row = $ret->fetchArray(SQLITE3_ASSOC) )
{
      echo '<td>' .$row['Domain'].'</td><td><input type="checkbox" name="a[]" value="n"></td>';
      if ($i % 5 == 0)
             echo '</tr><tr>';
      $i++;
}
echo '</tr>';

[Ch0cu3r]

echo'<table border="1">';


$col         = 0;		// column counter

$max_cols    = 5;               // how many columns per row


$tresults    = 0;               // results counter

$max_results = $ret->numRows(); // total number of results

while($row = $ret->fetchArray(SQLITE3_ASSOC)) {


    if($col == 0) // if col is 0, start new table row

        echo '<tr>';


        echo '<td>' .$row['Domain'].'</td><td><input type="checkbox" name="a[]" value="n"></td>'; // echo a column


        $col++;   // increment column counter

        $tresults++;  // increment results counter


        if($col == $max_cols) { // if col equals to max columns

            echo '</tr>';       // end table row

            $col = 0;           // reset column counter

        }

        elseif($tresults == $max_results && $col < $max_cols)           // if we have processed all results, but $col is still less than max number of columns

            echo str_repeat('<td></td>', $max_cols - $col) . '</tr>';   // then clean up table, output empty columns and end table row

}

echo'</table>';

Edited October 9, 2013 by Ch0cu3r

[Barand]

Alternative method using divs instead of table http://forums.phpfreaks.com/topic/282474-i-want-to-create-thumbnail-but-facing-problems/?do=findComment&comment=1451471

[saynotojava]

 

Try replacing while loop using below code

$i = 1;
echo '<tr>';
while($row = $ret->fetchArray(SQLITE3_ASSOC) )
{
      echo '<td>' .$row['Domain'].'</td><td><input type="checkbox" name="a[]" value="n"></td>';
      if ($i % 5 == 0)
             echo '</tr><tr>';
      $i++;
}
echo '</tr>';

Works as charm,thanks.I know it trick is in increment and if but didn't know how exactly to put it.

[cyberRobot]

In case you're interested, array_chuck() could be used to break the column groups. This doesn't require a counter. For an example which closely relates to your question, check out http://www.cyberscorpion.com/2013-08/build-html-tables-dynamically-with-php-part-2-simplify-with-array_chunk/

[Barand]

array_chunk()

[mac_gyver]

array_chunk()

 

his function name was probably because Halloween is coming - http://horror-movies.wikia.com/wiki/Chucky

[cyberRobot]

his function name was probably because Halloween is coming - http://horror-movies.wikia.com/wiki/Chucky

 

Hey, I didn't name the function. You can thank the developers of PHP. I am a Goonies fan, however, so "chunk" works for me. 

[cyberRobot]

array_chunk()

 

Ah, I finally got that...thanks for correcting the typo.