php代碼如何實(shí)現(xiàn)成績查詢

發(fā)布時(shí)間：2022-12-02 10:01:56 來源：億速云閱讀：114 作者：iii 欄目：編程語言

今天小編給大家分享一下php代碼如何實(shí)現(xiàn)成績查詢的相關(guān)知識(shí)點(diǎn)，內(nèi)容詳細(xì)，邏輯清晰，相信大部分人都還太了解這方面的知識(shí)，所以分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后有所收獲，下面我們一起來了解一下吧。

php代碼實(shí)現(xiàn)成績查詢的方法：1、創(chuàng)建前端登錄頁面代碼；2、通過“if (isset($_SESSION['username'])) {...}”語法實(shí)現(xiàn)判斷用戶是否登錄；3、創(chuàng)建后端管理登錄頁面；4、連接數(shù)據(jù)庫；5、通過“session_start(); if (isset($_COOKIE['username'])) {$_SESSION['']}”代碼實(shí)現(xiàn)查詢成績即可。

PHP成績查詢系統(tǒng)

一個(gè)非常簡陋的PHP成績查詢系統(tǒng)，期末作業(yè)。

因?yàn)樯险n打醬油了，所以這也是最后幾天搗鼓出來的，代碼都是東拼西湊的，只有簡單的增刪改查功能。就醬紫。

php代碼如何實(shí)現(xiàn)成績查詢

數(shù)據(jù)庫：

php代碼如何實(shí)現(xiàn)成績查詢

一共這么幾個(gè)文件（html、css、php都寫一塊了）

php代碼如何實(shí)現(xiàn)成績查詢

然后界面：（就長這樣）

php代碼如何實(shí)現(xiàn)成績查詢

代碼是按上圖的文件順序排的

<!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>添加學(xué)生成績</legend>
            <ul>
                <li>
                    請輸入學(xué)生的<b>成績</b>
                    <span><a href="show_teacher.php">返回</a></span>
                </li>
                <li>
                    學(xué)號(hào):
                    <input type="text" name="username" />
                </li>
                <li>
                    語文:
                    <input type="text" name="yuwen" />
                </li>
                <li>
                    數(shù)學(xué):
                    <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="確認(rèn)添加" />
                </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['username'])) {
        if (isset($_POST['add_score'])) {
            $username = $_POST['username'];
            $yuwen = $_POST['yuwen'];
            $shuxue = $_POST['shuxue'];
            $yingyu = $_POST['yingyu'];
            $zonghe = $_POST['zonghe'];
            $sql = "insert into score (username,語文,數(shù)學(xué),英語,綜合) values('$username','$yuwen','$shuxue','$yingyu','$zonghe')";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert('添加成功'); location.href='show_teacher.php';</script>";
            }
        }
    } else {
        //緩存意外被清除后、
        echo "用戶信息丟失，3秒后返回登陸界面";
        header('refresh: 3; url=index.php');
    }
    ?>
</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>添加學(xué)生信息</legend>
            <ul>
                <li>
                    請輸入需要添加學(xué)生的<b>學(xué)號(hào)</b>和<b>登陸密碼</b>
                    <span><a href="show_teacher.php">返回</a></span>
                </li>
                <li>
                    學(xué)號(hào):
                    <input type="text" name="username" />
                </li>
                <li>
                    密碼:
                    <input type="password" name="password" />
                </li>
                <li>
                    <input type="submit" name="add_student" value="確認(rèn)添加" />
                </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['username'])) {
        if (isset($_POST['add_student'])) {
            $username = $_POST['username'];
            $password = $_POST['password'];
            $sql = "insert into student (username,password) values('$username','$password')";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert('添加成功'); location.href='show_teacher.php';</script>";
            }
        }
    } else {
        //緩存意外被清除后、
        
        echo "用戶信息丟失，3秒后返回登陸界面";
        header('refresh: 3; url=index.php');
    }
    ?>
