function insertStudent($student)
{
$id = $student->getId();
$name = $student->getName();
$gender = $student->getGender();
$age = $student->getAge();
$telephone = $student->getTelephone();
// 获得数据库连接
$conn = getConn();
// 定义SQL字符串 $sql = "INSERT INTO student(name,gender,telephone) VALUES ('$name','$gender','$telephone')";
echo $sql;
// 执行插入操作
$retval = $conn->query($sql);
return $retval;
}$name = $_POST['namex'];
$gender=$name_one.$filetype;
$telephone=$_SESSION['username'];
$student = new Student();
$student->setId($id);
$student->setName($name);
$student->setGender($gender);
$student->setAge($age);
$student->setTelephone($telephone); $retval = insertStudent($student);
if ($retval) {
echo "恭喜,记录插入成功!<br><br><br>";
} else {
echo "抱歉,记录插入失败!请返回重新上传.<br><br><br>";
}
/////////////////////////////////////////////////////////////////////
//以上是页面代码//
/////////////////////////////////////////////////////////////////////输出的SQL
INSERT INTO student([name],[gender],[telephone]) VALUES ('ds','20190625045295.jpg','李丹丹')
输出的SQL在查询分析器是对的
数据库表结构
{
$id = $student->getId();
$name = $student->getName();
$gender = $student->getGender();
$age = $student->getAge();
$telephone = $student->getTelephone();
// 获得数据库连接
$conn = getConn();
// 定义SQL字符串 $sql = "INSERT INTO student(name,gender,telephone) VALUES ('$name','$gender','$telephone')";
echo $sql;
// 执行插入操作
$retval = $conn->query($sql);
return $retval;
}$name = $_POST['namex'];
$gender=$name_one.$filetype;
$telephone=$_SESSION['username'];
$student = new Student();
$student->setId($id);
$student->setName($name);
$student->setGender($gender);
$student->setAge($age);
$student->setTelephone($telephone); $retval = insertStudent($student);
if ($retval) {
echo "恭喜,记录插入成功!<br><br><br>";
} else {
echo "抱歉,记录插入失败!请返回重新上传.<br><br><br>";
}
/////////////////////////////////////////////////////////////////////
//以上是页面代码//
/////////////////////////////////////////////////////////////////////输出的SQL
INSERT INTO student([name],[gender],[telephone]) VALUES ('ds','20190625045295.jpg','李丹丹')
输出的SQL在查询分析器是对的
数据库表结构
$conn = new mysqli($servername,$username,$password,$database);