【PHP】选择题题库系统V1.0

最新推荐文章于 2023-08-13 21:50:43 发布

phjy007

最新推荐文章于 2023-08-13 21:50:43 发布

阅读量2.7k

点赞数 1

文章标签： php mysql query stylesheet database list

本文链接：https://blog.csdn.net/phjy007/article/details/5202241

版权

这个系统其实是练习php基本语法和MySQL的基本查询语句。给一起学习的朋友分享。 ^_^

在php文件中，双斜杠后面是注释语句，我用英文写的注释。

整个系统所包含的.htm和.php文件有：

add_que.htm——添加新题的页面

insert.php——显示添加新题信息的页面

questionlist.php——所有问题列表页面

search.htm——搜索问题的页面

result.php——搜索结果的页面

Mysql内，新建了“query”的数据库，内建“list”的数据表。表内含有7项：id,question,a,b,c,d,key。question为题干，a,b,c,d为四个选项，key为答案的选项。

下面是各个文件的代码.

/*add_que.htm*/----------------------------------------------------------------------

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <link href="index.css" mce_href="index.css" rel="stylesheet" type="text/css"/> <title>Add Question</title> </head> <body> <div style="margin: 0px auto;margin-top:100px; width: 500px;"> <form name="input" action="insert.php" method="get"> Please put your own question. <textarea cols="50" rows="5" name="question">

A.
B.
C.
D.

Choose The Right Answer:

Back To Question List

Search Question

/*insert.php*/----------------------------------------------------------------------

<title>Insert Page</title> <body style="margin:0px auto; margin-top:180px; margin-left:450px; width: 500px;"></body> <?php $db=mysql_connect("localhost:3321","root","root","query"); mysql_set_charset('gb2312',$db); if(!$db) { die('Connect Failed:'.mysql_error()); } mysql_select_db("query",$db); $sql="INSERT INTO `list` (`question`,`a`,`b`,`c`,`d`,`key`) VALUES ('$_GET[question]','$_GET[a]','$_GET[b]','$_GET[c]','$_GET[d]','$_GET[answer]')"; if(!mysql_query($sql,$db)) { die('Error:'.mysql_error()); } echo "Well done! Your new question has been successfully added."; mysql_close($db); ?> <a href="add_que.htm" mce_href="add_que.htm">Add More</a> <a href="http://localhost:8101/search.htm" mce_href="http://localhost:8101/search.htm">Search Question</a> <a href="questionlist.php" mce_href="questionlist.php">Back to Question Page</a>

/*questionlist.php*/----------------------------------------------------------------------

<head> <title> Question List </title> </head> <body> This is the Question List Page. <?php $db=mysql_connect('localhost:3321','root','root','query'); //connect to the database"query" mysql_set_charset('gb2312',$db); //set the Chinese language and characters if (!$db) { die('Could not connect: ' . mysql_error()); } mysql_select_db("query",$db); $result=mysql_query("SELECT * FROM list"); //begin to visit the table"list" in the database"query" $id=1; while($row=mysql_fetch_array($result)) //ehco the Questions & Answers in the table"list" on the page { echo $id.". ".$row['question']." "; echo "A. ".$row['a']." "; echo "B. ".$row['b']." "; echo "C. ".$row['c']." "; echo "D. ".$row['d']." "; echo "Key: ".$row['key']." "; $id++; } mysql_close($db); //close the connection ?> <a href="http://localhost:8101/add_que.htm" mce_href="http://localhost:8101/add_que.htm">Add Question</a> <a href="http://localhost:8101/search.htm" mce_href="http://localhost:8101/search.htm">Search Question</a> </body>

/*search.htm*/----------------------------------------------------------------------

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <link href="index.css" mce_href="index.css" rel="stylesheet" type="text/css"/> <title>Search Question</title> </head> <body> <div style="margin:0px auto; margin-top:160px; width: 500px;"> <form action="result.php" method="get"> Please input your question's key word: <input type="text" name="keyword">

Add More
Back to Question Page

/*result.php*/----------------------------------------------------------------------

<title>Search Result Page</title> <body style="margin:0px auto; margin-top:160px; margin-left:450px; width: 500px;"></body> <?php $key=$_GET[keyword];//get the user's keyword $db=mysql_connect("localhost:3321","root","root","query"); //connect to MySQL mysql_set_charset('gb2312',$db); //set Chinese language if(!$db) { die('Connect Failed:'.mysql_error()); } mysql_select_db("query",$db); //choose the database $result=mysql_query("SELECT * FROM list WHERE `question` LIKE '%$key%'"); //search $id=0; while($row=mysql_fetch_array($result)) { echo "Maybe here is the question:"." "; $id++; echo $id.". ".$row['question']." "; echo "A. ".$row['a']." "; echo "B. ".$row['b']." "; echo "C. ".$row['c']." "; echo "D. ".$row['d']." "; echo "Key: ".$row['key']." "; } if($id==0) //there is no related question in the database { echo "Sorry,there is no related question in the database."; } mysql_close($db); ?> <a href="add_que.htm" mce_href="add_que.htm">Add More</a> <a href="questionlist.php" mce_href="questionlist.php">Back to Question Page</a> <a href="http://localhost:8101/search.htm" mce_href="http://localhost:8101/search.htm">Search Question Again</a>

phjy007

关注

1
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
【PHP】选择题题库系统V1.0

这个系统其实是练习php基本语法和MySQL的基本查询语句。给一起学习的朋友分享。 ^_^在php文件中，双斜杠后面是注释语句，我用英文写的注释。整个系统所包含的.htm和.php文件有：add_que.htm——添加新题的页面insert.php——显示添加新题信息的页面questionlist.php——所有问题列表页面search.htm——搜索问题的页面r
复制链接

扫一扫