</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>修改學(xué)生成績</legend>
            <ul>
                <li>
                    學(xué)號(hào)：<?php echo $_GET['username'] ?>
                    <span><a href="show_teacher.php">返回</a></span>
                </li>
                <li>
                    語文:
                    <input type="text" name="yuwen" value="<?php echo $_GET['yuwen'] ?>" />
                </li>
                <li>
                    數(shù)學(xué):
                    <input type="text" name="shuxue" value="<?php echo $_GET['shuxue'] ?>" />
                </li>
                <li>
                    英語:
                    <input type="text" name="yingyu" value="<?php echo $_GET['yingyu'] ?>" />
                </li>
                <li>
                    綜合:
                    <input type="text" name="zonghe" value="<?php echo $_GET['zonghe'] ?>" />
                </li>
                <li>
                    <input type="submit" name="alter_score" value="確認(rèn)修改" />
                </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['username'])) {
        if (isset($_POST['alter_score'])) {
            $username = $_GET['username'];
            $yuwen = $_POST['yuwen'];
            $shuxue = $_POST['shuxue'];
            $yingyu = $_POST['yingyu'];
            $zonghe = $_POST['zonghe'];
            $sql = "UPDATE `score` SET`語文`=$yuwen,`數(shù)學(xué)`=$shuxue,`英語`=$yingyu,`綜合`=$zonghe WHERE username = $username";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert('修改成功'); location.href='show_teacher.php';</script>";
            }
        }
    } else {
        //緩存意外被清除后、
        echo "用戶信息丟失，3秒后返回登陸界面";
        header('refresh: 3; url=index.php');
    }
    ?>
</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("鏈接錯(cuò)誤");
     }
  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['username'])) {
        if (isset($_GET['id'])) {
            $username = $_GET['id'];
            echo $username;
            $sql = "delete from score where username = $username";
            mysqli_query($con, $sql);
            if (mysqli_affected_rows($con) > 0) {
                echo "<script> alert('刪除成功'); location.href='show_teacher.php';</script>";
            }
        }
    } else {
        //緩存意外被清除后、
        echo "用戶信息丟失，3秒后返回登陸界面";
        header('refresh: 3; url=index.php');
    }
    ?>
</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>
                    密&nbsp;&nbsp;&nbsp;碼:
                    <input type="password" name="password" />
                </li>
                <li>
                    <input type="submit" name="login_student" value="學(xué)生登錄" />
                    <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();
            //點(diǎn)擊學(xué)生登陸按鈕
            if (isset($_POST['login_student'])) {
                $username = trim($_POST['username']);
                $password = trim($_POST['password']);
                if (($username == '') || ($password == '')) {
                    header('refresh: 3; url=index.php');
                    echo "該用戶名或者密碼不能為空,3秒后跳轉(zhuǎn)到登錄頁面";
                    exit;
                } else {
                    $sql = "select * from student where  username='$username'";
                    $res = mysqli_query($con, $sql);
                    $n = mysqli_num_rows($res);
                    if ($n > 0) {
                        $row = mysqli_fetch_assoc($res);
                        $pwd = $row['password'];
                        //用戶名或密碼錯(cuò)誤
                        if ($password != $pwd) {
                            # code...
                            header('refresh: 3; url=index.php');
                            echo "用戶名或者密碼錯(cuò)誤,3秒后跳轉(zhuǎn)到登錄頁面";
                        } else {
                            //登錄成功,將用戶信息保存到session中
                            $_SESSION['username'] = $username;
                            $_SESSION['islogin'] = 1;
                            //用戶信息保存到Cookie  ，1天
                            setcookie("username", $username, time() + 24 * 60 * 60);
                            setcookie(
                                "pw",
                                md5($username . md5($password)),
                                time() + 24 * 60 * 60
                            );
                            //跳轉(zhuǎn)到顯示頁面
                            header("location:show_student.php");
                        }
                    } else {
                        header('refresh: 3; url=index.php');
                        echo "用戶名或者密碼錯(cuò)誤,3秒后跳轉(zhuǎn)到登錄頁面";
                    }
                }
            }
            //點(diǎn)擊教師登錄按鈕
            elseif (isset($_POST['login_teacher'])) {
                $username = trim($_POST['username']);
                $password = trim($_POST['password']);
                if (($username == '') || ($password == '')) {
                    header('refresh: 3; url=index.php');
                    echo "該用戶名或者密碼不能為空,3秒后跳轉(zhuǎn)到登錄頁面";
                    exit;
                } else {
                    $sql = "select * from teacher where  username='$username'";
                    $res = mysqli_query($con, $sql);
                    $n = mysqli_num_rows($res);
                    if ($n > 0) {
                        $row = mysqli_fetch_assoc($res);
                        $pwd = $row['password'];
                        //用戶名或密碼錯(cuò)誤
                        if ($password != $pwd) {
                            # code...
                            header('refresh: 3; url=index.php');
                            echo "用戶名或者密碼錯(cuò)誤,3秒后跳轉(zhuǎn)到登錄頁面";
                        } else {
                            //登錄成功,將用戶信息保存到session中
                            $_SESSION['username'] = $username;
                            $_SESSION['islogin'] = 1;
                            //用戶信息保存到Cookie  ，1天
                            setcookie("username", $username, time() + 24 * 60 * 60);
                            setcookie(
                                "pw",
                                md5($username . md5($password)),
                                time() + 24 * 60 * 60
                            );
                            //跳轉(zhuǎn)到顯示頁面
                            header("location:show_teacher.php");
                        }
                    } else {
                        header('refresh: 3; url=index.php');
                        echo "用戶名或者密碼錯(cuò)誤,3秒后跳轉(zhuǎn)到登錄頁面";
                    }
                }
            }
            ?>
        </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['username'];
    $_SESSION = array();
    session_destroy();
    //清除cookie 
    setcookie("username", '', time() - 1);
    setcookie("code", '', time() - 1);
    echo "<a href='index.php'>點(diǎn)擊重新登錄</a>";
    header('refresh: 5; url=index.php');    
    echo "<br />5秒鐘后自動(dòng)返回到主頁";
    ?>
