MultiWebQuiz 1.5 Help
MultiWebQuiz 1.5 offers a complete On-Line Quiz Management System.
To use this Web application, your site must be hosted on a server that supports PHP (4.0+) + MySQL.
After following a few basic instructions to set up and configure the MySQL database and then adding password protection to your admin directory, all you need do is enter your questions, answers and explanations into the user-friendly quiz creation form. They can be easily copied and pasted from any Word Processor.
Unpack the Zip File !
First unpack the zipped file, ideally to a new folder on your hard drive. This operation will create two new subfolders, inc and admin. The first folder contains HTML code snippets such as the page header and footer dynamically included in the main quiz pages as well as configuration data. The admin folder contains the quiz management pages.
| Main directory | /inc/ | /img/ | /img/ |
|---|---|---|---|
| index.php marktest.php multiteststyle.css quiz.php results.php |
inc/
db_config.inc.php header.inc.php footer.inc.php header_admin.php |
correct_tick.gif skipped.gif wrong_cross.gif |
config_make.php create_tables.php help.php hormenu.php index.php question_delete.php question_deleted.php question_edit_form.inc.php question_update.php question_updated.php questions.php questnav.inc.php quiz_add.php quiz_add_form.inc.php quiz_added.inc.php quiz_reedit_form.inc.php searchform.inc.php searchq.php setup.php sub_update_view.inc.php subject_add.php subject_added.php subject_delete.php subject_deleted.php subject_edit_form.php subject_update.php subject_updated.php update_view.inc.php |
Set Up the Database !
The quiz management system will not actually create the database, because your server, administered in all likelihood by a remote Web host, may impose restrictions on the number and names of databases.
If you need to set up a new database, here's the correct SQL command:
CREATE DATABASE quiz;
If necessary, set the database access password as follows:
GRANT ALL PRIVILEGES ON database_name TO username IDENTIFIED BY password;
It's that simple. PhpMyAdmin is a good PHP and MySQL administration tool and may be preinstalled on your server. If not, download the latest version and then upload it to a special directory on your Web space. Remember to add password protection to all admin directories. Many Web hosting services will have an online control panel to let you do this effortlessly.
Configure MultiWebQuiz to work with your database:
All this data is stored in one small file inc/db_config.inc.php .
function db_connect()
{
$result = @mysql_pconnect('host[:port]', 'username', 'password');
if (!$result)
return false;
if (!@mysql_select_db('database'))
return false;
return $result;
}
Do not overwrite the inverted commas. If in doubt, contact your Web Host, who should furnish you with the correct details.
host: Type your host name here at the end in inverted commas. Localhost if it is on the same server. If it is on another server, place the port number after a colon at the end.
username: Type your database user name in inverted commas.
password: Type your database password here in inverted commas.
database: Type your database name here in inverted commas..
Password Protection
There are no links from the quiz in the main section to the admin zone, but nonethless remember to add password protection to the admin directory. Many Web hosting services will have an online control panel to let you do this effortlessly. If your site is hosted on an Apache server you can edit the .htaccess file.
Upload The Files to your Server
Use an FTP program, which may be integrated in your HTML editor, to upload the files to your Website.
Main admin page URL: http://www.your_website.com/[subdirectory]/admin/index.php
Click Create Tables.
Navigate to main_quiz_directory/admin/index.php and click Create Tables. If this does not work, check your host name, user name, database password and database name. If the database is on a remote server, check the port number with your WebHost. Please note this command will overwrite any tables of the same name.
If you're using phpMyAdmin, you may run these SQL queries:
DROP TABLE IF EXISTS questions;
CREATE TABLE questions (
ID int(4) unsigned zerofill NOT NULL auto_increment,
question text NOT NULL,
test varchar(31) NOT NULL default '',
ans1 text NOT NULL,
ans2 text NOT NULL,
ans3 text NOT NULL,
ans4 text NOT NULL,
ans5 text,
ans6 text,
corans varchar(8) NOT NULL default '',
expl text NOT NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
DROP TABLE IF EXISTS subjects;
CREATE TABLE subjects (
ID int(4) unsigned zerofill NOT NULL auto_increment,
cat varchar(31) NOT NULL default '',
descr text NOT NULL,
random int(1) default NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
Adding Questions:
After creating the database, Questions and Subjects tables, just add at least one subject area. You can now add as many questions as you like.
Special Characters and Line Breaks:
Tick Use "Special Characters" to convert all special characters such as &, <, >, è or é to HTML entities for database storage. This will ensure such characters are viewable in HTML. This option will also convert line breaks to <br /> tags. Otherwise, all data will read as raw HTML so you can use tags within questions, answers and explanations.
Customising Layout and Formatting:
MultiWebQuiz uses a stylesheet and some custom classes are essential to the Quiz, in particular p#bignav, span#subnav, table#qst and ol#numbered.
However, a little basic understanding of stylesheets should let you change much of formatting.
To add your own custom header, just edit inc/header.inc.php file and use standard HTML under the body tag. Remember the paths of all images you may include in your header are relative to the page and not to the header stored in the /inc/ folder.
Bugs and Bears
As the quiz script relies on CSS2 formatting, it will not display correctly in Netscape 4.7. It has, however, been tested on IE 6, Opera 7, Mozilla 1.2 and Netscape 6.0.
Answer Modes and Answer Exclude Codes
MultiWebQuiz 1.5 supports three types of questions:
- Multiple choice with as many as 6 answer options (default), of which only one may be correct.
- Multiple answer with as many as 6 answer options,of which more than one may be correct.
By Simply leaving the fourth, fifth or sixth answer fields blank in the question edit or update forms, MultiWebQuiz will add a code q#exc to this database field to exclude this option from the test. - If the Boolean checkbox is ticked [checked], answer option 1 becomes true and 2 false. MultiWebQuiz fills the other answer fields with xb##l and will shuffle only the true and false options.
If you see these codes in the question edit form, ignore them unless you wish to change the answer mode.
