欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

php+mysql開發(fā)的最簡單在線題庫(在線做題系統(tǒng))完整案例

 更新時(shí)間：2019年03月30日 00:53:58   作者：TANKING-  
這篇文章主要介紹了php+mysql開發(fā)的最簡單在線題庫(在線做題系統(tǒng))案例,結(jié)合完整實(shí)例形式分析了PHP結(jié)合MySQL數(shù)據(jù)庫查詢、判斷實(shí)現(xiàn)的在線題庫功能相關(guān)操作技巧,需要的朋友可以參考下

本文實(shí)例講述了php+mysql開發(fā)的最簡單在線題庫。分享給大家供大家參考，具體如下：

題庫，對于教育機(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;       //每頁起始行編號
$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('請選擇一個(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="賬號";
$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;       //每頁起始行編號
$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ù)庫操作技巧匯總》

希望本文所述對大家PHP程序設(shè)計(jì)有所幫助。

相關(guān)文章

最新評論