具体实例如下:
$conn=@mysql_connect("localhost", "userName", "password") or die("Could not connect");
$rs = @mysql_select_db("my_database", $conn) or die("Could not select database");
$sql="select * from users";
$rs=mysql_query($sql,$conn) or die("Could not execute query");
$list = "
$list.="
First Name";$list.="
Last Name";$list.="
User Name";$list.="
Password";while($row= mysql_fetch_array($rs) )
{
$list .= "
";$list .= "
".$row["first_name"]."";$list .= "
".$row["last_name"]."";$list .= "
".$row["user_name"]."";$list .= "
".$row["password"]."";$list .= "
";}
$list .= "
";echo($list);
?>
代码解析:
mysql_connect函数用于连接服务器,mysql_select_db用于选中服务器中的某一个数据库,mysql_query执行sql语句,并返回一个资源类型,这个资源类型可以被函数mysql_fetch_array逐行获取数据,然后输出到浏览器。