PHP development student management system browsing student page

Create index.php file

This file uses a mix of HTML and PHP languages

The process is as follows

The code is as follows

<!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>
    <?php
    include ("menu.php");
 ?>
 <h3>浏览学生信息</h3>
    <table width="350" border="1" cellspacing="0">
        <tr>
            <th>ID</th>
            <th>姓名</th>
            <th>性别</th>
            <th>年龄</th>
            <th>班级</th>
            <th>操作</th>
        </tr>
        <?php
 //    1. 链接数据库
 header("content-type:text/html;charset=utf8");
 $conn=mysqli_connect("localhost","root","root","study");
        mysqli_set_charset($conn,"utf8");
 //2.执行sql
 $sql_select = "select * from stu";
 //3.data 解析
 foreach ( $conn->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['class']}</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>
</body>
</html>

Look at the code above. There is a modify button and a delete button on it. The next step is to do our Modify and delete function

Continuing Learning

new file

<body> <meta charset="UTF-8"> <title>登陆界面</title> <h2>学生管理系统</h2> <a href="index.php"> 浏览学生</a> <a href="add.php"> 添加学生</a> <hr> <h3>浏览学生信息</h3> <table cellspacing="0" border="1" width="350"> <tbody><tr> <th>ID</th> <th>姓名</th> <th>性别</th> <th>年龄</th> <th>班级</th> <th>操作</th> </tr> <tr><th>3 </th><th>刘奇</th><th>男 </th><th>12 </th><th>五年级</th><td> <a href="edit.php?id=3">修改</a> <a href="javascript:void(0);" onclick="doDel(3)">删除</a> </td></tr><tr><th>4 </th><th>美女</th><th>女 </th><th>12 </th><th>六年级</th><td> <a href="edit.php?id=4">修改</a> <a href="javascript:void(0);" onclick="doDel(4)">删除</a> </td></tr> </tbody></table> </body>

submit Reset Code

Automatic operation

PHP development student management system browsing student page

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]