print php result in a nice html table

Question

my aim is to pull data from mysql and print it in html table. asumming that 1,2,3...8 are the data

<table style="width: 100%">
 <tr>
 <td>1</td>
 <td>2</td>
 <td>3</td>
 <td>4</td>
</tr>
 <tr>
 <td>5</td>
 <td>6</td>
 <td>7</td>
 <td>8</td>
 </tr>
</table>

this is the code i have so far but this will only print out the column but no the row. plz help. thank you

<table style="width: 100%; color:aqua">
<?php               
$showFoto = getFoto();
echo '<tr>';
foreach($showFoto as $Foto){
echo '<td class="afs"><img alt="" src="img/'.$Foto['img'].'.'.$Foto['ext'].'"><br>'.$Foto['about'].'</td>';
}
echo '</tr>';
?>
</table>

You need to wrap another loop around your <tr> just as you did with your <td>. — Aaron
– Aaron, Commented Feb 17, 2012 at 20:57
php.net/manual/fr/function.print-r.php if you go down there's a print_nice function. i used it for similar situations. — Charles Forest
– Charles Forest, Commented Feb 17, 2012 at 20:57
Your echo '<tr>'; and echo '</tr>'; are outside of any loop structure. — Jared Farrish
– Jared Farrish, Commented Feb 17, 2012 at 20:58

xkeshav · Accepted Answer · 2012-02-17 21:08:22Z

1

TRY

 <table width ="100%" style="color:aqua" cellpadding="2" cellspacing="2">
    <tr>
 <?php               
    $showFoto = getFoto();
    $i=0;
    foreach($showFoto as $Foto){
      ++$i;
      echo ($i%4==0) ? '</tr><tr>' :'';
      echo '<td class="afs">
            <img alt="" src="img/'.$Foto['img'].'.'.$Foto['ext'].'">'.$Foto['about'].
           '</td>';         
    }
    ?>
    </tr>
 </table>

edited Feb 17, 2012 at 21:08

answered Feb 17, 2012 at 21:02

xkeshav

54.2k47 gold badges183 silver badges254 bronze badges

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

Collectives™ on Stack Overflow

print php result in a nice html table

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related