題庫，對于教育機構，學校，在線教育，是很有必要的，網上也有不少的第三方在線題庫系統，但是本次案例，會讓有需要的人了解題庫的開發思路，其實很簡單，無非就是一個表單驗證，數據庫驗證。
1、先構建表單數據
2、把表單數據通過get或者post方式提交到表單驗證頁面，和數據庫進行匹配
3、返回結果，答案正確或者錯誤
構建表單：
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['page']?$_GET['page']: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='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."道題，當前是第".$page."題</p>"; echo "<br/><br/>"; echo "</p>"; ?></body></html>
表單接收
check.php
<?phpheader("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('請選擇一個答案!');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('正確！得5分！');location.href='next.php?page=$next_id';</script>"; }else{ echo "<script>alert('錯了！扣5分！');history.go(-1);</script>"; } }}?>數據庫配置
config.php
<?php//配置文件 - BY TANKING$host="數據庫地址";$username="賬號";$password="密碼";$db="數據庫名";$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>題庫</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['page']?$_GET['page']: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='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."道題，當前是第".$page."題</p>"; echo "<br/><br/>"; echo "</p>"; ?></body></html>數據庫結構
title --------題目
answer_A -----答案A
answer_B -----答案B
answer_C -----答案C
answer_D -----答案D
true ---------正確答案
score --------得分
相關推薦：
php+mysql實現簡單登錄注冊修改密碼網頁
以上就是php+mysql開發一個最簡單的在線題庫，在線做題系統的詳細內容，更多請關注 其它相關文章！
鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。
新聞熱點
疑難解答