</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['username'])) {
            $_SESSION['username'] = $_COOKIE['username'];
            $_SESSION['islogin'] = 1;
        }
        if (isset($_SESSION['islogin'])) {
            //已經(jīng)登錄 
            echo "成績查詢中心！<br/><br/>你的學(xué)號(hào)：" . $_SESSION['username'] . "&nbsp;&nbsp;&nbsp;";
            echo "<a href='logout.php'>注銷</a>";
        } else { //為登錄 
            echo "你還未登錄，請<a href='index.php'>登錄</a>";
        }
        ?>
        <table>
            <thead>
                <th>語文</th>
                <th>數(shù)學(xué)</th>
                <th>英語</th>
                <th>綜合</th>
            </thead>
            <?php
            $db = new mysqli("localhost", "root", "", "resultsquerysystem");
            $sql = "select * from score where username = '" . $_SESSION['username'] . "'";
            $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['username'])) {
            $_SESSION['username'] = $_COOKIE['username'];
            $_SESSION['islogin'] = 1;
        }
        if (isset($_SESSION['islogin'])) {
            //已經(jīng)登錄 
            echo "成績查詢中心！<br/><br/>工號(hào)：" . $_SESSION['username'] . "&nbsp;&nbsp;&nbsp;";
            echo "<a href='logout.php'>注銷</a>";
        } else { //為登錄 
            echo "你還未登錄，請<a href='index.php'>登錄</a>";
        }
        ?>
        <form method="post" action="delete_score.php">
            <table>
                <thead>
                    <th>學(xué)號(hào)</th>
                    <th>語文</th>
                    <th>數(shù)學(xué)</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='alter_score.php?username=$attr[0]&yuwen=$attr[1]&shuxue=$attr[2]&yingyu=$attr[3]&zonghe=$attr[4]'>修改</a>&nbsp;&nbsp;&nbsp;
        <a href='delete_score.php?id=$attr[0]'>刪除</a>
    </td>
  </tr>";
                }
                ?>
            </table>
        </form>
        <a href="add_student.php"><button>添加學(xué)生信息</button></a>
        &nbsp; &nbsp; &nbsp;
        <a href="add_score.php"><button>添加學(xué)生成績</button></a>
    </div>
</body>
</html>

以上就是“php代碼如何實(shí)現(xiàn)成績查詢”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家閱讀完這篇文章都有很大的收獲，小編每天都會(huì)為大家更新不同的知識(shí)，如果還想學(xué)習(xí)更多的知識(shí)，請關(guān)注億速云行業(yè)資訊頻道。

向AI問一下細(xì)節(jié)

php代碼如何實(shí)現(xiàn)成績查詢

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