Operasi pangkalan data tutorial pengurusan pelajar pembangunan PHP
Buat fail action.php
Fail ini menggunakan penyataan suis dan kes untuk memproses data seperti pemadaman, pengubahsuaian dan penambahan pada halaman yang sama, pertindihan kod dikurangkan
Kod adalah seperti berikut
<?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;
case 'del'://get
$id = $_GET['id'];
$sql = "delete from stu where id='$id'";
$rw = mysqli_query($conn,$sql);
if ($rw > 0){
echo "<script>alert('刪除成功');</script>";
}else{
echo "<script>alert('刪除失敗');</script>";
}
header('Location: index.php');
break;
case 'edit'://post
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
$class = $_POST['class'];
$sex = $_POST['sex'];
// echo $id, $age, $age, $name;
$sql = "update stu set name='$name', age='$age',sex='$sex',class='$class' where id='$id';";
// $sql = "update myapp.stu set name='jike',sex='女', age=24,classid=44 where id=17";
// print $sql;
$rw = mysqli_query($conn,$sql);
// var_dump($rw);
// die();
if ($rw > 0){
echo "<script>alert('更新成功');</script>";
}else{
echo "<script>alert('更新失敗');</script>";
}
header('Location: index.php');
break;
default:
header('Location: index.php');
break;
}
}else{
die('數(shù)據(jù)庫(kù)連接失敗' .mysqli_connect_error());
}
?>
