PHP development student management system to modify student information

Create edit.php and modify the file

Read the information in the database in the specified format and make corresponding modifications (using HTML and PHP), and then store the new data in the database

The code is as follows

edit.php file code

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生管理系统</title>
</head>
<body>
    <?php include ('menu.php');
 //1. 链接数据库
 header("content-type:text/html;charset=utf8");
 $conn=mysqli_connect("localhost","root","root","study");
    mysqli_set_charset($conn,"utf8");
$id=$_GET['id'];
 //2.执行sql
 $sql_select = "select * from stu where id='$id'";
 $stmt = mysqli_query($conn,$sql_select);
//    var_dump($stmt);
//    die();
 if ($stmt>0) {
 $stu = mysqli_fetch_assoc($stmt); // 解析数据
 }else{
 die("no have this id:{$_GET['id']}");
    }
 ?>
 <h3>修改学生信息</h3>
    <form action="action.php?action=edit" method="post">
        <input type="hidden" name="id" value="<?php echo $stu['id'];?>">
        <table>
            <tr>
                <td>姓名</td>
                <td><input type="text" name="name" value="<?php echo $stu['name'];?>"></td>
            </tr>
            <tr>
                <td>年龄</td>
                <td><input type="text" name="age" value="<?php echo $stu['age'];?>"></td>
            </tr>
            <tr>
                <td>性别</td>
                <td>
                    <input type="radio" name="sex" value="男" <?php echo ($stu['sex'] == "男")? "checked":"";?> >男
 </td>
                <td>
                    <input type="radio" name="sex" value="女" <?php echo ($stu['sex'] == "女")? "checked":"";?> >女
 </td>
            </tr>
            <tr>
                <td>班级</td>
                <td><input type="text" name="class" value="<?php echo $stu['class']?>"></td>
            </tr>
            <tr>
                <td> </td>
                <td><input type="submit" value="修改"></td>
                <td><input type="reset" value="重置"></td>
            </tr>
        </table>
    </form>
</body>
</html>

Resubmit the modified data on the modified page to the database

The code is as follows

<?php
header("content-type:text/html;charset=utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
            $id = $_POST['id'];
            $name = $_POST['name'];
            $age = $_POST['age'];
            $class = $_POST['class'];
            $sex = $_POST['sex'];
            $sql = "update stu set name='$name', age='$age',sex='$sex',class='$class' where id='$id';";
            $rw = mysqli_query($conn,$sql);
            if ($rw > 0){
                echo "<script>alert('修改成功');</script>";
            }else{
                echo "<script>alert('修改失败');</script>";
            }
            header('Location: index.php');
?>

This completes our modification function. The next step is our delete function

Continuing Learning

new file

<body> <meta charset="UTF-8"> <title>登陆界面</title> <h2>学生管理系统</h2> <a href="index.php"> 浏览学生</a> <a href="add.php"> 添加学生</a> <hr> <h3>修改学生信息</h3> <form action="action.php?action=edit" method="post"> <input name="id" value="3" type="hidden"> <table> <tbody><tr> <td>姓名</td> <td><input name="name" value="刘奇" type="text"></td> </tr> <tr> <td>年龄</td> <td><input name="age" value="12" type="text"></td> </tr> <tr> <td>性别</td> <td> <input name="sex" value="男" checked="" type="radio">男 </td> <td> <input name="sex" value="女" type="radio">女 </td> </tr> <tr> <td>班级</td> <td><input name="class" value="五年级" type="text"></td> </tr> <tr> <td> </td> <td><input value="修改" type="submit"></td> <td><input value="重置" type="reset"></td> </tr> </tbody></table> </form> </body>

submit Reset Code

Automatic operation

PHP development student management system to modify student information

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]