php+mysql develops the simplest online question bank and online question making system-PHP Tutorial-php.cn

php+mysql develops the simplest online question bank and online question making system

不言

Release： 2023-03-25 06:56:01

Original

9678 people have browsed it

This article mainly introduces the simplest online question bank developed by php mysql. The online question making system has a certain reference value. Now I share it with you. Friends in need can refer to the

question bank. It is very necessary for educational institutions, schools, and online education. There are also many third-party online question bank systems on the Internet. However, this case will let people in need understand the development ideas of the question bank. In fact, it is very simple. It is nothing more than a Form validation, database validation.

1. Build the form data first

2. Submit the form data to the form verification page through get or post, and match it with the database

3. Return the result and answer Correct or wrong

Build form:

index.php

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0" />
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="format-detection" content="telephone=no">
    <title>题库</title>
    <style type="text/css">
        *{list-style: none;margin:0px;padding: 0px;}
        #tiku{
            width: 300px;
            margin:10px auto;
        }

        #tiku ul li{
            float: left;
        }
    </style>
</head>
<body>
<?php
//获取数据库配置
require_once("config.php");
//连接数据库
$con = mysql_connect($host,$username,$password);
//设置数据库字符集  
mysql_query("SET NAMES UTF8");
//查询数据库
mysql_select_db($db, $con);
//查询数据库
//获取最新的1条数据
$all = mysql_num_rows(mysql_query("select * from $tb"));
//定义分页所需的参数
$lenght=1;                             //每页显示的数量
@$page=$_GET[&#39;page&#39;]?$_GET[&#39;page&#39;]:1;    //当前页
$offset=($page-1)*$lenght;              //每页起始行编号
$allpage=ceil($all/$lenght);            //所有的页数-总数页
$prepage=$page-1;                       //上一页       
if($page==1){
    $prepage=1;                         //特殊的是当前页是1时上一页就是1
    }
$nextpage=$page+1;
if($page==$allpage){
    $nextpage=$allpage;                //特殊的是最后页是总数页时下一页就是总数页
    }
$sql="select * from $tb order by id ASC limit {$offset},{$lenght}";
$rest=mysql_query($sql);
while($row = mysql_fetch_assoc($rest))
    {
        $id = $row["id"];
        $title = $row["title"];
        $A = $row["answer_A"];
        $B = $row["answer_B"];
        $C = $row["answer_C"];
        $D = $row["answer_D"];
        $true = $row["true"];
        $score = $row["score"];
    }
?>
<p id="tiku">
    <form action="check.php" method="get">
        <p><?php echo $title;?></p>
        <input type="radio" name="xuanxiang" value="<?php echo $A;?>">A：<?php echo $A;?><br>
        <input type="radio" name="xuanxiang" value="<?php echo $B;?>">B：<?php echo $B;?><br>
        <input type="radio" name="xuanxiang" value="<?php echo $C;?>">C：<?php echo $C;?><br>
        <input type="radio" name="xuanxiang" value="<?php echo $D;?>">D：<?php echo $D;?><br><br>
        <input type="hidden" name="id" value="<?php echo $id;?>">
        <button>提交</button>
    </form>
</p>
    <br/>
    <?php
    echo "<p id=&#39;tiku&#39;>";
        echo "<ul>";
            echo "<li><a href=&#39;next.php?page=$prepage&#39;>上一题</a></li>";
            echo "<li><a href=&#39;next.php?page=$nextpage&#39;>下一题</a></li>";
        echo "</ul>";
    echo "<p>";
    echo "<br/>";
    echo "<p class=&#39;fenye_tips&#39;>共".$allpage."道题，当前是第".$page."题</p>";
    echo "<br/><br/>";
    echo "</p>";
    ?>
</body>
</html>

Copy after login

Form Receive

check.php

<?php
header("Content-type:text/html;charset=utf-8");
//获取数据库配置
require_once("config.php");
//连接数据库
$con = mysql_connect($host,$username,$password);
//设置数据库字符集  
mysql_query("SET NAMES UTF8");
//查询数据库
mysql_select_db($db, $con);
//获取数据
$xuanxiang = $_GET["xuanxiang"];
$id = $_GET["id"];
if (empty($xuanxiang)) {
    echo "<script>alert(&#39;请选择一个答案!&#39;);history.go(-1);</script>";
}else{
    //查询数据库
    $result = mysql_query("SELECT * FROM $tb WHERE id =".$id);
    while($row = mysql_fetch_array($result))
    {
        $true = $row["true"];
        $next_id = $id+1;
        if($xuanxiang == $true){
            echo "<script>alert(&#39;正确！得5分！&#39;);location.href=&#39;next.php?page=$next_id&#39;;</script>";
        }else{
            echo "<script>alert(&#39;错了！扣5分！&#39;);history.go(-1);</script>";
        }
    }
}
?>

Copy after login

Database configuration

config.php

<?php
//配置文件 - BY TANKING
$host="数据库地址";
$username="账号";
$password="密码";
$db="数据库名";
$tb = "表名";
?>

Copy after login

next.php

Next question

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0" />
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="format-detection" content="telephone=no">
    <title>题库</title>
    <style type="text/css">
        *{list-style: none;margin:0px;padding: 0px;}
        #tiku{
            width: 300px;
            margin:10px auto;
        }

        #tiku ul li{
            float: left;
        }
    </style>
