10-1.php

来自「php开发实例完全剖析」· PHP 代码 · 共 28 行

<?php

$conn=mysql_connect("localhost","phpdb","phpdb")
        or die("不能连接数据库服务器： ".mysql_error());  	// line 1

mysql_select_db("test",$conn) or die ("不能选择数据库: ".mysql_error());	// line 2

$result = mysql_query("SELECT * FROM user",$conn);	// line 3

Print "Connect to MySQL database sucessfully!";	// line 4

echo "<br>";	// line 5
echo "<br>";	// line 6

while($row=mysql_fetch_row($result)){	// line 7

print "Name:".$row[1];	// line 8

print " Address:".$row[3];	// line 9

print " Tel:".$row[4];	// line 10

print " Email:".$row[5];	// line 11

echo "<br>";	// line 12
}	// line 13
?>