文件:mysqliDemo.php
<?php
header("Content-type:text/html;charset=utf-8");
//mysqli操作mysql数据库(面向对象风格)
//1.创建MySQLi对象 链接数据库
$mysqli = new MySQLi("localhost","root","xxxx","test");
//验证链接是否成功
if($mysqli->connect_error){
die("链接失败!".$mysqli->connect_error);
return;
}else{
echo "链接成功!"."<br/>";
}
//2,操作数据库(发送sql)
$sql = "select * from user1";
$mysqli->query("set names utf8");
$res = $mysqli->query($sql);
//var_dump($res);
//3,处理结果
while($row=$res->fetch_row()){
foreach($row as $key=>$val){
echo "--$val";
}
echo "<br/>";
}
//4.释放内存
$res->free();
//关闭链接
$mysqli->close();
?>