首页 > 后端开发 > PHP问题 > php代码怎么实现成绩查询

php代码怎么实现成绩查询

藏色散人
发布: 2023-03-17 15:36:02
原创
6717 人浏览过

php代码实现成绩查询的方法:1、创建前端登录页面代码;2、通过“if (isset($_SESSION['username'])) {...}”语法实现判断用户是否登录;3、创建后端管理登录页面;4、连接数据库;5、通过“session_start(); if (isset($_COOKIE['username'])) {$_SESSION['']}”代码实现查询成绩即可。

php代码怎么实现成绩查询

本教程操作环境:Windows7系统、PHP8.1版、Dell G3电脑。

php代码怎么实现成绩查询?

PHP成绩查询系统

一个非常简陋的PHP成绩查询系统,期末作业。

因为上课打酱油了,所以这也是最后几天捣鼓出来的,代码都是东拼西凑的,只有简单的增删改查功能。就酱紫。

c82e7e240aae3683a8a6df5ec5536ee.jpg

数据库:

f7194ad31caf0e8b018e445f7f24318.jpg

一共这么几个文件(html、css、php都写一块了)

36b511c297562eeed0b9bd7054861f4.jpg

然后界面:(就长这样)

887c1cdb510f3d0638cdc182310cdb6.jpg

1eb091ff118aff6df562cde41db0e8d.jpg

代码是按上图的文件顺序排的

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        * {
            margin: 0px;
            padding: auto;
        }
        fieldset {
            margin: auto;
            margin-top: 200px;
            width: 400px;
            text-align: center;
        }
        ul li {
            margin: 0;
            padding: 0;
        }
        form {
            margin: 40px 30px 0;
        }
        form li {
            list-style: none;
            padding: 5px 0;
        }
        .login_btn {
            border: none;
            background: #01A4F1;
            color: #fff;
            font-size: 14px;
            font-weight: bold;
            height: 28px;
            line-height: 28px;
            padding: 0 10px;
            cursor: pointer;
        }
        a:link {
            text-decoration: none;
            color: blue;
        }
        a:visited {
            color: blue;
            text-decoration: none;
        }
        .return_but {
            float: right;
        }
    </style>
