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