Check answer in database

@NoEffinWayFeb 27.2012 — #Here, this assumes a few things;

1.You are using a session variable to track what user is answering.

2.You have a database for questions in the following format:
[CODE]id|question|answer|choices[/CODE]
3.It assumes these are multiple choice questions

If those things are true, the following code should be plug and play.

[code=php]<?
 if(!isset($_COOKIE['question'])){
 $expire=time()+60*60*24;
 //Use this to track what question they are on.
 setcookie('question', 1, $expire);
 }elseif(isset($_SESSION['user'])){
 //Find out what question they are on.
 $qid = $_COOKIE['question'];
 if(isset($_POST['submit'])){
 $user_answer = $_POST['answer'];
 //Simple Sanitation to prevent any modified cookies being passed.
 $clean_id = mysql_real_escape_string($_COOKIE['question']);
 //Query the Database to get the question
 $find_question = mysql_query("SELECT * FROM $db.$questions WHERE id = '$clean_id'");
 $question_details = mysql_fetch_array($find_question);
 $answer = $question_details['answer'];
 if($user_answer == $answer){
 $result = 'Correct!';
 $user = $_SESSION['user'];
 $find_user = mysql_query("SELECT * FROM $db.$users WHERE username = '$user'");
 $user_array = mysql_fetch_array($find_user);
 $current_points = $user_array['points'];
 $current_points++;
 $update_points = mysql_query("UPDATE $db.$users SET points = $current_points");
 //This is for testing reasons ONLY
 if(!$update_points){
 $error = 'Could not update points: '.mysql_error();
 }
 }else{
 $result = 'Incorrect!';
 }
 $_COOKIE['question']++;
 }
 $get_question = mysql_query("SELECT * FROM $db.$questions WHERE id = ");
 //This build the question list
 $form = '<form action="?" method="post"><table>';
 if(isset($result)){
 $form .= '<tr><td>'.$response.'</td></tr>';
 }
 $form .= '<tr><td>'.$get_question['question'].'</td></tr>';
 $muli = explode('|',$get_question['choices']);
 $end = count($multi);
 $start = 0;
 while($start<=$end){
 $form .= '<tr><td><input type="radio" name="answer" value="'.$start.'">'.$multi[$start].'</td></tr>';
 $start++;
 }
 $form .= '<tr><td><input type="submit" name="submit" value="Submit" /></td></tr></table></form>';
 }
 ?>
 
 <html><head></head>
 <body>
 <?=$form;?>
 </body>
 </html>[/code]

Check answer in database

3 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Check answer in database

3 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

3 Comments(s) _↴

Also in #PHP _↴