While循环使用PHP与MySQL服务器 [英] While Loop using PHP with a MySQL server
问题描述
我有一个带有两个记录的表Staff的数据库(SQL)。我需要使用PHP在网页上显示这些记录的内容。
I have a database (SQL) with the table "Staff" with two records in it. I am required to display the contents of these records on a web page using PHP.
<html>
<head>
<title>CES Staff details</title>
</head>
<body>
**code emitted**
<?php
$row = mysql_fetch_array($result) ;
$looping = 1;
$i = $row.length;
while ($looping <= $i)
{
echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
$looping++;
}
?>
</body>
</html>
如何正确更改while循环,以便在页面上显示两条记录。
How would I change the while loop correctly so that it will display both records on the page.
谢谢!
Thanks!
推荐答案
mysql_fetch_array()
只能从数据库中检索一行。你需要在中调用它,而
循环来检索所有行。由于 mysql_fetch_array()
在没有更多行可用时返回false,因此 $循环
增量在此处不必要。
mysql_fetch_array()
only retrieves a single row from the database. You need to call it inside your while
loop to retrieve all rows. The $looping
increment is unnecessary here, since mysql_fetch_array()
returns false when no more rows are available.
while ($row = mysql_fetch_array($result))
{
echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;
}
这篇关于While循环使用PHP与MySQL服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!