php+mysql開(kāi)發(fā)一個(gè)最簡(jiǎn)單的在線題庫(kù)，在線做題系統(tǒng)

2020-03-24 18:12:52

字體：大中小

供稿：網(wǎng)友

這篇文章主要介紹了php+mysql開(kāi)發(fā)一個(gè)最簡(jiǎn)單的在線題庫(kù)，在線做題系統(tǒng)，有著一定的參考價(jià)值，現(xiàn)在分享給大家，有需要的朋友可以參考一下

題庫(kù)，對(duì)于教育機(jī)構(gòu)，學(xué)校，在線教育，是很有必要的，網(wǎng)上也有不少的第三方在線題庫(kù)系統(tǒng)，但是本次案例，會(huì)讓有需要的人了解題庫(kù)的開(kāi)發(fā)思路，其實(shí)很簡(jiǎn)單，無(wú)非就是一個(gè)表單驗(yàn)證，數(shù)據(jù)庫(kù)驗(yàn)證。

1、先構(gòu)建表單數(shù)據(jù)

2、把表單數(shù)據(jù)通過(guò)get或者post方式提交到表單驗(yàn)證頁(yè)面，和數(shù)據(jù)庫(kù)進(jìn)行匹配

3、返回結(jié)果，答案正確或者錯(cuò)誤

構(gòu)建表單：

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>題庫(kù)</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//獲取數(shù)據(jù)庫(kù)配置require_once("config.php");//連接數(shù)據(jù)庫(kù)$con = mysql_connect($host,$username,$password);//設(shè)置數(shù)據(jù)庫(kù)字符集  mysql_query("SET NAMES UTF8");//查詢(xún)數(shù)據(jù)庫(kù)mysql_select_db($db, $con);//查詢(xún)數(shù)據(jù)庫(kù)//獲取最新的1條數(shù)據(jù)$all = mysql_num_rows(mysql_query("select * from $tb"));//定義分頁(yè)所需的參數(shù)$lenght=1;                             //每頁(yè)顯示的數(shù)量@$page=$_GET['page']?$_GET['page']:1;    //當(dāng)前頁(yè)$offset=($page-1)*$lenght;              //每頁(yè)起始行編號(hào)$allpage=ceil($all/$lenght);            //所有的頁(yè)數(shù)-總數(shù)頁(yè)$prepage=$page-1;                       //上一頁(yè)       if($page==1){    $prepage=1;                         //特殊的是當(dāng)前頁(yè)是1時(shí)上一頁(yè)就是1    }$nextpage=$page+1;if($page==$allpage){    $nextpage=$allpage;                //特殊的是最后頁(yè)是總數(shù)頁(yè)時(shí)下一頁(yè)就是總數(shù)頁(yè)    }$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='tiku'>";        echo "<ul>";            echo "<li><a href='next.php?page=$prepage'>上一題</a></li>";            echo "<li><a href='next.php?page=$nextpage'>下一題</a></li>";        echo "</ul>";    echo "<p>";    echo "<br/>";    echo "<p class='fenye_tips'>共".$allpage."道題，當(dāng)前是第".$page."題</p>";    echo "<br/><br/>";    echo "</p>";    ?></body></html>

表單接收

check.php

<?phpheader("Content-type:text/html;charset=utf-8");//獲取數(shù)據(jù)庫(kù)配置require_once("config.php");//連接數(shù)據(jù)庫(kù)$con = mysql_connect($host,$username,$password);//設(shè)置數(shù)據(jù)庫(kù)字符集  mysql_query("SET NAMES UTF8");//查詢(xún)數(shù)據(jù)庫(kù)mysql_select_db($db, $con);//獲取數(shù)據(jù)$xuanxiang = $_GET["xuanxiang"];$id = $_GET["id"];if (empty($xuanxiang)) {    echo "<script>alert('請(qǐng)選擇一個(gè)答案!');history.go(-1);</script>";}else{    //查詢(xún)數(shù)據(jù)庫(kù)    $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('正確！得5分！');location.href='next.php?page=$next_id';</script>";        }else{            echo "<script>alert('錯(cuò)了！扣5分！');history.go(-1);</script>";        }    }}?>

數(shù)據(jù)庫(kù)配置

config.php

<?php//配置文件 - BY TANKING$host="數(shù)據(jù)庫(kù)地址";$username="賬號(hào)";$password="密碼";$db="數(shù)據(jù)庫(kù)名";$tb = "表名";?>

next.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>題庫(kù)</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//獲取數(shù)據(jù)庫(kù)配置require_once("config.php");//連接數(shù)據(jù)庫(kù)$con = mysql_connect($host,$username,$password);//設(shè)置數(shù)據(jù)庫(kù)字符集  mysql_query("SET NAMES UTF8");//查詢(xún)數(shù)據(jù)庫(kù)mysql_select_db($db, $con);//查詢(xún)數(shù)據(jù)庫(kù)//獲取最新的1條數(shù)據(jù)$all = mysql_num_rows(mysql_query("select * from $tb"));//定義分頁(yè)所需的參數(shù)$lenght=1;                             //每頁(yè)顯示的數(shù)量@$page=$_GET['page']?$_GET['page']:1;    //當(dāng)前頁(yè)$offset=($page-1)*$lenght;              //每頁(yè)起始行編號(hào)$allpage=ceil($all/$lenght);            //所有的頁(yè)數(shù)-總數(shù)頁(yè)$prepage=$page-1;                       //上一頁(yè)       if($page==1){    $prepage=1;                         //特殊的是當(dāng)前頁(yè)是1時(shí)上一頁(yè)就是1    }$nextpage=$page+1;if($page==$allpage){    $nextpage=$allpage;                //特殊的是最后頁(yè)是總數(shù)頁(yè)時(shí)下一頁(yè)就是總數(shù)頁(yè)    }$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='tiku'>";        echo "<ul>";            echo "<li><a href='next.php?page=$prepage'>上一題</a></li>";            echo "<li><a href='next.php?page=$nextpage'>下一題</a></li>";        echo "</ul>";    echo "<p>";    echo "<br/>";    echo "<p class='fenye_tips'>共".$allpage."道題，當(dāng)前是第".$page."題</p>";    echo "<br/><br/>";    echo "</p>";    ?></body></html>

數(shù)據(jù)庫(kù)結(jié)構(gòu)

title --------題目
answer_A -----答案A
answer_B -----答案B
answer_C -----答案C
answer_D -----答案D
true ---------正確答案
score --------得分