<?php
// 创建连接
$con = new mysqli("localhost","root","root", "mydb1");
// 检测连接
if ($con->connect_error) {
die("连接失败: " . $con->connect_error);
}
// 使用 sql 插入数据
$sql = "INSERT INTO User (name,password,sex,dob,email)
VALUES ('测试', '12345678','man','2016-3-3','test@example.com')";
if ($con->query($sql)) {
echo "数据插入成功";
} else {
echo "插入错误: " . $con->error;
}
//关闭连接
$con->close();
?>