使用for循环将Mysql行转换为html表 [英] Mysql rows to html table using for loop

问题描述

我尝试使用 php 将 Mysql 提取的行打印到 html 表中.但是，当使用以下代码时，第一个提取的行会重复打印.看起来 $row 保存了第一个提取的值.我在此处发现了类似的问题.但我想知道如何使用 for 循环.谢谢

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>";

}

推荐答案

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

这篇关于使用for循环将Mysql行转换为html表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！