The project will consist of a MySQL table TEST with fields (quest_no, categoryid, question_type, question, option1, option2, option3, option4, option5, option6, correctanswer, score_for_this_question) which will contain a number of questions. There will be 3 question types ((i) multiple choice - select 1 best answer ; (ii) select all that apply (iii) no answers/options will be provided to the question - user must key in the answer based on the question)
The PHP code will receive as parameter the categoryid and then retrieve, one by one, questions corresponding to that category from the TEST table and display them on screen - the program will display the question according to its type(i, ii or iii). Upon validation by the user of his answer, the code will determine if answer is Ok/not ok and add marks according to score_for_this_question, and then will move on to the next question. No results should be displayed as yet. Only when there are no more questions from this category will the code display a final page showing the total marks obtained by user, no of questions correctly answered & incorrectly answered.
For question type (iii) check to be made against SQL injection attack.