{"id":271,"date":"2011-05-10T22:18:31","date_gmt":"2011-05-11T03:18:31","guid":{"rendered":"http:\/\/xlinesoft.com\/blog\/?p=271"},"modified":"2012-09-15T15:08:46","modified_gmt":"2012-09-15T20:08:46","slug":"quiz-template","status":"publish","type":"post","link":"https:\/\/xlinesoft.com\/blog\/2011\/05\/10\/quiz-template\/","title":{"rendered":"Quiz template"},"content":{"rendered":"

This article explains how the Quiz Template works in great details. It can help you better understand the inner workings of this template and provide the guidance you need in designing your own. <\/p>\n

Quiz template live demo<\/a><\/p>\n

Purchase Quiz template for $25<\/a>. <\/p>\n

Lets start with database design. In this tutorial we use MySQL database.<\/p>\n

\"Quiz<\/p>\n

<\/p>\n

Database schema<\/h3>\n

Table:<\/strong> tests<\/p>\n

Stores test\/quiz names and description.<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\nname – varchar(50)
\ndescription – varchar(512)<\/p>\n

Table:<\/strong> questions<\/p>\n

Stores questions for each test. testid points to the parent test in tests table. asnswer_explained (optional) contains detailed answer to this question. The number of questions per test is unlimited.<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\ntestid – int
\nquestion – varchar(255)
\nasnswer_explained – varchar(4000)<\/p>\n

Table:<\/strong> answers<\/p>\n

Stores answer choices for each question. Each question can have as many answers as you want. correct<\/strong> field indicates if this is a correct answer.<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\nquestionid – int
\ntext – varchar(512)
\ncorrect – tinyint<\/p>\n

Table:<\/strong> responses<\/p>\n

This table contains actual responses. There might be more than one response per user to the same test.<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\nuserid – int
\ntestid – int
\nscore – int<\/p>\n

Table:<\/strong> response_details<\/p>\n

Related as Details to Responses. Stores response details for each question user answered (some question can be left unanswered).<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\nresponseid – int
\nquestionid\u00a0 – int
\nasnwerdid – int<\/p>\n

Table:<\/strong> users<\/p>\n

This table stores users info like email and IP address. You may want to add more fields to this table, especially if you want users to register before taking the quiz.<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\nemail – varchar(50)
\npassword – varchar(50)
\nip – varchar(20)<\/p>\n

Table:<\/strong> messages<\/p>\n

On quiz results page you may want to show user a custom message like “Good job!” or “Needs more work”. Add your messages to this table and specify score range which triggers the message to be displayed. Messages are test specific.<\/p>\n

Fields<\/strong><\/p>\n

id – int, primary key
\ntestid – int
\nmin – int
\nmax – int
\nmessage – varchar(1000)<\/p>\n

Application setup<\/h3>\n

Quiz template utilizes a simple security model. There is one admin user (username: admin@test.com password: admin1) with access to all tables and data. Guest access is enabled and guests users are allowed to access Add page of Responses table. Users do not have to register in order to take the quiz.<\/p>\n

Most of application logic is stored in two events of Responses table Add page: BeforeProcess and BeforeDisplay.<\/p>\n

BeforeProcess event<\/strong><\/p>\n

– get current user id. we use IP address lookup to find if such a user already exists. If IP address not found we create a new user.
\n– insert a record into responses table and get a responseid.
\n– insert one record per answer in response_details table.
\n– calculate score and save it in the database<\/p>\n

BeforeDisplay event<\/strong><\/p>\n

This event is responsible for the visual representation of our quiz. As a first step we override default template file as we want to use our own (quiz.htm).<\/p>\n

This template requires three display modes:<\/p>\n

– Questions mode. Default mode.
\n– Results mode. Triggered by $_POST[“a”]==”save” condition.
\n– Questions and answers mode. Triggered by $_REQUEST[“showanswers”]==1 condition.<\/p>\n

As we said, this project also uses a custom HTML template – quiz.htm which provides a completely different look and feel than all standard PHPRunner pages.<\/p>\n

\"Quiz<\/p>\n

The template file is a regular HTML file stuffed with the template variables. For instance, here is the section that displays the quiz results:<\/p>\n

{BEGIN results_block}\r\n\r\n\r\n
\r\nScore:<\/strong> {$right_answers} out of {$total_questions}\r\nPercentage:<\/strong> {$percentage}%<\/div>\r\n\r\n\u00a0\r\n\r\n
\r\n{$message}<\/div>\r\n\r\n\u00a0\r\n\r\n
\r\n\r\n<\/div>\r\n\r\n{END results_block}\r\n<\/pre>\n
Here is the code snippet that processes template variables:<\/p>\n
$xt->assign(\"results_block\", true);\r\n$xt->assign(\"questions_block\", false);\r\n$rs1 = CustomQuery(\"select message from messages where min<=\".$_SESSION[\"right_answers\"].\"  \t\r\n       and max>=\".$_SESSION[\"right_answers\"].\" and testid=\".$_SESSION[\"testid\"] );\r\n$data1 = db_fetch_array($rs1);\r\nif ($data1)\r\n\t$xt->assign(\"message\", $data1[\"message\"]);\r\n$xt->assign(\"right_answers\", $_SESSION[\"right_answers\"]);\r\n$xt->assign(\"total_questions\", $_SESSION[\"total_questions\"]);\r\n$xt->assign(\"percentage\", $_SESSION[\"percentage\"]);<\/pre>\n
Here is the HTML code generated by this template:<\/p>\n
\r\nScore:<\/strong> 0 out of 13\r\nPercentage:<\/strong> 0.0%<\/div>\r\n
\r\nRank:<\/span> Student\r\n<\/div>\r\n
\r\n\r\n\r\n<\/div><\/pre>\n
Additional files<\/h3>\n
We are going to use a few additional files. You can find them in the source<\/strong> directory under your project directory.<\/p>\n
templates\\quiz.htm<\/strong> – custom quiz template file. If you need to modify your quiz visual appearance this is the file to edit.
\nquiz.css<\/strong> – stylesheet file
\nimages<\/strong> folder – a few extra images we are going to need<\/p>\n
How to create a new test<\/h3>\n
1. Login as an admin and proceed to the tests<\/strong> table. Add a new test. If you use inline mode you can add tests, questions and answers without leaving the same page.<\/p>\n
2. Add questions for this test.<\/p>\n
3. Add answers for each question. Make sure to mark one of answers as the correct one.<\/p>\n
4. Add messages (optional). Make sure to specify the range (min and max score values that triggers message to be displayed).<\/p>\n
\"Create<\/p>\n
This is it. Click “Take test” next to test name to take the test. Save this URL and add a link to this quiz somewhere on your website or send this link via email.<\/p>\n
Further enhancements<\/h3>\n
You may want to add the following functionality:<\/p>\n
1. Charts or reports to visualize the percentage of answered questions by quiz or by a separate question.<\/p>\n
2. You can make users register before they take their test. Add a registration page, turn off Guest access and make sure Default group has access to the Add page of the Responses table.<\/p>\n
3. You may want to add an option make the quiz inactive. This will require a new field in tests<\/strong> table. You can either make quiz active\/inactive manually or you can add an expiration date.\u00a0 In both cases you will need to add a few lines of code to Responses Add page BeforeProcess event to stop processing if quiz is currently inactive.<\/p>\n
4. Post your own suggestions in comments.<\/p>\n","protected":false},"excerpt":{"rendered":"
This article explains how the Quiz Template works in great details. It can help you better understand the inner workings of this template and provide the guidance you need in designing your own. Quiz template live demo Purchase Quiz template for $25. Lets start with database design. In this tutorial we use MySQL database.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,4,3,8],"tags":[],"_links":{"self":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/271"}],"collection":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=271"}],"version-history":[{"count":53,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/271\/revisions"}],"predecessor-version":[{"id":694,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/271\/revisions\/694"}],"wp:attachment":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}