我正在尝试从MySQL数据库中获取数据。我想随着数据库中数据的增加而增加行数,但标题行应该只有一个。就像典型的表格一样,但这里只需要动态增加 #row。
<?php
mysql_connect ("localhost","root","root123");
mysql_select_db ("iterrordb");
$sql = "select * from record";
$result = mysql_query ($sql);
$num=mysql_numrows($result);
while ($row = mysql_fetch_array($result))
{
$RecID= $row["RecordID"];
$DispName= $row["Name"];
$date= $row["date"];
$fleet= $row["phone"];
$issue= $row["issue"];
$issueRelatedTo= $row["issuRelatedTo"];
}
//HTML CODE is start from here
echo "<table border="1" bordercolor="#0066FF" style="background-color:#CCFFFF" width="50%" cellpadding="1" cellspacing="0">";
echo"<tr>";
echo"<td>Record ID</td>";
echo"<td>Name</td>";
echo"<td>Date</td>";
echo"<td>Phone</td>";
echo"<td>Issue</td>";
echo"<td>Issue Related To</td>";
echo"</tr>";
echo"<tr>";
for ($i=0; $i<6; $i++)
{
echo"<td> $row[$i]</td>";
}
echo"</tr>";
echo"</table>";
?>
将代码重写为
<?php
mysql_connect ("localhost","root","root123");
mysql_select_db ("iterrordb");
$sql = "select * from record";
$result = mysql_query ($sql);
$num=mysql_numrows($result);
//HTML CODE is start from here
echo "<table border="1" bordercolor="#0066FF" style="background-color:#CCFFFF" width="50%" cellpadding="1" cellspacing="0">";
echo"<tr>";
echo"<td>Record ID</td>";
echo"<td>Name</td>";
echo"<td>Date</td>";
echo"<td>Phone</td>";
echo"<td>Issue</td>";
echo"<td>Issue Related To</td>";
echo"</tr>";
while ($row = mysql_fetch_array($result))
{
$RecID= $row["RecordID"];
$DispName= $row["Name"];
$date= $row["date"];
$fleet= $row["phone"];
$issue= $row["issue"];
$issueRelatedTo= $row["issuRelatedTo"];
echo"<tr>";
for ($i=0; $i<6; $i++)
{
echo"<td> $row[$i]</td>";
}
echo"</tr>";
}
echo"</table>";
?>
以下代码似乎不相关,在当前上下文中,但无论如何我没有删除它
$RecID= $row["RecordID"];
$DispName= $row["Name"];
$date= $row["date"];
$fleet= $row["phone"];
$issue= $row["issue"];
$issueRelatedTo= $row["issuRelatedTo"];
我不确定你的意思。但是如果你想在查询结果中有行数,这将可以解决问题:
$num_rows = mysql_num_rows($result);
如果您想知道"while"循环中的当前行号是多少,只需添加一个迭代器即可。
如果要动态更新 html 表。使用 jQuery :
$('#my_table').empty().load("/examples/getTableRows.php");
您可以像每 5 秒调用一次此函数来更新表。