Community Learn Tools Library Leisure
search
English
Home > php教程 > PHP源码 > stu student management

stu student management

WBOY
Release： 2016-07-11 08:44:06
Original
1416 people have browsed it
Jump to [1] [2] [3] [4] [5] [Full screen preview] 
<!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>
Copy after login

2. [File] add.php ~ 1KB Download(1) Jump to [1] [2] [3] [4] [5] [Full screen preview] 

<!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>
Copy after login

3. [File] action.php ~ 2KB Download(1) Jump to [1] [2] [3] [4] [5] [Full screen preview] 

<?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;
}
Copy after login

4. [File] edit.php ~ 2KB Download(1) Jump to [1] [2] [3] [4] [5] [Full screen preview] 

<!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>
Copy after login

5. [File] menu.php ~ 179B Download(1) Jump to [1] [2] [3] [4] [5] [Full screen preview] 

<!DOCTYPE html>
<html lang="en">
<body>
    <h2>学生管理系统</h2>
    <a href="index.php"> 浏览学生</a>
    <a href="add.php"> 添加学生</a>
    <hr>
</body>
</html>
Copy after login
Related labels：
stu 学生管理
source：php.cn
Previous article：WeChat scan code payment interface development and Alipay instant payment development Next article：String splitting, when encountering an interval, iterate through all values ​​in the interval
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Admin Panel: Generate New PHP Page I want to make a blog page using php. The problem I have is how to create this page when I...
From 2024-04-03 15:46:31
0
1
277
How to save notifications for multiple users in phpmysql database without overloading the database with records I'm concerned that I could easily create a crawl in the database while trying to ensure th...
From 2024-03-30 22:51:20
0
1
411
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template