masyarakat Belajar Perpustakaan Alatan Masa lapang
cari
Melayu
Rumah > php教程 > PHP源码 > stu 学生管理

stu 学生管理

WBOY
Lepaskan： 2016-07-11 08:44:06
asal
1416 orang telah melayarinya
跳至 [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>浏览学生信息</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>
Salin selepas log masuk

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>增加学生信息</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>
Salin selepas log masuk

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;
}
Salin selepas log masuk

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>修改学生信息</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>
Salin selepas log masuk

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

<!DOCTYPE html>
<html lang="en">
<body>
    <h2>学生管理系统</h2>
    <a href="index.php"> 浏览学生</a>
    <a href="add.php"> 添加学生</a>
    <hr>
</body>
</html>
Salin selepas log masuk
Label berkaitan：
stu 学生管理
sumber：php.cn
Artikel sebelumnya：微信扫码支付接口开发支付宝即时到帐开发 Artikel seterusnya：字符串拆分，当遇到区间时遍历区间内的所有值
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Artikel terbaru oleh pengarang
Isu terkini
Panel Pentadbiran: Jana Halaman PHP Baharu Saya ingin membuat laman blog menggunakan php. Masalah yang saya hadapi ialah bagaimana un...
daripada 2024-04-03 15:46:31
0
1
277
Bagaimana untuk menyimpan pemberitahuan untuk berbilang pengguna dalam pangkalan data phpmysql tanpa membebankan pangkalan data dengan rekod Saya bimbang saya boleh membuat rangkak dalam pangkalan data dengan mudah sambil cuba mema...
daripada 2024-03-30 22:51:20
0
1
411
Topik-topik yang berkaitan
Lagi>
Cadangan popular
Tutorial Popular
Lagi>
Tutorial berkaitan
Cadangan popular
Kursus terkini
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan