国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

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

5.jpg

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ù)庫連接失敗' .mysqli_connect_error());
}
?>






Meneruskan pembelajaran
||
<?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ù)庫連接失敗' .mysqli_connect_error()); } ?>