</head>
<body>
    <form action="#" method="POST">
        <fieldset>
            <legend>添加学生成绩</legend>
            <ul>
                <li>
                    请输入学生的<b>成绩</b>
                    <span><a href="show_teacher.php">返回</a></span>
                </li>
                <li>
                    学号:
                    <input type="text" name="username" />
                </li>
                <li>
                    语文:
                    <input type="text" name="yuwen" />
                </li>
                <li>
                    数学:
                    <input type="text" name="shuxue" />
                </li>
                <li>
                    英语:
                    <input type="text" name="yingyu" />
                </li>
                <li>
                    综合:
                    <input type="text" name="zonghe" />
                </li>
                <li>
                    <input type="submit" name="add_score" value="确认添加" />
                </li>
            </ul>
        </fieldset>
    </form>
    <?php
    header("Content-Type:text/html; charset=utf-8");
    session_start();
    include("conn.php");
    $con = mysqli_connect("localhost:3306", "root", "", "resultsquerysystem");
    mysqli_query($con, "set names utf8");
    if (isset($_SESSION[&#39;username&#39;])) {
        if (isset($_POST[&#39;add_score&#39;])) {
            $username = $_POST[&#39;username&#39;];
            $yuwen = $_POST[&#39;yuwen&#39;];
            $shuxue = $_POST[&#39;shuxue&#39;];
            $yingyu = $_POST[&#39;yingyu&#39;];
            $zonghe = $_POST[&#39;zonghe&#39;];
            $sql = "insert into score (username,语文,数学,英语,综合) values(&#39;$username&#39;,&#39;$yuwen&#39;,&#39;$shuxue&#39;,&#39;$yingyu&#39;,&#39;$zonghe&#39;)";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert(&#39;添加成功&#39;); location.href=&#39;show_teacher.php&#39;;</script>";
            }
        }
    } else {
        //缓存意外被清除后、
        echo "用户信息丢失,3秒后返回登陆界面";
        header(&#39;refresh: 3; url=index.php&#39;);
    }
    ?>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        * {
            margin: 0px;
            padding: auto;
        }
        fieldset {
            margin: auto;
            margin-top: 200px;
            width: 400px;
            text-align: center;
        }
        ul li {
            margin: 0;
            padding: 0;
        }
        form {
            margin: 40px 30px 0;
        }
        form li {
            list-style: none;
            padding: 5px 0;
        }
        .login_btn {
            border: none;
            background: #01A4F1;
            color: #fff;
            font-size: 14px;
            font-weight: bold;
            height: 28px;
            line-height: 28px;
            padding: 0 10px;
            cursor: pointer;
        }
        a:link {
            text-decoration: none;
            color: blue;
        }
        a:visited {
            color: blue;
            text-decoration: none;
        }
        .return_but {
            float: right;
        }
    </style>
</head>
<body>
    <form action="#" method="POST">
        <fieldset>
            <legend>添加学生信息</legend>
            <ul>
                <li>
                    请输入需要添加学生的<b>学号</b>和<b>登陆密码</b>
                    <span><a href="show_teacher.php">返回</a></span>
                </li>
                <li>
                    学号:
                    <input type="text" name="username" />
                </li>
                <li>
                    密码:
                    <input type="password" name="password" />
                </li>
                <li>
                    <input type="submit" name="add_student" value="确认添加" />
                </li>
            </ul>
        </fieldset>
    </form>
    <?php
    header("Content-Type:text/html; charset=utf-8");
    session_start();
    include("conn.php");
    $con = mysqli_connect("localhost:3306", "root", "", "resultsquerysystem");
    mysqli_query($con, "set names utf8");
    if (isset($_SESSION[&#39;username&#39;])) {
        if (isset($_POST[&#39;add_student&#39;])) {
            $username = $_POST[&#39;username&#39;];
            $password = $_POST[&#39;password&#39;];
            $sql = "insert into student (username,password) values(&#39;$username&#39;,&#39;$password&#39;)";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert(&#39;添加成功&#39;); location.href=&#39;show_teacher.php&#39;;</script>";
            }
        }
    } else {
        //缓存意外被清除后、
        
        echo "用户信息丢失,3秒后返回登陆界面";
        header(&#39;refresh: 3; url=index.php&#39;);
    }
    ?>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        * {
            margin: 0px;
            padding: auto;
        }
        fieldset {
            margin: auto;
            margin-top: 200px;
            width: 400px;
            text-align: center;
        }
        ul li {
            margin: 0;
            padding: 0;
        }
        form {
            margin: 40px 30px 0;
        }
        form li {
            list-style: none;
            padding: 5px 0;
        }
        .login_btn {
            border: none;
            background: #01A4F1;
            color: #fff;
            font-size: 14px;
            font-weight: bold;
            height: 28px;
            line-height: 28px;
            padding: 0 10px;
            cursor: pointer;
        }
        a:link {
            text-decoration: none;
            color: blue;
        }
        a:visited {
            color: blue;
            text-decoration: none;
        }
        .return_but {
            float: right;
        }
    </style>
</head>
<body>
    <form action="#" method="POST">
        <fieldset>
            <legend>修改学生成绩</legend>
            <ul>
                <li>
                    学号:<?php echo $_GET[&#39;username&#39;] ?>
                    <span><a href="show_teacher.php">返回</a></span>
                </li>
                <li>
                    语文:
                    <input type="text" name="yuwen" value="<?php echo $_GET[&#39;yuwen&#39;] ?>" />
                </li>
                <li>
                    数学:
                    <input type="text" name="shuxue" value="<?php echo $_GET[&#39;shuxue&#39;] ?>" />
                </li>
                <li>
                    英语:
                    <input type="text" name="yingyu" value="<?php echo $_GET[&#39;yingyu&#39;] ?>" />
                </li>
                <li>
                    综合:
                    <input type="text" name="zonghe" value="<?php echo $_GET[&#39;zonghe&#39;] ?>" />
                </li>
                <li>
                    <input type="submit" name="alter_score" value="确认修改" />
                </li>
            </ul>
        </fieldset>
    </form>
    <?php
    header("Content-Type:text/html; charset=utf-8");
    session_start();
    include("conn.php");
    $con = mysqli_connect("localhost:3306", "root", "", "resultsquerysystem");
    mysqli_query($con, "set names utf8");
    if (isset($_SESSION[&#39;username&#39;])) {
        if (isset($_POST[&#39;alter_score&#39;])) {
            $username = $_GET[&#39;username&#39;];
            $yuwen = $_POST[&#39;yuwen&#39;];
            $shuxue = $_POST[&#39;shuxue&#39;];
            $yingyu = $_POST[&#39;yingyu&#39;];
            $zonghe = $_POST[&#39;zonghe&#39;];
            $sql = "UPDATE `score` SET`语文`=$yuwen,`数学`=$shuxue,`英语`=$yingyu,`综合`=$zonghe WHERE username = $username";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert(&#39;修改成功&#39;); location.href=&#39;show_teacher.php&#39;;</script>";
            }
        }
    } else {
        //缓存意外被清除后、
        echo "用户信息丢失,3秒后返回登陆界面";
        header(&#39;refresh: 3; url=index.php&#39;);
    }
    ?>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
<?php
$con =mysqli_connect("localhost:3306","root","","miniblog");
 if(!$con){
die("链接错误");
     }
  mysqli_query($con,"set names utf8");
?>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
    <?php
    header("Content-Type:text/html; charset=utf-8");
    session_start();
    include("conn.php");
    $con = mysqli_connect("localhost:3306", "root", "", "resultsquerysystem");
    mysqli_query($con, "set names utf8");
    if (isset($_SESSION[&#39;username&#39;])) {
        if (isset($_GET[&#39;id&#39;])) {
            $username = $_GET[&#39;id&#39;];
            echo $username;
            $sql = "delete from score where username = $username";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert(&#39;删除成功&#39;); location.href=&#39;show_teacher.php&#39;;</script>";
            }
        }
    } else {
        //缓存意外被清除后、
        echo "用户信息丢失,3秒后返回登陆界面";
        header(&#39;refresh: 3; url=index.php&#39;);
    }
    ?>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style>
        * {
            margin: 0px;
            padding: auto;
        }
        fieldset {
            margin: auto;
            margin-top: 200px;
            width: 400px;
            text-align: center;
        }
        ul li {
            margin: 0;
            padding: 0;
        }
        form {
            margin: 40px 30px 0;
        }
        form li {
            list-style: none;
            padding: 5px 0;
        }
        .login_btn {
            border: none;
            background: #01A4F1;
            color: #fff;
            font-size: 14px;
            font-weight: bold;
            height: 28px;
            line-height: 28px;
            padding: 0 10px;
            cursor: pointer;
        }
    </style>
</head>
<body>
    <form action="#" method="POST">
        <fieldset>
            <legend>用户登录</legend>
            <ul>
                <li>
                    用户名:
                    <input type="text" name="username" />
                </li>
                <li>
                    密   码:
                    <input type="password" name="password" />
                </li>
                <li>
                    <input type="submit" name="login_student" value="学生登录" />
                    <input type="submit" name="login_teacher" value="教师登录" />
                </li>
            </ul>
            <?php
            header("Content-Type:text/html;charset=utf-8");
            include("conn.php");
            $con = mysqli_connect("localhost:3306", "root", "", "resultsquerysystem");
            session_start();
            //点击学生登陆按钮
            if (isset($_POST[&#39;login_student&#39;])) {
                $username = trim($_POST[&#39;username&#39;]);
                $password = trim($_POST[&#39;password&#39;]);
                if (($username == &#39;&#39;) || ($password == &#39;&#39;)) {
                    header(&#39;refresh: 3; url=index.php&#39;);
                    echo "该用户名或者密码不能为空,3秒后跳转到登录页面";
                    exit;
                } else {
                    $sql = "select * from student where  username=&#39;$username&#39;";
                    $res = mysqli_query($con, $sql);
                    $n = mysqli_num_rows($res);
                    if ($n > 0) {
                        $row = mysqli_fetch_assoc($res);
                        $pwd = $row[&#39;password&#39;];
                        //用户名或密码错误
                        if ($password != $pwd) {
                            # code...
                            header(&#39;refresh: 3; url=index.php&#39;);
                            echo "用户名或者密码错误,3秒后跳转到登录页面";
                        } else {
                            //登录成功,将用户信息保存到session中
                            $_SESSION[&#39;username&#39;] = $username;
                            $_SESSION[&#39;islogin&#39;] = 1;
                            //用户信息保存到Cookie  ,1天
                            setcookie("username", $username, time() + 24 * 60 * 60);
                            setcookie(
                                "pw",
                                md5($username . md5($password)),
                                time() + 24 * 60 * 60
                            );
                            //跳转到显示页面
                            header("location:show_student.php");
                        }
                    } else {
                        header(&#39;refresh: 3; url=index.php&#39;);
                        echo "用户名或者密码错误,3秒后跳转到登录页面";
                    }
                }
            }
            //点击教师登录按钮
            elseif (isset($_POST[&#39;login_teacher&#39;])) {
                $username = trim($_POST[&#39;username&#39;]);
                $password = trim($_POST[&#39;password&#39;]);
                if (($username == &#39;&#39;) || ($password == &#39;&#39;)) {
                    header(&#39;refresh: 3; url=index.php&#39;);
                    echo "该用户名或者密码不能为空,3秒后跳转到登录页面";
                    exit;
                } else {
                    $sql = "select * from teacher where  username=&#39;$username&#39;";
                    $res = mysqli_query($con, $sql);
                    $n = mysqli_num_rows($res);
                    if ($n > 0) {
                        $row = mysqli_fetch_assoc($res);
                        $pwd = $row[&#39;password&#39;];
                        //用户名或密码错误
                        if ($password != $pwd) {
                            # code...
                            header(&#39;refresh: 3; url=index.php&#39;);
                            echo "用户名或者密码错误,3秒后跳转到登录页面";
                        } else {
                            //登录成功,将用户信息保存到session中
                            $_SESSION[&#39;username&#39;] = $username;
                            $_SESSION[&#39;islogin&#39;] = 1;
                            //用户信息保存到Cookie  ,1天
                            setcookie("username", $username, time() + 24 * 60 * 60);
                            setcookie(
                                "pw",
                                md5($username . md5($password)),
                                time() + 24 * 60 * 60
                            );
                            //跳转到显示页面
                            header("location:show_teacher.php");
                        }
                    } else {
                        header(&#39;refresh: 3; url=index.php&#39;);
                        echo "用户名或者密码错误,3秒后跳转到登录页面";
                    }
                }
            }
            ?>
        </fieldset>
    </form>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        a:link {
            text-decoration: none;
            color: blue;
        }
        a:visited {
            color: blue;
            text-decoration: none;
        }
    </style>
</head>
<body>
    <?php
    header("Content-Type:text/html;charset=utf-8");
    session_start();
    //清除session 
    $username = $_SESSION[&#39;username&#39;];
    $_SESSION = array();
    session_destroy();
    //清除cookie 
    setcookie("username", &#39;&#39;, time() - 1);
    setcookie("code", &#39;&#39;, time() - 1);
    echo "<a href=&#39;index.php&#39;>点击重新登录</a>";
    header(&#39;refresh: 5; url=index.php&#39;);    
    echo "<br />5秒钟后自动返回到主页";
    ?>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        * {
            margin: 0px;
            padding: auto;
        }
        a:link {
            text-decoration: none;
            color: blue;
        }
        a:visited {
            color: blue;
            text-decoration: none;
        }
        #box {
            margin: auto;
            margin-top: 200px;
            width: 800px;
            text-align: center;
        }
        table {
            width: 700px;
            padding: 0;
            margin: 0 auto;
        }
        td {
            border-right: 1px solid #C1DAD7;
            border-bottom: 1px solid #C1DAD7;
            font-size: 11px;
            padding: 6px 6px 6px 12px;
            color: #4f6b72;
        }
        tr:hover {
            background-color: #B0C4DE;
        }
        th {
            font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
            color: #4f6b72;
            border-right: 1px solid #C1DAD7;
            border-bottom: 1px solid #C1DAD7;
            border-top: 1px solid #C1DAD7;
            letter-spacing: 2px;
            text-transform: uppercase;
            text-align: center;
            padding: 6px 6px 6px 12px;
            background: #CAE8EA no-repeat;
        }
    </style>
</head>
<body>
    <div id="box">
        <?php
        header("Content-Type:text/html;charset=utf-8");
        session_start();
        //首先判断Cookie是否有记住用户信息 
        if (isset($_COOKIE[&#39;username&#39;])) {
            $_SESSION[&#39;username&#39;] = $_COOKIE[&#39;username&#39;];
            $_SESSION[&#39;islogin&#39;] = 1;
        }
        if (isset($_SESSION[&#39;islogin&#39;])) {
            //已经登录 
            echo "成绩查询中心!<br/><br/>你的学号:" . $_SESSION[&#39;username&#39;] . "   ";
            echo "<a href=&#39;logout.php&#39;>注销</a>";
        } else { //为登录 
            echo "你还未登录,请<a href=&#39;index.php&#39;>登录</a>";
        }
        ?>
        <table>
            <thead>
                <th>语文</th>
                <th>数学</th>
                <th>英语</th>
                <th>综合</th>
            </thead>
            <?php
            $db = new mysqli("localhost", "root", "", "resultsquerysystem");
            $sql = "select * from score where username = &#39;" . $_SESSION[&#39;username&#39;] . "&#39;";
            $r = $db->query($sql);
            //传值
            while ($attr = $r->fetch_row()) {
                echo " <tr>
    <td>{$attr[1]}</td>
    <td>{$attr[2]}</td>
    <td>{$attr[3]}</td>
    <td>{$attr[4]}</td>
  </tr>";
            }
            ?>
        </table>
    </div>
</body>
</html>
登录后复制
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
    <style>
        a:link {
            text-decoration: none;
            color: blue;
        }
        a:visited {
            color: blue;
            text-decoration: none;
        }
        * {
            margin: 0px;
            padding: auto;
        }
        #box {
            margin: auto;
            margin-top: 200px;
            width: 800px;
            text-align: center;
        }
        table {
            width: 700px;
            padding: 0;
            margin: 20px auto;
        }
        td {
            border-right: 1px solid #C1DAD7;
            border-bottom: 1px solid #C1DAD7;
            font-size: 11px;
            padding: 6px 6px 6px 12px;
            color: #4f6b72;
        }
        tr:hover {
            background-color: #B0C4DE;
        }
        th {
            font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
            color: #4f6b72;
            border-right: 1px solid #C1DAD7;
            border-bottom: 1px solid #C1DAD7;
            border-top: 1px solid #C1DAD7;
            letter-spacing: 2px;
            text-transform: uppercase;
            text-align: center;
            padding: 6px 6px 6px 12px;
            background: #CAE8EA no-repeat;
        }
        .login_btn {
            border: none;
            background: #01A4F1;
            color: #fff;
            font-size: 14px;
            font-weight: bold;
            height: 28px;
            line-height: 28px;
            padding: 0 10px;
            cursor: pointer;
        }
    </style>
</head>
<body>
    <div id="box">
        <?php
        header("Content-Type:text/html;charset=utf-8");
        session_start();
        //首先判断Cookie是否有记住用户信息 
        if (isset($_COOKIE[&#39;username&#39;])) {
            $_SESSION[&#39;username&#39;] = $_COOKIE[&#39;username&#39;];
            $_SESSION[&#39;islogin&#39;] = 1;
        }
        if (isset($_SESSION[&#39;islogin&#39;])) {
            //已经登录 
            echo "成绩查询中心!<br/><br/>工号:" . $_SESSION[&#39;username&#39;] . "   ";
            echo "<a href=&#39;logout.php&#39;>注销</a>";
        } else { //为登录 
            echo "你还未登录,请<a href=&#39;index.php&#39;>登录</a>";
        }
        ?>
        <form method="post" action="delete_score.php">
            <table>
                <thead>
                    <th>学号</th>
                    <th>语文</th>
                    <th>数学</th>
                    <th>英语</th>
                    <th>综合</th>
                    <th>操作</th>
                </thead>
                <?php
                $db = new mysqli("localhost", "root", "", "resultsquerysystem");
                $sql = "select * from score";
                $r = $db->query($sql);
                //传值
                while ($attr = $r->fetch_row()) {
                    echo " <tr>
  
    <td>{$attr[0]}</td>
    <td>{$attr[1]}</td>
    <td>{$attr[2]}</td>
    <td>{$attr[3]}</td>
    <td>{$attr[4]}</td>
    <td>
        <a href=&#39;alter_score.php?username=$attr[0]&yuwen=$attr[1]&shuxue=$attr[2]&yingyu=$attr[3]&zonghe=$attr[4]&#39;>修改</a>   
        <a href=&#39;delete_score.php?id=$attr[0]&#39;>删除</a>
    </td>
  </tr>";
                }
                ?>
            </table>
        </form>
        <a href="add_student.php"><button>添加学生信息</button></a>
             
        <a href="add_score.php"><button>添加学生成绩</button></a>
    </div>
</body>
</html>
登录后复制

推荐学习:《PHP视频教程

以上是php代码怎么实现成绩查询的详细内容。更多信息请关注PHP中文网其他相关文章!

相关标签:
来源:php.cn
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板