Mysql rows to html table using for loop

Question

I tried to print the Mysql fetched rows into html table using php. However, when using the following code, the first fetched row is repeatedly printing. It looks like the $row hold the first fetched value. I found a similar problem here. But I would like to know about working with the for loop. Thanks

for ($j=0;$j<=$len2;$j++)
 {       

 $sql = "SELECT * FROM database_search WHERE gene_id LIKE'%$key%'";    

 $qry = $dbo->prepare($sql);
 $qry->execute();
 $row = $qry->fetch(PDO::FETCH_ASSOC);     
 $val = array_values($row);



echo "<tr>";
for ($k=0;$k<=4;$k++)
    { 
           $x=$val[$k];         
      echo "<td style=font-size:7.9px>$x</td>"; 

    }
echo "</tr>";

}

what does the variable $len2 doing? Inside the loop like condition $key is same, then wats the use of the loop? have you tried foreach($val as $res) {..} — Anto S
– Anto S, Commented Mar 18, 2015 at 4:56
This is possible that $row only have one record fetching from database and than your for ($k=0;$k<=4;$k++) loop print that only one record 5 time because you are using print under this loop, this loop will run 5 time. — Iffi
– Iffi, Commented Mar 18, 2015 at 5:02

winston86 · Accepted Answer · 2015-03-18 05:09:56Z

0

<table>
<?php
  while($row = $qry->fetch(PDO::FETCH_ASSOC)){
     echo '<tr>';
       foreach($row as $cell){ echo '<td>'.$cell.'</td>'; }
     echo '</tr>';
  } 
?>
</table>

answered Mar 18, 2015 at 5:09

winston86

1591 silver badge8 bronze badges

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

Comments

arkoak · Accepted Answer · 2015-03-18 05:00:47Z

0

After fetching the query as $row variable, you need to use the following code instead

foreach($row as $tr) {
    echo "<tr>";
    echo "<td style=font-size:7.9px>".$tr['col1']."</td>";  
    echo "<td style=font-size:7.9px>".$tr['col2']."</td>";  
    echo "</tr>";             
}

answered Mar 18, 2015 at 5:00

arkoak

2,4951 gold badge21 silver badges39 bronze badges

Comments

Iffi · Accepted Answer · 2015-03-18 05:06:34Z

0

This is possible that $row only have one record fetching from database and than your for ($k=0;$k<=4;$k++) loop print that only one record 5 time because you are using print under this loop, this loop will run 5 time.

Try the following code.

foreach($row as $val) {
    echo "<tr>";
    echo "<td style=font-size:7.9px>".$val['column Name']."</td>";  
    echo "</tr>";             
}

answered Mar 18, 2015 at 5:06

Iffi

5882 gold badges7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Mysql rows to html table using for loop

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related