</head>
<body>
<?php
//获取数据库配置
require_once("config.php");
//连接数据库
$con = mysql_connect($host,$username,$password);
//设置数据库字符集  
mysql_query("SET NAMES UTF8");
//查询数据库
mysql_select_db($db, $con);
//查询数据库
//获取最新的1条数据
$all = mysql_num_rows(mysql_query("select * from $tb"));
//定义分页所需的参数
$lenght=1;                             //每页显示的数量
@$page=$_GET[&#39;page&#39;]?$_GET[&#39;page&#39;]:1;    //当前页
$offset=($page-1)*$lenght;              //每页起始行编号
$allpage=ceil($all/$lenght);            //所有的页数-总数页
$prepage=$page-1;                       //上一页       
if($page==1){
    $prepage=1;                         //特殊的是当前页是1时上一页就是1
    }
$nextpage=$page+1;
if($page==$allpage){
    $nextpage=$allpage;                //特殊的是最后页是总数页时下一页就是总数页
    }
$sql="select * from $tb order by id ASC limit {$offset},{$lenght}";
$rest=mysql_query($sql);
while($row = mysql_fetch_assoc($rest))
    {
        $id = $row["id"];
        $title = $row["title"];
        $A = $row["answer_A"];
        $B = $row["answer_B"];
        $C = $row["answer_C"];
        $D = $row["answer_D"];
        $true = $row["true"];
        $score = $row["score"];
    }
?>
<p id="tiku">
    <form action="check.php" method="get">
        <p><?php echo $title;?></p>
        <input type="radio" name="xuanxiang" value="<?php echo $A;?>">A：<?php echo $A;?><br>
        <input type="radio" name="xuanxiang" value="<?php echo $B;?>">B：<?php echo $B;?><br>
        <input type="radio" name="xuanxiang" value="<?php echo $C;?>">C：<?php echo $C;?><br>
        <input type="radio" name="xuanxiang" value="<?php echo $D;?>">D：<?php echo $D;?><br><br>
        <input type="hidden" name="id" value="<?php echo $id;?>">
        <button>提交</button>
    </form>
</p>
    <br/>
    <?php
    echo "<p id=&#39;tiku&#39;>";
        echo "<ul>";
            echo "<li><a href=&#39;next.php?page=$prepage&#39;>上一题</a></li>";
            echo "<li><a href=&#39;next.php?page=$nextpage&#39;>下一题</a></li>";
        echo "</ul>";
    echo "<p>";
    echo "<br/>";
    echo "<p class=&#39;fenye_tips&#39;>共".$allpage."道题，当前是第".$page."题</p>";
    echo "<br/><br/>";
    echo "</p>";
    ?>
</body>
</html>

Copy after login

Database structure

title --------Title
answer_A -----Answer A
answer_B -----Answer B
answer_C -----Answer C
answer_D ----- Answer D
true ---------Correct answer
score --------Score

Related recommendations:

php mysql realizes simple login registration and password modification webpage

The above is the detailed content of php+mysql develops the simplest online question bank and online question making system. For more information, please follow other related articles on the PHP Chinese website!