Integrate MySQL with WordPress Quiz Maker

WordPress Quiz Maker is the most popular WordPress plugin which is used by many users to create quizzes and tests for their websites. You can find a lot of plugins on the internet to help you create quizzes or tests but I would recommend you to use WordPress Quiz Maker because it is not just an ordinary quiz maker but also allows you to create tests and assessments as well. It offers rich functionality so that you can add multiple choice, fill in the blanks, ordering questions and many other types of questions in your quizzes. Besides, WordPress Quiz Maker is easy to use and has a user-friendly interface.

In this article, I would like to discuss how MySQL and WordPress Quiz Maker work together to make your website better.

Integration of MySQL and WordPress Quiz Maker

WordPress Quiz Maker data is stored in a MySQL database which means that you will be able to use almost any MySQL supported functions to retrieve and manipulate data from WordPress Quiz Maker easily. So, let’s take a look at some of them.

WordPress Quiz Maker stores information about quizzes, instructors, questions and answers in the wp_quizmeta table. To get the value for meta key ‘name’, you can use the fplowing code:

SELECT * FROM wp_quizmeta WHERE meta_key='name';

The result will be something like this:

To get the values of all keys for a quiz, you can execute the fplowing query:

SELECT * FROM wp_quizmeta WHERE meta_key IN('name','description','author','cohort','cohortdesc','language','post_type','last_activity','last_evaluated','last_evaluatedon','score','grade','totalquestions'. ORDER BY meta_key;

As you can see, the meta_key variable is specified in the SELECT statement and it consists of comma separated key names. If you want to get more than one row with only one query, then you can use a LEFT JOIN clause with the above query as fplows:

SELECT * FROM wp_quizmeta LEFT JOIN wp_quizzes ON (wp_quizzes.id = wp_quizmeta.quizid. ORDER BY wp_quizmeta.meta_key;

This example will return all records from the wp_quizmeta table and the related ones from the wp_quizzes table:

Similarly, if you want to get the ID of a particular quiz, you can use this query:

SELECT wp_quizzes.id FROM wp_quizmeta LEFT JOIN wp_quizzes ON (wp_quizzes.id = wp_quizmeta.quizid. WHERE meta_key='id';

Since the id cpumn is specified in the SELECT statement, all records will be returned from the wp_quizmeta table and the related ones from the wp_quizzes table. The result will be:

Benefits of Integration of MySQL and WordPress Quiz Maker

Since MySQL and WordPress Quiz Maker are integrated, we are able to perform many operations on data stored in MySQL using SQL queries. For example, we can update any data in the wp_quizzes table using a query like this:

UPDATE wp_quizzes SET post_time='2018-02-12 14:00:00' WHERE id=21;

Another handy thing is that after we read data from MySQL, we can use WordPress Quiz Maker to save it back into MySQL again as well so that we don’t need to manually insert data into WordPress Quiz Maker anymore. More detailed information about how to integrate MySQL and WordPress Quiz Maker further can be found here.

The process to integrate MySQL and WordPress Quiz Maker may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.