php考试复习题(php+mysql开发的最简单在线题库在线做题系统完整案例)
类别:编程学习 浏览量:225
时间:2022-03-31 22:53:39 php考试复习题
php+mysql开发的最简单在线题库在线做题系统完整案例本文实例讲述了php+mysql开发的最简单在线题库。分享给大家供大家参考,具体如下:
题库,对于教育机构,学校,在线教育,是很有必要的,网上也有不少的第三方在线题库系统,但是本次案例,会让有需要的人了解题库的开发思路,其实很简单,无非就是一个表单验证,数据库验证。
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" ]; } ?> <li 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> </li> <br/> <?php echo "<li 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 "<li>" ; echo "<br/>" ; echo "<p class='fenye_tips'>共" . $allpage . "道题,当前是第" . $page . "题</p>" ; echo "<br/><br/>" ; echo "</li>" ; ?> </body> </html> |
表单接收
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('请选择一个答案!');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" ]; } ?> <li 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> </li> <br/> <?php echo "<li 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 "<li>" ; echo "<br/>" ; echo "<p class='fenye_tips'>共" . $allpage . "道题,当前是第" . $page . "题</p>" ; echo "<br/><br/>" ; echo "</li>" ; ?> </body> </html> |
数据库结构
title --------题目
answer_A -----答案A
answer_B -----答案B
answer_C -----答案C
answer_D -----答案D
true ---------正确答案
score --------得分
希望本文所述对大家PHP程序设计有所帮助。
您可能感兴趣
- phpinclude的使用方法(PHP defined函数的使用图文详解)
- phpstudy 目录浏览宽度(JspStudy如何设置PHP根目录可编辑)
- php各种绕过姿势(php面试实现反射注入的详细方法)
- apache和php如何配置(Apache2与PHP5 for WinXP简单配置技巧)
- thinkphp5框架怎么打开(thinkphp5.1框架模板布局与模板继承用法分析)
- php面向对象怎么调用属性(PHP面向对象程序设计__tostring和__invoke用法分析)
- php定时执行PHP(Cpanel下Cron Jobs定时执行PHP的方法)
- iis运行php程序(Windows2003+IIS7 Express使用FastCgi运行php)
- 用php递归函数实现阶乘的计算(php求斐波那契数的两种实现方式递归与递推)
- php开发的主要技术(详解PHP神奇又有用的Trait)
- php环境搭建windows系统(Windows环境下安装PHP Pear的方法图文教程)
- phpstudy如何部署在linux上(phpstudy linux面板CC防护功能使用教程)
- phpstudy搭建网站全过程(phpstudy在本地搭建多个网站的方法)
- php无法读取txt文件(php写入txt乱码的解决方法)
- apache配置详解(apache2.2和php5.2.17在windows下整合过程的错误解决方法)
- php常用加密技术(php用户名的密码加密更安全的方法)
- 对你思念入骨的女人,跟你见面时会有这几种表现,藏都藏不住(对你思念入骨的女人)
- 纳兰性德绝美作,一场重逢,成就最后一首称得上惊艳的《如梦令》(纳兰性德绝美作)
- 如何快速赚钱(如何快速赚钱方法真实有效)
- 这里输入关键词(如何输入关键词)
- 熊猫中国国宝(熊猫国宝酒53酱香)
- 春节会放假几天(春节会放假吗)
热门推荐
- dedecms变量的使用(dedecms实现游客可以提问、回答及查看的方法)
- python 装饰器模式(python重试装饰器的简单实现方法)
- mysql数据库调优技术大全(Mysql数据库性能优化三分表、增量备份、还原)
- 网页502错误怎么解决(502 bad gateway是什么意思?网页打不开出现502 bad gateway怎么解决?)
- centos7怎样安装vnc(Ubuntu 20.04系统中安装vncserver的方法步骤)
- 同步、异步、阻塞、非阻塞
- 防火墙如何设置ftp连接(浅谈防火墙对FTP的影响及故障排除分析)
- 查看mysql执行计划关键字(带你学习MySQL执行计划)
- php面向对象final怎么设置(PHP面向对象程序设计中的self、static、parent关键字用法分析)
- SQL语句查询SQL SERVER作业的调度信息
排行榜
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9