PHP development student management system add information PHP page
Receive the data passed from the add.php page and save the data to the database
Tip: This tutorial is to The PHP code for adding, modifying, and deleting is placed on the same PHP page. We used switch and case statements. The following code is the incomplete action.php file code. When we complete the adding, modifying, and deleting functions, it will Show the complete code to everyone
Link to our database first
header("content-type:text/html;charset=utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
Receive the data we pass from the add page Incoming information
$name = $_POST['name'];
$sex = $_POST['sex'];
$age = $_POST['age'] ;
$class = $_POST['class'];
$sex = $_POST['sex'];
$age = $_POST['age'] ;
$class = $_POST['class'];
Inserting data into our database
$sql = "insert into stu (` name`, sex, age, class) values ??('$name', '$sex','$age','$class')";
$rw = mysqli_query($conn,$sql);
$rw = mysqli_query($conn,$sql);
The code to add information is as follows
<?php
header("content-type:text/html;charset=utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
if($conn){
switch ($_GET['action']){
case 'add'://add
$name = $_POST['name'];
$sex = $_POST['sex'];
$age = $_POST['age'];
$class = $_POST['class'];
$sql = "insert into stu (`name`, sex, age, class) values ('$name', '$sex','$age','$class')";
$rw = mysqli_query($conn,$sql);
if ($rw > 0){
echo "<script>alert('添加成功');</script>";
}else{
echo "<script>alert('添加失敗');</script>";
}
}
}
header('Location: index.php');
break;
?>The next step is to display the information we added
##
