PHP学生信息管理系统

参考：http://www.jb51.net/article/62766.htm

index.php        获取用户信息的表单<!DOCTYPE html>
<html>
        <head>
                <title>学生管理系统</title>
                <meta charset="utf-8"/>
        </head>
        <body>
                <center>
                <h2>学生管理系统</h2>
                <a href='index.php'>添加信息</a> |
                <a href='show.php'>查看信息</a>
                <hr/>
                <h3>添加信息表单</h3>
                <form action="doAction.php?a=insert" method="post">
                        姓名：<input type="text" name="uname" value=""/><br/><br/>
                        性别：<input type="radio" name="usex" value="w"/> 女
                                  <input type="radio" name="usex" value="m"/> 男<br/><br/>
                        年龄：<input type="text" name="uage" value=""/><br/><br/>
                        手机：<input type="text" name="uphone" value=""/><br/><br/>
                        邮箱：<input type="email" name="uemail" value=""/><br/><br/>
                        婚否：<input type="radio" name="uhunfou" value="y"/> 已婚
                                  <input type="radio" name="uhunfou" value="n"/> 未婚<br/><br/>
                        Q  Q：<input type="text" name="uqq" value=""/><br/><br/>
                        小组：<input type="text" name="uteam" value=""/><br/><br/>
                        <input type="submit" value="提交"/>
                        <input type="reset" value="重置"/>
                </form>
                </center>
        </body>
</html>doAction.php        将用户信息存储到数据库中

<?php
        //根据用户的动作，执行相应的操作        //1. 连接服务器，并判断是否成功
                $link = mysqli_connect("localhost","root","") or die("连接数据库失败！");

        //2. 设置字符集
                mysqli_set_charset($link,"utf8");

        //3. 选择数据库
                mysqli_select_db($link,"lamp165");

        switch($_GET['a']){
                case "insert":        //用户添加操作

                        //4. 定义sql语句，并发送执行

                                //获取用户提交的信息
                                $uname = $_POST['uname'];
                                $usex = $_POST['usex'];
                                $uage = $_POST['uage'];
                                $uphone = $_POST['uphone'];
                                $uemail = $_POST['uemail'];
                                $uhunfou = $_POST['uhunfou'];
                                $uqq = $_POST['uqq'];
                                $uteam = $_POST['uteam'];

                                $sql = "insert into stu (name,sex,age,phone,email,hunfou,qq,team) values
                                ('{$uname}','{$usex}',{$uage},'{$uphone}','{$uemail}','{$uhunfou}','{$uqq}','{$uteam}')";
                                $boolean = mysqli_query($link,$sql);

                        //5. 判断是否执行成功
                                if($boolean!=false && mysqli_affected_rows($link)>0){

                                        //告诉用户添加成功
                                        echo "<script>alert('恭喜你，添加成功！');window.location.href='show.php'</script>";

                                }else{

                                        //告诉用户添加失败
                                        echo "<script>alert('很抱歉，添加失败！');window.location.href='index.php'</script>";
                                        die;
                                }

                        //6. 关闭数据库
                                mysqli_close($link);
                break;

                case "update":        //执行学生信息修改

                        //获取要修改信息的学生的id号
                        $id = $_GET['id'];

                        //获取用户修改后的数据
                        $uname = $_POST['uname'];
                        $usex = $_POST['usex'];
                        $uage = $_POST['uage'];
                        $uphone = $_POST['uphone'];
                        $uemail = $_POST['uemail'];
                        $uhunfou = $_POST['uhunfou'];
                        $uqq = $_POST['uqq'];
                        $uteam = $_POST['uteam'];

                        //定义sql语句，并发送执行
                        $sql = "update stu set name='{$uname}',sex='{$usex}',age={$uage},phone='{$uphone}',email='{$uemail}',hunfou='{$uhunfou}',qq='{$uqq}',team='{$uteam}' where id={$id}";
                        $boolean = mysqli_query($link,$sql);

                        //判断是否修改成功
                        if($boolean!=false && mysqli_affected_rows($link)>0){

                                //告知用户，修改成功
                                echo "<script>alert('恭喜，修改成功！');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";

                        }else{

                                //告知用户，修改失败！
                                echo "<script>alert('恭喜，修改失败！');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";

                        }

                break;

                case "delete":        //执行用户删除的动作

                        //获取要删除的用户的id
                        $id = $_GET['id'];

                        //定义sql语句，并发送执行
                        $sql = "delete from stu where id={$id}";
                        $boolean = mysqli_query($link,$sql);

                        //判断是否删除成功
                        if($boolean!=false && mysqli_affected_rows($link)>0){

                                //告知用户，删除成功
                                echo "<script>alert('恭喜，删除成功！');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";

                        }else{

                                //告知用户，删除失败
                                echo "<script>alert('恭喜，删除失败！');window.location.href='{$_SERVER['HTTP_REFERER']}'</script>";

                        }

                break;
        }
?>

show.php        用于显示用户信息页面

