php链接数据库，获取数组数据

<?php

//链接数据库
$link = mysqli_connect('localhost','root','YES','mydb');
var_dump($link);

//设置字符集
mysqli_query($link,'set names utf8');

?>

<?php

//插入数据表数据
$link = mysqli_connect('localhost','root','YES','mydb');
mysqli_query($link,'set names utf8');
$spl = 'insert into user (uid, name, age) values (4,"zhan",20)';
$res = mysqli_query($link,$spl);
var_dump($res);

//链接数据库
$link = mysqli_connect('localhost','root','YES','mydb');
//设置字符集
mysqli_query($link,'set names utf8');
$sql = 'select * from user';
$res = mysqli_query($link,$sql);

//空数组
$re = array();
while ($row = mysqli_fetch_assoc($res)){
    $re[] = $row;
}
print_r($re);

?>