highlighted incorrect responses bases on PHP/MySQL results data

[webguync]

Hi, I want to make an alteration to a page that reports results of an online exam, and one column displays the incorrect responses. For example if someone missed questions 1, 5 and 10, this is recorded in a field in the MySQL named incorrect_resp. These results are then echoed out into the HTML page. What I want to do if possible is to code the exam question and answers on the page and using CSS hilight the incorrect responses in a yellow background or something like that. What I need to figure out is how to tie the two together. How can I set it up so it will display <td class="wrong"> for a wrong answer that is displayed in mySQL data?

 

let me know if I need to explain anything more or supply some code.

[mikesta707]

if (wrong($answer)){
$class = "wrong";
}

echo "<td class=\"$class\">";

 

?

[webguync]

so in replace of $answer It would be the name of my field for incorrect responses?

[mikesta707]

well you would have to have a function called wrong that detects if the answer is wrong or not. However you determine if the answer is wrong you would put in that if statement.

 

How do you determine when an answer is wrong?

[webguync]

this is actually done in the exam application, which uses Flash and XML. the responses are then submitted into the database.

[mikesta707]

ahhh ok. so in your database does it just have the answers, or does it have the answers, and which are wrong and which are right?

[webguync]

there is a field in the MySQL that displays specifically the wrong answers. Is is set to type text and is 1,5,10 etc.

[mikesta707]

ahh ok, So if you have an array of all the answers, you can iterate through that array to display the answers, and then have an array with all the wrong answers, and use the in_array() function to tell whether or not to highlight the text

[webguync]

would you or someone else be able to post an example code?

[mikesta707]

Oh ok sure.

 

$wrong = array(1, 4, 3, 10);//You will get this from your table, but for simplicities sake
$answers = array("16", "25", "88", etc. etc.);// again  you will get this from your table

//im assuming your answers array is numeric
foreach($answers as $key => $value){
     if (in_array($key, $wrong)){
          $class = "wrong";
     }
     else {
          $class="correct";//or whatever your right answer class is
     }

     echo "<td class=\"$class\">$value</a>";//or whatever you want to output.
}

 

this is a basic example. obviously yours will be different, but the basic logic is there

 

[webguync]

how would I convert the data from the table into an array in PHP?

[mikesta707]

the mysql_fetch_array and mysql_fetch_assoc functions can get the data from your mySQL resource and turn it into an array

 

fetch array: http://us.php.net/manual/en/function.mysql-fetch-array.php

fetch assoc: http://us2.php.net/mysql_fetch_assoc

 

 

[webguync]

I will look into that thanks.

[webguync]

Hi,

 

I am still trying to figure this out. I can pull out the MySQL data into an array using the following code.

 

<?php
ini_set("display_errors","1");
ERROR_REPORTING(E_ALL);
$con = mysql_connect("localhost","***","***") or die('Could not connect: ' . mysql_error());

mysql_select_db("****") or die(mysql_error());

$result = mysql_query("SELECT incorrect_resp FROM TableName");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    printf("Incorrect response %s", $row["incorrect_resp"]);
}

mysql_free_result($result);
?>

 

but then how do I get the results of the array to print out as such?

 

$wrong = array(1, 4, 3, 10);//You will get this from your table, but for simplicities sake
$answers = array("16", "25", "88", etc. etc.);// again  you will get this from your table

//im assuming your answers array is numeric
foreach($answers as $key => $value){
     if (in_array($key, $wrong)){
          $class = "wrong";
     }
     else {
          $class="correct";//or whatever your right answer class is
     }

     echo "<td class=\"$class\">$value</a>";//or whatever you want to output.
}