<?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);