锦中迎新管理系统

CREATE TABLE students (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

student_id VARCHAR(20) UNIQUE NOT NULL,

major VARCHAR(50),

phone VARCHAR(15)

);

<form action="insert_student.php" method="POST">

姓名: <input type="text" name="name"><br>

学号: <input type="text" name="student_id"><br>

专业: <input type="text" name="major"><br>

手机: <input type="text" name="phone"><br>

<input type="submit" value="提交">

融合服务门户

</form>

$conn = new mysqli("localhost", "root", "", "university");

if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}

$sql = "INSERT INTO students (name, student_id, major, phone) VALUES ('".$_POST['name']."', '".$_POST['student_id']."', '".$_POST['major']."', '".$_POST['phone']."')";

if ($conn->query($sql) === TRUE) {

echo "记录插入成功";

} else {

echo "Error: " . $sql . "
" . $conn->error;

}

$conn->close();