连接数据库

<?php
header('content-type:text/html;charset=utf-8');

new实例化一个对象
使用面向对象mysql

$mysqli = @new mysqli("localhost","root","","myschool");
if($mysqli -> connect_error){
	die('连接数据库失败:' . $mysqli-> connect_error);
}

设置编码格式

$mysqli -> set_charset('utf8');

输入sql指令

$time = time();//当前时间的时间戳
$sql = "insert into user(id,user,pwd,create_time) values(null,'李四','123456',$time)";
echo $sql;

执行sql指令

$res=$mysqli->query($sql);
var_dump($res);
$n=$mysqli->affected_rows;
var_dump($n);
$mysqli->close();//关闭数据库连接
echo '关闭连接';