<!DOCTYPE html>
<html>
        <head>
                <title>学生管理系统</title>
                <meta charset="utf-8"/>
        </head>
        <body>
                <center>
                <h2>学生管理系统</h2>
                <a href='index.php'>添加信息</a> |
                <a href='show.php'>查看信息</a>
                <hr/>
                <h3>查看学生信息</h3>
                <table border='1' width='1200'>
                        <tr>
                                <th>ID</th>
                                <th>姓名</th>
                                <th>性别</th>
                                <th>年龄</th>
                                <th>手机</th>
                                <th>邮箱</th>
                                <th>婚否</th>
                                <th>QQ</th>
                                <th>小组</th>
                                <th>操作</th>
                        </tr>
                        
                        <?php                                 //1. 连接服务器并判断是否成功
                                        $link = mysqli_connect("localhost","root","") or die("连接数据库失败！");

                                //2. 设置字符集
                                        mysqli_set_charset($link,"utf8");

                                //3. 选择数据库
                                        mysqli_select_db($link,"lamp165");

                                //4. 定义sql语句，并发送执行
                                        $sql = "select * from stu";
                                        $result = mysqli_query($link,$sql);

                                //5. 解析结果集
                                        if($result!=false && mysqli_num_rows($result)>0){

                                                //四种解析方式
                                                while($rows = mysqli_fetch_assoc($result)){

                                                        echo "<tr align='center'>";
                                                                echo "<td>{$rows['id']}</td>";
                                                                echo "<td>{$rows['name']}</td>";
                                                                echo "<td>".($rows['sex']=='w'?'女':'男')."</td>";
                                                                echo "<td>{$rows['age']}</td>";
                                                                echo "<td>{$rows['phone']}</td>";
                                                                echo "<td>{$rows['email']}</td>";
                                                                echo "<td>".($rows['hunfou']=='y'?'已婚':'未婚')."</td>";
                                                                echo "<td>{$rows['qq']}</td>";
                                                                echo "<td>{$rows['team']}</td>";
                                                                echo "<td>
                                                                              <a href='edit.php?id={$rows['id']}'>编辑</a>
                                                                              <a href='doAction.php?a=delete&id={$rows['id']}'>删除</a>
                                                                          </td>";
                                                        echo "</tr>";

                                                }

                                        }

                                //6. 释放结果集，关闭数据库
                                        mysqli_free_result($result);
                                        mysqli_close($link);
                        ?>
                </table>
                </center>
        </body>
</html>edit.php        用于修改用户信息的页面

<!DOCTYPE html>
<html>
        <head>
                <title>学生管理系统</title>
                <meta charset="utf-8"/>
        </head>
        <body>
                <center>
                <h2>学生管理系统</h2>
                <a href='index.php'>添加信息</a> |
                <a href='show.php'>查看信息</a>
                <hr/>
                <h3>编辑学生信息</h3>
                <?php
                        //接收要修改学生的id号
                        $id = $_GET['id'];
                                                //1. 连接数据库，并判断
                        $link = mysqli_connect("localhost","root","") or die("数据库连接失败！");

                        //2. 设置字符集
                        mysqli_set_charset($link,"utf8");

                        //3. 选择数据库
                        mysqli_select_db($link,"lamp165");

                        //4. 定义sql语句，并发送执行
                        $sql = "select * from stu where id={$id}";
                        $result = mysqli_query($link,$sql);

                        //5. 解析结果集
                        if($result!=false && mysqli_num_rows($result)>0){

                                //解析学生数据
                                $row = mysqli_fetch_assoc($result);                        }
                ?>
                <form action="doAction.php?a=update&id=<?php echo $id ?>" method="post">
                        姓名：<input type="text" name="uname" value="<?php echo $row['name'] ?>"/><br/><br/>
                        性别：<input type="radio" name="usex" value="w" <?php echo $row['sex']=='w'?"checked":""; ?> /> 女
                                  <input type="radio" name="usex" value="m" <?php echo $row['sex']=='m'?"checked":""; ?>/> 男<br/><br/>
                        年龄：<input type="text" name="uage" value="<?php echo $row['age'] ?>"/><br/><br/>
                        手机：<input type="text" name="uphone" value="<?php echo $row['phone'] ?>"/><br/><br/>
                        邮箱：<input type="email" name="uemail" value="<?php echo $row['email'] ?>"/><br/><br/>
                        婚否：<input type="radio" name="uhunfou" value="y" <?php echo $row['hunfou']=='y'?"checked":"" ?>/> 已婚
                                  <input type="radio" name="uhunfou" value="n" <?php echo $row['hunfou']=='n'?"checked":"" ?>/> 未婚<br/><br/>
                        Q  Q：<input type="text" name="uqq" value="<?php echo $row['qq'] ?>"/><br/><br/>
                        小组：<input type="text" name="uteam" value="<?php echo $row['team'] ?>"/><br/><br/>
                        <input type="submit" value="提交"/>
                        <input type="reset" value="重置"/>
                </form>
                <?php
                //6. 关闭数据库，释放结果集
                        mysqli_free_result($result);
                        mysqli_close($link);
                ?>
                </center>
        </body>
</html>

参考：http://www.jb51.net/article/62766.htm

调试易

PHP学生信息管理系统

解决方案 »