How to Create Simple Quiz using PHP and MySQL

Hey Technoz, If you want to create a simple quiz web application then this tutorial is really going to help you. If you want to build the quiz based website then you must start from simple. In this tutorials we are going to focus on the fundamental logic for building of quiz web application. In furthermore tutorials we will learn the advance tutorial of quiz building.

Creating database

A database need to be create to store the information about questions, answers and user’s submitted answers.

So lets create the database by using following queries. The following SQL  creates quiz table which consist of  id, questions, options  and answers details.

Dumping data for table ‘quiz’

Now lets insert records into the table by using following queries

Database Configuration

First, to make it convenient, we will create a new PHP file for database configuration named dbconfig.php  that holds all configured parameters:

Code for Quiz Web Application

Now its time to code the Quiz web application, In this

The questions and its answers are store in the database table ‘quiz’ and fetch one by one after clicking the next button

$_SESSION[‘clicks’] is use to identify which question will fetch and to maintain its sequence.

session_unset() is use to unset the session variable finish the quiz after solving all of questions

And simple inserting , fetching and uploading of operations which we already covered in our previous tutorials.

CSS for Quiz Web Application

Add effects and styling to the Quiz Web Application by using CSS which give it a better look and save the file by name index.css 

The view of the both HTML and CSS is illustrate in the following snapshot:

How to Create Simple Quiz using PHP and MySQL

After Solving the all questions we provided an option for view the result. In this you can check the number of correct answer from the question you attempted.

How to Create Simple quiz web using PHP and MySQL

In this tutorial we have learn to create basic quiz web application in furthermore tutorials we will learn some advance method to improve features of this. So make sure you have connected with us via Subscribe button.

If you have any doubts regarding to this tutorial feel free to ask in the comment section below.

To catch even more knowledgeable and easy understandable tutorials please subscribe to get email notification.

Download Source Code


15 thoughts on “How to Create Simple Quiz using PHP and MySQL

  1. A
    Austin says:

    “clicks” is never defined. When you run this you get the following error message
    Notice: Undefined index: clicks in /opt/lampp/htdocs/testing/theQuiz.php on line 19
    Surely you know this, is there a fix?

  2. s
    shravya says:

    Actually this code helped us a lot but we are stuck up in one point the options are not getting displayed on the screen instead only radio buttons and the questions are visible on the screen

    1. Akshay says:

      Hi Tarun,

      First of all, I want to apologize for the experience you’ve had downloading code. The download link of the code works but most of people find it tricky and I understand how frustrating it is.

      Please drop your e-mail so that our team can provide you the source code else you can reach us at

      If you have any further questions or concerns, please let me know. I’m here to help!


  3. L
    Layla Reis says:

    Hi, Akshay! I believe that the increase in @ $ _ SESSION [‘clicks’] + = 1 when I click the button to move to the next question is not working. Would you help me?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.