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