<div class="codebody" id="code69138">
1 <!----使用mysql_fetch_array()来获取数据：mysql_fetch_array.php---->
2 <?PHP
3 //连接并选择到数据库服务器
4 $connection = MysqL_connect ("localhost","root","password");
5 MysqL_select_db("Books",$connection);
6 //查询数据
7 $query="SELECT * FROM Computers ";
8 $query.="WHERE price >= 20";
9 //echo $query."
";
10 $result=MysqL_query($query,$connection);
11 //MysqL_fetch_array()获得数据，并输出
12 while($row=MysqL_fetch_array($result))
13 {
14 echo "书名： ".$row[1]."
";
15 echo "价格： ".$row["price"]."
";
16 echo "出版日期： ".$row["publish_date"]."
";
17 echo "
";
18 }
19 ?>