Project Detail

Description

I need you to create a template in PHP/mySQL. I need it to show one question after other question on the same page. The template should random pick the question by level. I have set up the rules before going to the next page to print result.

I need you to storage in the database like this:

Table - Answer
Question_Asked(14, 20, 47, 30, etc)
Answer_Response(2, 3, 1, 1, 4, etc)
Correct_InCorrect (I, C, C, I, C, etc)

Using this result, I need you to print the result in chart.


Here are the rules that I need to set up:

At staring point, the exam always starts at level 2.
• First three answers are correct, go to level 3
• First three answers are incorrect go to level 1

At either level 3 or level 1:
• If only 3 out of 6 correct answers, go the same level
• If only 4 out of 6 correct answers, go up level
• If only 2 out of 6 correct answers, go down level
•

Stop when
• Got 3 out of 6 correct answers twice.
• If got 2 out of 6 correct answers at level 1.
• Got the first 6 incorrect answers then stop at Level 1.
• If only 2 out of 6 correct answers, go down then STOP
• Arrive to Level 6

example1:

1. Start at Level 2, did not get the first three correct or incorrect answers, then stay on level 2
2. Got 4 out of 6 correct answers, move to level 3
3. Got 3 out of 6 correct answers, stay on level 3
4. Got 4 out of 6 correct answers, move to level 4
5. Got 2 out of 6 correct answers, move to level 3
6. STOP, result is level 3. There is no question provided and exit from the exam.

example2:

1. Start at Level 2, got 3 straight correct answers. Move to level 3.
2. Got 3 out of 6 correct answers, stay on level 3.
3. Got 2 out of 6 correct answers, move to level 2.
4. STOP, result is level 2. There is no question provided and exit from the exam.

example3:

1. Start at Level 2, got 3 straight incorrect answers. Move to level 1.
2. Got 4 out of 6 correct answers, move to level 2.
3. Got 3 out of 6 correct answers, stay on level 2.
4. Got 4 out of 6 correct answers, move to level 3.
5. Got 4 out of 6 correct answers, move to level 4.
6. Got 2 out of 6 correct answers, move to level 3.
7. STOP, result is level 3. There is no question provided and exit from the exam.

example4:

1. Start at Level 2, got 3 straight correct answers. Move to level 3.
2. Got 3 out of 6 correct answers, stay on level 3.
3. Got 3 out of 6 correct answers, stay on level 3.
4. STOP, result is level 3. There is no question provided and exit from the exam.


----------
Ask me if you have any questions to clear this up.


Additional files submitted:
Create a Quiz Template.doc