Create Android Quiz App with MySQL JSON Parsing and PHP

I have been testing my programming skills recently. So I was trying to study android by creating some simple applications by using Android studio. So, In this post i will share the code for creating an android quiz app. with this app, the user can select one answer from the four options available. The score of the quiz is also displayed at the end of the quiz.

Requirements for Creating Android Quiz app

• Computer with Android studio Installed
• Basic Knowledge about Android studio
• MySQL database (if you dont have a MySQL database, click here to learn more about free MySQL database)

About the Application

First of all. I will tell you what we are trying to achieve to give a basic idea about what we are about to create. In the Home screen you can see a button called start quiz. Now you will be redirected to a screen with a question and four options. user can select one option from the group and click submit. Now it will show the right answer in Green color text. Then, user can click next to go to next question. After completing the quiz, The score is displayed.

Setting up MySQL server for  Android app

First, we have to setup MySQL database for storing questions and answers. Open phpmyadmin and create a database. Inside the database, create a table called quiz_questions with 4 fields. The details of the fields inside the table are given below.

Enter some data to the table by using phpmyadmin. ID will be auto incremented. In the possible_answers field, Enter the options seperated by comma. In the correct answer field, enter which is the correct answer. if the third option is the correct answer, Enter the correct_answer field as 3.
Now copy the below code and paste in a notepad file. change the host, user,password and database name and save it as quiz.php .

Now upload this file to the root of your MySQL server by using file manager in your cpanel or by using FTP. Now try accessing the file by using,
http://yoursiteurl.com/quiz.php. If it is showing the data of your table successfully. Save the Url as we need it in future. Proceed with the below steps.

How to create Android quiz app

update (15/09/2017) : The apache http library is depreciated. So you have to add this compile statement in your App level build.gradle file(under dependencies)

• First of all. create a new project in Android Studio. Enter all the details. Select Blank activity, On next screen click finish
• In the activity_main.xml, paste the below code.

In the MainActivity.java, Paste the below code

Now create a new activity by right clicking on App and select New>>Activity>>Blank Activity
Name it as QuizActivity. In the activity_quiz.xml, paste below code



In the QuizActivity.java, Paste below code

In line number 185, you can see a space for a url. Paste the url for the MySQL server you created earlier. it will be like http://yoursite.com/quiz.php
Now Create another activitylike above and name it as complete
Paste the below code in activity_complete.xml


Now in the complete.java, Paste the below code


Now, Open strings.xml from res>>values>>strings.xml
Inside resources tag, paste the below code


Thats all. Now try to run the application. Hoorah..  Thats it.
if you face any errors feel free to comment below. I will try to reply as soon as possible.

Author : admin

Share this

Related Posts