PHP连接MySQL

最新推荐文章于 2021-02-01 12:48:48 发布

最新推荐文章于 2021-02-01 12:48:48 发布 · 78 阅读

文章标签：

<!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>