I am developing a quiz site. I am done with DB but need advice on how to design the php part (LOL).
The db design looks like:
1 table for quiz name (eg math)
1 table to questions ( foreign key to quiz table)
1 table for available answers to each questions. (1 question usually has 4-5 multiple choice options or fill in option)
What I am trying to achieve is when the student enters a given quiz I would like to serve 1 question + all possible choices per page then the student clicks on next and I serve the next question with all possible choices. (I hope this makes sense)
Should I use session to store all questions at start and then itterate via js or should I query each consecutive questions following the next button or any other advices are welcome.