PHP开发学生管理教程之修改

创建edit.php修改文件

功能流程如下

代码如下

<!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();
 $stu = mysqli_fetch_assoc($stmt); // 解析数据
 ?>
 <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>
<?php
?>
</body>
</html>

Weiter lernen

neue Datei

<!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> <?php ?> </body> </html>

einreichen Code zurücksetzen

Automatische Operation