本文實(shí)例講述了php+mysql開發(fā)的最簡單在線題庫。分享給大家供大家參考,具體如下:
題庫,對(duì)于教育機(jī)構(gòu),學(xué)校,在線教育,是很有必要的,網(wǎng)上也有不少的第三方在線題庫系統(tǒng),但是本次案例,會(huì)讓有需要的人了解題庫的開發(fā)思路,其實(shí)很簡單,無非就是一個(gè)表單驗(yàn)證,數(shù)據(jù)庫驗(yàn)證。
1、先構(gòu)建表單數(shù)據(jù)
2、把表單數(shù)據(jù)通過get或者post方式提交到表單驗(yàn)證頁面,和數(shù)據(jù)庫進(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>題庫/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ù)庫配置
require_once("config.php");
//連接數(shù)據(jù)庫
$con = mysql_connect($host,$username,$password);
//設(shè)置數(shù)據(jù)庫字符集
mysql_query("SET NAMES UTF8");
//查詢數(shù)據(jù)庫
mysql_select_db($db, $con);
//查詢數(shù)據(jù)庫
//獲取最新的1條數(shù)據(jù)
$all = mysql_num_rows(mysql_query("select * from $tb"));
//定義分頁所需的參數(shù)
$lenght=1; //每頁顯示的數(shù)量
@$page=$_GET['page']?$_GET['page']:1; //當(dāng)前頁
$offset=($page-1)*$lenght; //每頁起始行編號(hào)
$allpage=ceil($all/$lenght); //所有的頁數(shù)-總數(shù)頁
$prepage=$page-1; //上一頁
if($page==1){
$prepage=1; //特殊的是當(dāng)前頁是1時(shí)上一頁就是1
}
$nextpage=$page+1;
if($page==$allpage){
$nextpage=$allpage; //特殊的是最后頁是總數(shù)頁時(shí)下一頁就是總數(shù)頁
}
$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"];
}
?>
div 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>
/div>
br/>
?php
echo "div 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 "div>";
echo "br/>";
echo "p class='fenye_tips'>共".$allpage."道題,當(dāng)前是第".$page."題/p>";
echo "br/>br/>";
echo "/div>";
?>
/body>
/html>
表單接收
check.php
?php
header("Content-type:text/html;charset=utf-8");
//獲取數(shù)據(jù)庫配置
require_once("config.php");
//連接數(shù)據(jù)庫
$con = mysql_connect($host,$username,$password);
//設(shè)置數(shù)據(jù)庫字符集
mysql_query("SET NAMES UTF8");
//查詢數(shù)據(jù)庫
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{
//查詢數(shù)據(jù)庫
$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ù)庫配置
config.php
?php
//配置文件 - BY TANKING
$host="數(shù)據(jù)庫地址";
$username="賬號(hào)";
$password="密碼";
$db="數(shù)據(jù)庫名";
$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
//獲取數(shù)據(jù)庫配置
require_once("config.php");
//連接數(shù)據(jù)庫
$con = mysql_connect($host,$username,$password);
//設(shè)置數(shù)據(jù)庫字符集
mysql_query("SET NAMES UTF8");
//查詢數(shù)據(jù)庫
mysql_select_db($db, $con);
//查詢數(shù)據(jù)庫
//獲取最新的1條數(shù)據(jù)
$all = mysql_num_rows(mysql_query("select * from $tb"));
//定義分頁所需的參數(shù)
$lenght=1; //每頁顯示的數(shù)量
@$page=$_GET['page']?$_GET['page']:1; //當(dāng)前頁
$offset=($page-1)*$lenght; //每頁起始行編號(hào)
$allpage=ceil($all/$lenght); //所有的頁數(shù)-總數(shù)頁
$prepage=$page-1; //上一頁
if($page==1){
$prepage=1; //特殊的是當(dāng)前頁是1時(shí)上一頁就是1
}
$nextpage=$page+1;
if($page==$allpage){
$nextpage=$allpage; //特殊的是最后頁是總數(shù)頁時(shí)下一頁就是總數(shù)頁
}
$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"];
}
?>
div 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>
/div>
br/>
?php
echo "div 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 "div>";
echo "br/>";
echo "p class='fenye_tips'>共".$allpage."道題,當(dāng)前是第".$page."題/p>";
echo "br/>br/>";
echo "/div>";
?>
/body>
/html>
數(shù)據(jù)庫結(jié)構(gòu)
title --------題目
answer_A -----答案A
answer_B -----答案B
answer_C -----答案C
answer_D -----答案D
true ---------正確答案
score --------得分
更多關(guān)于PHP相關(guān)內(nèi)容感興趣的讀者可查看本站專題:《php+mysql數(shù)據(jù)庫操作入門教程》、《php+mysqli數(shù)據(jù)庫程序設(shè)計(jì)技巧總結(jié)》、《php面向?qū)ο蟪绦蛟O(shè)計(jì)入門教程》、《PHP數(shù)組(Array)操作技巧大全》、《php字符串(string)用法總結(jié)》及《php常見數(shù)據(jù)庫操作技巧匯總》
希望本文所述對(duì)大家PHP程序設(shè)計(jì)有所幫助。
您可能感興趣的文章:- java+vue實(shí)現(xiàn)添加單選題、多選題到題庫功能
- PHP實(shí)現(xiàn)類似題庫抽題效果
- JavaScript實(shí)現(xiàn)英語單詞題庫