stu 学生管理-PHP源码-PHP中文網

浏览学生信息

增加学生信息

修改学生信息

学生管理系统

首頁

php教程

PHP源码

stu 学生管理

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 11, 2016 am 08:44 AM

跳至 [1] [2] [3] [4] [5] [全屏预览]

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生信息管理</title>
    <script>
        function doDel(id) {
            if(confirm('确认删除?')) {
                window.location='action.php?action=del&id='+id;
            }
        }
    </script>
</head>
<body>
<center>
    <?php
    include ("menu.php");
    ?>
    <h3 id="浏览学生信息">浏览学生信息</h3>
    <table width="500" border="1">
        <tr>
            <th>ID</th>
            <th>姓名</th>
            <th>性别</th>
            <th>年龄</th>
            <th>班级</th>
            <th>操作</th>
        </tr>
        <?php
//        1. 链接数据库
        try{
            $pdo = new PDO("uri:mysqlPdo.ini","root","1");
        }catch (PDOException $e) {
            die('connection failed'.$e->getMessage());
        }
        //2.执行sql
        $sql_select = "select * from stu";
        //3.data 解析
        foreach ( $pdo->query($sql_select) as $row) {
	        echo "<tr>";
            echo "<th>{$row['id']}  </th>";
            echo "<th>{$row['name']}</th>";
            echo "<th>{$row['sex']} </th>";
            echo "<th>{$row['age']} </th>";
            echo "<th>{$row['classid']}</th>";
            echo "<td>
                    <a href='edit.php?id={$row['id']}'>修改</a>
                    <a href='javascript:void(0);' onclick='doDel({$row['id']})'>删除</a>
                </td>";
	        echo "</tr>";
        }
        ?>
    </table>
</center>
</body>
</html>

登入後複製

2. [文件] add.php ~ 1KB 下载(1) 跳至 [1] [2] [3] [4] [5] [全屏预览]

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生管理系统</title>
</head>
<body>
<center>

    <?php include ('menu.php'); ?>
    <h3 id="增加学生信息">增加学生信息</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="text" name="age"></td>
            </tr>
            <tr>
                <td>性别</td>
                <td><input type="radio" name="sex" value="男">男</td>
                <td><input type="radio" name="sex" value="女">女</td>
            </tr>
            <tr>
                <td>班级</td>
                <td><input type="text" name="classid"></td>
            </tr>
            <tr>
<!--                <td> </td>-->
                <td><a href="index.php">返回</td>
                <td><input type="submit" value="添加"></td>
                <td><input type="reset" value="重置"></td>
            </tr>
        </table> 
    </form>
    
</center>
</body>
</html>

登入後複製

3. [文件] action.php ~ 2KB 下载(1) 跳至 [1] [2] [3] [4] [5] [全屏预览]

<?php
/**
 * Created by PhpStorm.
 * User: hyh
 * Date: 16-7-7
 * Time: 下午9:37
 */
//1. 链接数据库
try{
    $pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
//            echo 'Connection failed: ' . $e->getMessage();
    die('connection failed'.$e->getMessage());
}

//2.action 的值做对操作

switch ($_GET['action']){
    
    case 'add'://add 
        $name = $_POST['name'];
        $sex = $_POST['sex'];
        $age = $_POST['age'];
        $classid = $_POST['classid'];
        
        $sql = "insert into stu  (name, sex, age, classid) values ('{$name}', '{$sex}','{$age}','{$classid}')";
        $rw = $pdo->exec($sql); 
        if ($rw > 0){
            echo "<script>alter('添加成功');</script>";
        }else{
            echo "<script>alter('添加失败');</script>";
        }
        header('Location: index.php');
        break; 
    
    case 'del'://get
        $id = $_GET['id'];
        $sql = "delete from stu where id={$id}";
        $rw = $pdo->exec($sql);
        if ($rw > 0){
            echo "<script>alter('删除成功');</script>";
        }else{
            echo "<script>alter('删除失败');</script>";
        }
        header('Location: index.php');
        break;

    case 'edit'://post
        $id = $_POST['id'];
        $name = $_POST['name']; 
        $age = $_POST['age'];
        $classid = $_POST['classid'];
        $sex = $_POST['sex'];
        
//        echo $id, $age, $age, $name;
        $sql = "update stu set name='{$name}', age={$age},sex='{$sex}',classid={$classid} where id={$id};";
//        $sql = "update myapp.stu set name='jike',sex='女', age=24,classid=44 where id=17";
        print $sql;
        $rw = $pdo->exec($sql);
        if ($rw > 0){
            echo "<script>alter('更新成功');</script>";
        }else{
            echo "<script>alter('更新失败');</script>";
        }
        header('Location: index.php');
        break; 
    
    default:
        header('Location: index.php');
        break;
}

登入後複製

4. [文件] edit.php ~ 2KB 下载(1) 跳至 [1] [2] [3] [4] [5] [全屏预览]

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生管理系统</title>
</head>
<body>
<center>
    <?php include ('menu.php');
    //1. 链接数据库
    try{
        $pdo = new PDO("uri:mysqlPdo.ini","root","1");
    }catch (PDOException $e) {
        die('connection failed'.$e->getMessage());
    }
    //2.执行sql
    $sql_select = "select * from stu where id={$_GET['id']}";
    $stmt = $pdo->query($sql_select);
    if ($stmt->rowCount() >0) {
        $stu = $stmt->fetch(PDO::FETCH_ASSOC); // 解析数据
    }else{
        die("no have this id:{$_GET['id']}");
    }
    ?>
    
    <h3 id="修改学生信息">修改学生信息</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="classid" value="<?php echo $stu['classid']?>"></td>
            </tr>
            <tr>
                <td> </td>
                <td><input type="submit" value="更新"></td>
                <td><input type="reset" value="重置"></td>
            </tr>
        </table>
    </form>
    
    
</center>

<?php
?>
</body>
</html>

登入後複製

5. [文件] menu.php ~ 179B 下载(1) 跳至 [1] [2] [3] [4] [5] [全屏预览]

<!DOCTYPE html>
<html lang="en">
<body>
    <h2 id="学生管理系统">学生管理系统</h2>
    <a href="index.php"> 浏览学生</a>
    <a href="add.php"> 添加学生</a>
    <hr>
</body>
</html>

登入後複製

本網站聲明

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn