<?php
$servername="localhost";//服务
$username="root";
$password="";
$dbname="test";//库名
$conn=new mysqli($servername,$username,$password,$dbname);//创建对象
if ($conn->connect_error) {
die("connection failed".$conn->connect_error);
}
$conn->query("set names utf8");
$sql="insert into student(userid,name,sex) values (14504226,'张燕','女')";
if ($conn->query($sql) === TRUE) {//执行
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
?>
$servername="localhost";//服务
$username="root";
$password="";
$dbname="test";//库名
$conn=new mysqli($servername,$username,$password,$dbname);//创建对象
if ($conn->connect_error) {
die("connection failed".$conn->connect_error);
}
$conn->query("set names utf8");
$sql="insert into student(userid,name,sex) values (14504226,'张燕','女')";
if ($conn->query($sql) === TRUE) {//执行
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
?>