<?php
header('content-type:text/html;charset=utf-8');
$link = mysqli_connect('localhost', 'root', '', 'test')
or die('Connect Error: ' . mysqli_connect_errno() . ': ' . mysqli_connect_error());
mysqli_set_charset($link, 'UTF8');
$sql = "SELECT id,username,password,age FROM user";
$result = mysqli_query($link, $sql);
if ($result && mysqli_num_rows($result)) {
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$rows[] = $row;
}
}
var_dump($rows);
//释放结果集
mysqli_free_result($result);
mysqli_close($link);
?>
Paste_Image.png
