Jump to content

Question Writer Manual/Frequently Asked Questions/MySQL

From Wikibooks, open books for an open world
Can I Import questions from or Save results to a MySQL database?

You can't import data directly into Question Writer from a database. However you can export from the database to the Text Import Format and import these files into Question Writer.

If you're using the 'results by e-mail' service, in addition to sending you the results by e-mail, we also store all of your results for you in a database. Once you're logged into this service, you can also download the results and responses as a excel file. See the Chapter on Save and Publish for more details on this.

If this functionality doesn't suit your needs, you can have the quiz send the results and responses to your own server using the Custom Results Server - however you may need a programmer to help process the results into your own database.


To help with this, we have made available a small PHP application that allows you to have results from your Question Writer quizzes written to your own MySQL database.

You can download it here [1]

It comes with installation instructions, but you'll need to be able to set up a database and upload some files to your webserver. It stores the data it receives in two tables - one table for the quiz results, and one table that stores the responses to the individual questions. Once the data is in your database, you'll need to decide what to do with it. We have kept it fairly basic - you won't need anything more than MySQL 4+ and PHP 5+ and you might well get away with less.