1 <?php
2 header("Content-Type:text/html;charset=utf-8");
3 //mysqli操作数据库
4 //1.创建对象
5 $mysqli = new mysqli ("localhost","root","","test");
6 //验证连接是否成功
7 if (!$mysqli){
8 # code...
9 die("连接失败".$mysqli->connect_error);
10 }
11 //2.操作数据库
12 $sql = "select * from user";
13 $res = $mysqli->query($sql);
14 // var_dump($res);
15 //3.处理结果
16 if ($res) {
17 # code...
18 //fetch_row()记得加上()
19 while ($row = $res->fetch_row()) {
20 # code...
21 foreach ($row as $key => $value) {
22 # code...
23 echo "$value--";
24 }
25 echo "<br />";
26 }
27 }else{
28 echo "失败";
29 }
30 //4.关闭资源
31 $res->free();
32 $mysqli->close();
33 ?>
