使用MySQLi和PHP的HTML表 [英] HTML table using MySQLi and PHP
本文介绍了使用MySQLi和PHP的HTML表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将一个表连接到我的数据库,以便可以使用该数据库中的信息.
I'm trying to make a table connected to my database so I can use the information in that database.
我认为我的方法正确,但是目前该表仅显示第一行.任何人都对发生的事情有任何想法吗?
I think I'm on the right way, but currently the table only displays the first row. Anyone got any ideas on what's going on?
<table id="fairtable">
<tr>
<td>Fair Name</td>
<td>Date</td>
<td>Are we there?</td>
<td>Website</td>
</tr>
<?php
$sql = "SELECT `name`,`date`,`present`,`website` FROM `dates`";
$results = mysqli_query($conn,$sql);
while($rowitem = mysqli_fetch_array($results)) {
echo "<tr>";
echo "<td>" . $rowitem['name'] . "</td>";
echo "<td>" . $rowitem['date'] . "</td>";
echo "<td>" . $rowitem['present'] . "</td>";
echo "<td>" . $rowitem['website'] . "</td>";
echo "</tr>";
}
?>
</table>
推荐答案
这也许是因为您没有正确打开HTML表标签,这很容易忽略.还可以在白色语句中循环结果集:
Perhaps this is because you have not opened your HTML table tags correctly, its an easy thing to overlook. Also loop the result set inside a white statement:
$sql = "SELECT `name`,`date`,`present`,`website` FROM `dates`";
$results = mysqli_query($conn,$sql);
echo "<table>"; //begin table tag...
//you can add thead tag here if you want your table to have column headers
while($rowitem = mysqli_fetch_array($results)) {
echo "<tr>";
echo "<td>" . $rowitem['name'] . "</td>";
echo "<td>" . $rowitem['date'] . "</td>";
echo "<td>" . $rowitem['present'] . "</td>";
echo "<td>" . $rowitem['website'] . "</td>";*/
echo "</tr>";
}
echo "</table>"; //end table tag
这篇关于使用MySQLi和PHP的HTML表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文