PDO实现学生管理系统

这里实现一个简单的学生管理系统

需要建立如下文件：

• index.php
• menu.php //菜单栏
• add.php  //添加数据
• edit.php // 编辑数据
• action.php // 添加，删除，编辑的实现

分别写一下每个文件的代码：

menu.php:

<html>
<h2>学生信息管理</h2>
<a href="index.php">浏览学生</a>
<a href="add.php">增加学生</a>
<hr>
</html>

index.php

<html>
    <head>
        <meta charset="UTF-8">
        <title>学生信息管理系统</title>
    </head>
    <script>
        function doDel(id){
            if(confirm("是否要删除")){
                window.location='action.php?action=del&id='+id;
            }
        }
    </script>
    <body>
        <center>
            <?php include("menu.php");?>
            <h3>浏览学生信息</h3>
            <table width="600" border="1">
                <tr>
                    <th>ID</th>
                    <th>姓名</th>
                    <th>姓别</th>
                    <th>年龄</th>
                    <th>班级</th>
                    <th>操作</th>
                </tr>
                <?php
                    //1. 连接数据库
                    try{
                        $pdo = new PDO("mysql:host=localhost;dbname=myapp;", "root", "");

                    }catch(PDOException $e){
                        die("fail to connect db".$e->getMessage());
                    }
                    //2. 执行数据库，并解析遍历
                    $sql = "SELECT * FROM users";
                    foreach($pdo->query($sql) as $val){
                        echo "<tr>";
                        echo "<td>{$val['id']}</td>";
                        echo "<td>{$val['name']}</td>";
                        echo "<td>{$val['sex']}</td>";
                        echo "<td>{$val['age']}</td>";
                        echo "<td>{$val['class']}</td>";
                        echo "<td>
                                 <a href='javascript:doDel({$val['id']})'>删除</a>
                                 <a href='edit.php?id={$val['id']}'>修改</a>
                              </td>";
                        echo "</tr>";
                    }
                ?>
            </table>

        </center>
    </body>
</html>

add.php

<html>
<head>
    <meta charset="UTF-8">
    <title>学生信息管理系统</title>
</head>
<body>
<center>
    <?php include("menu.php");?>
    <h3>增加学生信息</h3>
    <form action="action.php?action=add" method="post">
        <table>
            <tr>
                <td>姓名</td>
                <td><input type="text" name="name"/></td>
            </tr>

            <tr>
                <td>姓别</td>
                <td>
                    <input type="radio" name="sex" value="m"/>男
                    <input type="radio" name="sex" value="w"/>女
                </td>

            </tr>

            <tr>
                <td>年龄</td>
                <td><input type="text" name="age"/></td>
            </tr>

            <tr>
                <td>班级</td>
                <td><input type="text" name="class"/></td>
            </tr>

            <tr>
                <td> </td>
                <td>
                    <input type="submit" value="增加"/>
                    <input type="submit" value="重置"/>
                </td>

            </tr>
        </table>
    </form>
</center>
</body>
</html>

edit.php

<html>
<head>
    <meta charset="UTF-8">
    <title>学生信息管理系统</title>
</head>
<body>
<center>
    <?php include("menu.php");
    //获取修改信息
    //1. 连接数据库
    try{
        $pdo = new PDO("mysql:host=localhost;dbname=myapp;", "root", "");

    }catch(PDOException $e){
        die("fail to connect db".$e->getMessage());
    }
    //2. 拼装sql语句，取出信息
    $sql = "SELECT * FROM users WHERE id=".$_GET['id'];
    $stmt = $pdo->query($sql);
    if($stmt->rowCount() > 0){
        $stu = $stmt->fetch(PDO::FETCH_ASSOC);  //解析数据
    }else{
        die("没有修改的信息");
    }
    ?>
    <h3>修改学生信息</h3>
    <form action="action.php?action=edit" method="post">
    <!--   以隐藏域的方式添加id     -->
        <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="radio" name="sex" value="m" <?php echo ($stu['sex']==
                        "m")? "checked": ""; ?>/>男
                    <input type="radio" name="sex" value="w" <?php echo ($stu['sex']==
                        "w")? "checked": ""; ?>/>女
                </td>

            </tr>

            <tr>
                <td>年龄</td>
                <td><input type="text" name="age" value="<?php echo $stu['age'];?>"/></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="修改"/>
                    <input type="submit" value="重置"/>
                </td>

            </tr>
        </table>
    </form>
</center>
</body>
</html>

action.php

<?php
//1. 连接数据库
try{
    $pdo = new PDO("mysql:host=localhost;dbname=myapp;", "root", "");

}catch(PDOException $e){
    die("fail to connect db".$e->getMessage());
}
//2. 通过action的值做相应的操作
switch($_GET['action']){
    case "add": //增加操作
        $name = $_POST['name'];
        $sex = $_POST['sex'];
        $age = $_POST['age'];
        $class = $_POST['class'];

        $sql = "INSERT INTO users VALUES (null, '{$name}','{$sex}', '{$age}', '{$class}')";
        $rw = $pdo->exec($sql);
        if($rw > 0){
            echo "<script>alert('增加成功'); window.location='index.php'</script>";
        }else{
            echo "<script>alert('增加失败'); window.history.back()</script>";
        }
        break;
    case "del":
        $id = $_GET['id'];
        $sql = "DELETE FROM users WHERE id={$id}";
        $pdo->exec($sql);
        header("location:index.php");
        break;
    case "edit":
        $name = $_POST['name'];
        $sex = $_POST['sex'];
        $age = $_POST['age'];
        $class = $_POST['class'];
        $id = $_POST['id'];

        $sql = "UPDATE users SET name='{$name}',sex='{$sex}',age={$age},class={$class}
                WHERE id={$id}";
        $rw = $pdo->exec($sql);
        if($rw > 0){
            echo "<script>alert('修改成功'); window.location='index.php'</script>";
        }else{
            echo "<script>alert('修改失败'); window.history.back()</script>";
        }
        break;
}