php插入数据库

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




?>