title: Creating A Custom Made Online MCQ Quiz Using PHP and MySQL
body: <p>I would like to create custom-made MCQ(only one correct answer) online quiz displaying only one question per page. Here is my database set up for the quiz.</p>
  
  <p>(1) QuestionBankTable</p>
  
  <pre><code>|QuestionID|QuestionText|
  |2|What is the HTTP port number?|
  </code></pre>
  
  <p>Objectives of this table is to </p>
  
  <p>~Enter(new) and edit(current) questions</p>
  
  <p>~Select and display the questions.</p>
  
  <p>(2) OptionsTable</p>
  
  <pre><code>|AnswerID|QuestionID|AnswerText|
  |21|2|80|
  |22|2|53|
  |23|2|8080|
  |24|2|1278|
  </code></pre>
  
  <p>Objectives of this table is to </p>
  
  <p>~Enter(new) and edit(current) options to each of the question</p>
  
  <p>~Select and display the options of each question.</p>
  
  <p>(3) AnswerSheetTable</p>
  
  <pre><code>|QuestionID|AnswerID|     
  |2|21|
  </code></pre>
  
  <p>Objectives of this table is to</p>
  
  <p>~Store the respective correct answer to the respective question.</p>
  
  <p>(4) AnswerScriptsTable</p>
  
  <pre><code>|StudentID|(QuestionID)1|(QuestionID)2|
  |S678|(AnswerID)13|(AnswerID)21| 
  </code></pre>
  
  <p>Objectives of this table is to</p>
  
  <p>~Store the respective answer given by the student to each of the corresponding questions.</p>
  
  <p>~This will later be used to compare against the <code>AnswerSheetTable</code> to determine the number of correction answers and give the marks according in a PHP script.</p>
  
  <p>=================================================================================</p>
  
  <p>The main core of this quiz relies heavily on the PHP scripting.</p>
  
  <pre><code>|WebBrowser(HTML)|
  |PHP Scripts|
  |MySQL Database|
  </code></pre>
  
  <p>I have read up on the basic php/html/SQL tutorials but I need guidance on how should I go about <code>PLANNING</code> &amp; <code>ORGANIZATION</code> the structure of the PHP scripts to provide an Optimal output of the quiz?</p>
  
  <p>For example.</p>
  
  <p>(1)The names of the necessary PHP scripts and their specific functions inside the script.</p>
  
  <p>(P.S. I would like to display only one question per page with the option of navigating to the next or the previous question.)</p>