<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<html xmlns="http://www.w3.org/1999/xhtml ">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>temp</title>
</head>
<body>
<?php
//连接数据库的参数
$host = "localhost";
$user = "root";
$pass = "zq19890319";
$db = "flower";
//创建一个mysql连接
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect");
//选择一个数据库
mysql_select_db($db) or die("Unable to select database!");
//开始查询
$query = "select *from login";
//执行SQL语句
$result = mysql_query($query) or die("Error in query:$query.".mysql_error());
//显示返回的记录集行数
if(mysql_num_rows($result)>0){
echo "<table cellpadding=10 border=1>";
while($row=mysql_fetch_row($result)){
echo "<tr>";
echo "<td>".$row[0]."</td>";
echo "<td>".$row[1]."</td>";
echo "<td>".$row[2]."</td>";
}
echo "</table>";
}
else{
echo "记录未找到!";}
//释放记录集所占用的内存
mysql_free_result($result);
//关闭该数据库连接
mysql_close($connection);
?>
</body>
</html>