PHP 六脉神剑

<?php//1.连接数据库并判断$link = @mysqli_connect('127.0.0.1', 'root', '123', 'xxoo') or die('数据库连接失败：'.mysqli_connect_error());// var_dump($link);//2.设置字符集mysqli_set_charset($link, 'utf8');//3.准备sql语句$sql = 'select * from stu';//4.发送sql语句$res = mysqli_query($link, $sql);var_dump($res);//5.处理结果集$arr = [];if ($res && mysqli_num_rows($res)) {// //1.读取1条结果为混合数组// $row = mysqli_fetch_array($res);// //2.读取1条结果为关联数组(常用)// $row = mysqli_fetch_assoc($res);// //3.索引数组// $row = mysqli_fetch_row($res);// var_dump($row);// while ($row = mysqli_fetch_assoc($res)) {// $arr[] = $row;// }//读取结果集中所有数据$array = mysqli_fetch_all($res, MYSQLI_ASSOC);}var_dump($array);var_dump($arr);//6.关闭数据连接mysqli_close($link);