mysqli连接 数据库查询单条数据
<?php
// 假定数据库用户名:root,密码:root,数据库:tianxiangphp_v1.2
$con=mysqli_connect("localhost","root","root","tianxiangphp_v1.2");
if (mysqli_connect_errno($con))
{
echo "连接 MySQL 失败: " . mysqli_connect_error();
}
// 执行查询
$res = $con->query("SELECT * FROM userlist");
$data = mysqli_fetch_array($res);
echo "<pre>";
var_dump($data);
mysqli_close($con);
?>
query()与mysqli_query()使用
放在函数内与函数外
mysqli_query($con,”sql语句”);