Help with coding, it's for work

[Quintin]

I need urgent help.

See what I'm working on is a webiste for the students of the collage that i work on.

Now, I need to store 100+ exams in a database, with questions and answers, the student writes the exam online, mostly true & fals questions, then a b c or d questions.

After the students has written theyr exams, theyr resaults should display.

Someone maybe has an idea how i should do it?

Please help would be aprisiated.



I thought of a few stuff, but i'd prefer the database to be very compact, now i just want to know how you guys think i must do it.

[GumSlone]

are the answers for exam questions in multiple choise form?

because if they are not then youll need a human to check if the answer is correct.

i would use a different tables for questions and the possible answers, and you should take a look at some other existing online exam forms, how they were done.

[rukiya]

Both for true false and a b c d multiple choice question input correct answer in the database then check student's answer comparing with the database. publish the match result. Use radio button for choosing only one correct answer and checkbox for choosing multiple correct ansers in html form.

database table is like this

CREATE TABLE `answers` (
  `questionid` int(10) NOT NULL PRIMARY KEY,
  `answer` char(1) NOT NULL default '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 

[GumSlone]

`questionid` int(10) NOT NULL PRIMARY KEY,

Bad idea to use a primary key, because a question id can have more answers and if you have the table like this you can have only one answer to every question id

i would create tables like this

questions:

id (integer primary key auto increment)
question (question text)

answers
id (integer primary key auto increment)
question_id (integer index)
answer (possible answer text)
correct (if answer is correct true else it should be false)
points (number of points to give/substract for correct/incorrect answer)

[rukiya]

Ok then

CREATE TABLE `answers` ( 
  `id` int(10) NOT NULL auto_increment PRIMARY KEY,
  `questionid` int(10) NOT NULL , 
  `answer` char(1) NOT NULL default '', 
) ENGINE=MyISAM   AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 

[GumSlone]

Ok then

CREATE TABLE `answers` ( 
  `id` int(10) NOT NULL auto_increment PRIMARY KEY,
  `questionid` int(10) NOT NULL , 
  `answer` char(1) NOT NULL default '', 
) ENGINE=MyISAM   AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 

and how will you know if the answer is correct?
you need to add additional row,
eg. correct = true or correct = false

[subzero]

Gum dont brofther to tech rukiya how to do things right lol he a noob bro:D

[GumSlone]

Gum dont brofther to tech rukiya how to do things right lol he a noob bro:D

we were all noobs

[subzero]

he going around thinks a big shot lol

Yeah we all where a leaner once but when it comes to newbies like him always thinks big

lol i also found a error with his sql but i keep to my self with this lol

[GumSlone]

he going around thinks a big shot lol

Yeah we all where a leaner once but when it comes to newbies like him always thinks big

lol i also found a error with his sql but i keep to my self with this lol

the answer char(1)?
ok it should be text or varchar(255)

[subzero]

Any over 100 it comes to auto text file in sql ;)

[rukiya]

and how will you know if the answer is correct?
you need to add additional row,
eg. correct = true or correct = false

Gumslone Its easy like this

INSERT INTO `answers` VALUES (1,1,'0');
INSERT INTO `answers` VALUES (2,2,'a');
INSERT INTO `answers` VALUES (3,2,'c');

I would insert the correct answers only in the table.

if its true false answe then for true value=1 and false=0
question 1
student answered true=1 but in the table its false=0

question 2
student answered a,d but in the table its a,c

Its really a easy sql thing.



And subzero I know what type of stupid coding you know, noob,you 1st learn how to write english correctly.

[rukiya]

the answer char(1)?
ok it should be text or varchar(255)

No its just char(1) I showed you example

[GumSlone]

Gumslone Its easy like this

INSERT INTO `answers` VALUES (1,1,'0');
INSERT INTO `answers` VALUES (2,2,'a');
INSERT INTO `answers` VALUES (3,2,'c');

I would insert the correct answers only in the table.

if its true false answe then for true value=1 and false=0
question 1
student answered true=1 but in the table its false=0

question 2
student answered a,d but in the table its a,c

Its really a easy sql thing.

ok if you would do this way its your choice, but i wouldnt do it like this

[Quintin]

are the answers for exam questions in multiple choise form?

because if they are not then youll need a human to check if the answer is correct.

i would use a different tables for questions and the possible answers, and you should take a look at some other existing online exam forms, how they were done.

Yes it is multiple choise form gums