php while mysql,While循环使用PHP与MySQL服务器

最新推荐文章于 2021-04-15 13:33:57 发布

幻世魔王

最新推荐文章于 2021-04-15 13:33:57 发布

阅读量106

点赞数

文章标签： php while mysql

本文介绍了如何使用PHP从SQL数据库中检索并显示多个记录。原始问题中，代码只显示了一条记录，因为mysql_fetch_array()在每次循环外只获取一行。解决方法是在while循环内调用mysql_fetch_array()，直到没有更多记录。这样可以正确显示所有记录。

摘要由CSDN通过智能技术生成

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.

CES Staff details

**code emitted**

$row = mysql_fetch_array($result) ;

$looping = 1;

$i = $row.length;

while ($looping <= $i)

{

echo $row["Name"].", Room ".$row["Room"].", Tel ".$row["Telephone"] ;

$looping++;

}

How would I change the while loop correctly so that it will display both records on the page.

Thanks!

解决方案

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

}