随着php新版本的出现,用mysql_connect连接mysql数据库的方法逐渐弃用,改为了mysqli_connect,以下是mysqli_connect连接数据库的方法:
$conn = mysqli_connect('localhost', 'root', '', 'addressBook');//连接到数据库
//mysqli_query("set name 'utf-8'");
$sql = "select * from user";
$result = $conn->query($sql);
if ($result)
{
if ($result->num_rows>0)
{
while ($rows = $result->fetch_array()) {
print_r($rows);
echo "<BR>rows['id']:".$rows['id'];
echo "<BR>rows['name']:".$rows['name'];
echo "<BR>rows['pwd']:".$rows['pwd'];
}//end while()
}else{
echo "<BR>查询结果为空!";
}//end if()
}else{
echo "<BR>查询失败!";
}//end if()