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

Home

Backend Development

PHP Tutorial

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

不言

Apr 28, 2018 pm 02:03 PM

phpphp+mysql

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>

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>";
        }
    }
}
?>

Database configuration

config.php

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

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>

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!

Statement

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