MYSQL查询

<?php
header("Content-type: text/html; charset=utf-8");

$conn = mysqli_connect("localhost", "root", "123456", "test002");
if (!$conn) {
    die("连接失败" . mysql_error());
} else {
    echo "Success!";
}

//mysqli_select_db($conn,"test001");
$sql = "select * from user1";
//解决中文乱码；
mysqli_query($conn, "set names utf8");
$res = mysqli_query($conn, $sql);
//var_dump($res);

while ($row = mysqli_fetch_row($res)) {
   //echo "<br>$row[0]--$row[1]--$row[2]";
    //var_dump($row);
    foreach($row as $key=>$val){
        echo "--$val";

    }
    echo "<br>";
}

$res1 = mysqli_query($conn, $sql);

$row001=mysqli_fetch_row($res1);
print_r($row001);
$row002=mysqli_fetch_array($res1,MYSQL_ASSOC);
echo "<br>";
print_r($row002);
//指针复位；
mysqli_data_seek($res1,0);

while ($row = mysqli_fetch_row($res1)) {
    echo "<br>$row[0]--$row[1]--$row[2]";
}
//清理内存，关闭连接；
mysqli_free_result($res1);
mysqli_close($conn);