how to do a questionnaire result?

lucibalaj

Hello,

I want to build a simple Questionnaire: 10 questions with 3 possible answers(1, 2, or all may be true) for each question. When a user clicks submit I want him to have the results of the Questionnaire (something like, you have answered correctly at 3 questions: no2, no7, no9).
I want to implement this with PHP and MySQL, that is I want that the questions and the answers to be fed into the page from a MySQL database.

Can anybody help me? Thank you, Lucian.

FatalError

Well I'm not going to write you an entire script, but it's not that difficult of a script to write. Basically, all you need is a MySQL table for questions, and the correct answers to each. Then, you need another table with the answers the used put in. When he/she is done, compare the answers to the correct ones, count how many they got right, and echo the result. Not too hard.

lucibalaj

Hi,

Thanks for your fast reply.
Unfortunatelly I am not so profficient at PHP.
I've created a database like this:

id int(11) NOT NULL auto_increment,
question text NOT NULL, //the text of the question
answer_1 text, // the answer 1
answer_2 text, // the answer 2
answer_3 text, // the answer 3
right_value varchar(200) default NULL, //the right answer
picture varchar(200) default NULL, // a picture of the question
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

But I am stucked from here... can you further help me in this?
Thank you,
Lucian.

barand

The usual way is to have a form with 3 (in your case) radio buttons for the user to select their answer and these buttons would have a value of 1, 2 and 3. So in your table store the correct answer value as 1,2 or 3 not in a varchar(200) column. Although you may want tp store some explanatory text in the event the user gets it wrong.

You will also need a "response" table to store the users responses to the questionnaire.

response

responseid int not null auto_increment primary key,
userid int,
questionid int,
answer int //(1, 2 or 3)