Radio Buttons + Insert Query

obrienkev

Hi all,
I have set up a quiz form. The user is given multiple answers to choose from. They make their selection using radio buttons.

How do I insert their selection as 'Yes' into the database??

// connect to db
include('db_connect.php');

// set vars
$question = $_POST['question'];
$answer = $_POST['answer'];
$correct = $_POST['correct'];

// 1) Perform Questions Query
$query = "INSERT INTO questions(question_text) ".
                  "VALUES('$question')";
//echo '<p>'.$query.'</p>';
$result = mssql_query($query) or die('Insert Query Error');

// 2) Perform Select Query - get most recent ID
$query2 = "SELECT question_ID ".
                    "FROM questions ".
                    "WHERE question_text = '$question'";
//echo '<p>'.$query2.'</p>';
$result2 = mssql_query($query2) or die('Select Query Error');

// 3) Loop through Select Query Results
while($row = mssql_fetch_array($result2))
{
             // 3a) Set ID Variable
           $question_ID = $row['question_ID'];

} // end while

// 4) Insert Answers
foreach($answer as $key => $value)
{
echo $key.'--'.$value;
         // 4a) Perform Insert Query - Insert Answers
         $query3 = "INSERT INTO answers(answer_text, question_ID, correct) ".
                            "VALUES('$value', '$question_ID', '$correct')";
         echo $query3;
         //$result3 = mssql_query($query3) or die('Insert Query Error');
} // end foreach

The form contains answers with relevant multiple radio buttons..
HTML:

<input type="text" name="answer[]" id="answer" value="" />
<input type="radio" name="correct" id="correct" value="" />

<input type="text" name="answer[]" id="answer" value="" />
<input type="radio" name="correct" id="correct" value="" />

saraadmin

can't you just use value="Yes" for your <input type="radio"> tags?

obrienkev

Yes. But all radio button values are then entered as Yes.

saraadmin

Hmm, I've got a feeling behaviour may vary from one browser to another.

Galeon (based on Gecko [Mozilla]) only includes the radio inputs (get or post) if they are checked. I don't have IE so I can't check.

Another possible way to do it may be to give each <input type="radio"> an identical name (which you already have) and a unique value attribute. That way $_POST["correct"] will be the value of the checked radio button.

qadeer_ahmad

Hi,
First i want to tell you behaviour of radio buttons when you use radio buttons and check one then array you get contain only one records which is check so you have to use a trick like this

$rad=$_REQUEST['rad'];
foreach($rad as $key => $value)
{
if($value!="")
{
echo $value;
}
}

form i use again this is:
<form action="radio.php" method="post" name="form">
<input name="rad[]" type="radio" value="ch_1">
<input name="rad[]" type="radio" value="ch_2">
<input name="rad[]" type="radio" value="ch_3" checked>

what i do here in form i just put diffrent values for a radio group don't forget to given radio name like rad[] and in php code i just check which value is comming as clicked so i know that if i got "ch_1" then first radio button is checked and so on. I hope it help you if not then tell me i make your code chages and send you will help you completely.
Thanks

Houdini

Radio buttons in a group all have the same name but different values or they wouldn't work. So lets just say that you named the first group of buttons q1, then the second group q2, q3... and so on. Thereis no need for the text box just a regular question then the group of buttons like so

Does your animal have fleas?<br />
<input type="radio" name="fleas" id="fleas" value="0" />My Dog has fleas<br />
<input type="radio" name="fleas" id="fleas" value="1" />My cat has them to<br />
<input type="radio" name="fleas" id="fleas" value="2" />Goldfish don't get fleas<br />
<input type="radio" name="fleas" id="fleas" value="3" />I don't have a pet<br />
Do you like caffinated drinks<br />
<input type="radio" name="caffine" id="caffine"value="0" />I love coffee<br />
<input type="radio" name="caffine" id="caffine"value="1" />I enjoy colas<br />
<input type="radio" name="caffine" id="caffine"value="2" />I like iced tea<br />
<input type="radio" name="caffine" id="caffine"value="3" />I am allergic to caffine<br />

Deoending on which radio button was selected you know what the answer was, and it doesn't matter what browser you use the action of a radio button is the same only one may be selected in that group with the same name.
instead of using numbers for the value in the case of fleas you could use value='dog', value='cat', value='fish' value='none' then $_POST['fleas'] if dog were selected would be dog.

obrienkev

Hey guys. Here's my code now...still not what I want

How do I mark the unselected radio buttons as 'No' value? At the moment all radio buttons are passed a 'Yes' value.

// set vars
$question = $_POST['question'];
$answer = $_POST['answer'];
$correct = $_POST['correct'];

// Check Radio Button Selection
if(isset($correct))
{
$correct = $_POST['correct']; // value set at 'Yes'
}else
{
$correct = "No";
}

echo '<h3>ans:'.$correct.'</h3>';

// 1) Perform Questions Query
$query = "INSERT INTO questions(question_text) ".
			 	 "VALUES('$question')";
//echo '<p>'.$query.'</p>';
$result = mssql_query($query) or die('Insert Query Error');

// 2) Perform Select Query - get most recent ID
$query2 = "SELECT question_ID ".
					"FROM questions ".
					"WHERE question_text = '$question'";
//echo '<p>'.$query2.'</p>';
$result2 = mssql_query($query2) or die('Select Query Error');

// 3) Loop through Select Query Results
while($row = mssql_fetch_array($result2))
{
 			// 3a) Set ID Variable
 		  $question_ID = $row['question_ID'];

} // end while

// 4) Insert Answers
foreach($answer as $key => $value)
{
echo $key.'--'.$value;
		 // 4a) Perform Insert Query - Insert Answers
		 $query3 = "INSERT INTO answers(answer_text, question_ID, correct) ".
			 	  		 "VALUES('$value', '$question_ID', '$correct')";
		 echo $query3;
		 $result3 = mssql_query($query3) or die('Insert Query Error');
} // end foreach

Radio Buttons:

<input type="radio" name="correct" id="correct" value="Yes" />
<input type="radio" name="correct" id="correct" value="Yes" />

Houdini

That will not work radio buttons (in a group share a single name) but a different value your code value wil be yes no matter what is selected in that named group of buttons, give each button a different value then the $POST['nameof group'] will equal the particular one that was selected.
Call this group 'fleas' just for example

Does your animal have fleas?<br />
<input type="radio" name="fleas" id="fleas" value="dog" />My Dog has fleas<br />
<input type="radio" name="fleas" id="fleas" value="cat" />My cat has them to<br />
<input type="radio" name="fleas" id="fleas" value="fish" />Goldfish don't get fleas<br />
<input type="radio" name="fleas" id="fleas" value="none" />I don't have a pet<br />

Now depending on which one was checked then $_POST['fleas'] with be either dog, cat, fish, or none.

obrienkev

But two out of three answers will be incorrect. I dont want the user to be able to view the correct one by simple using View Source.

Any ideas?

Houdini

How are they going to know which one is the correct answer in the form just by viewing the source, when the submit button is pressed whatever further process is going on will not be seen and there in the action='whatever.php' is where you would take the values and assign either a Yes to the checked box and No to the rest like this using a ternary'

<?php 
echo $_POST['fleas']."<br />";

echo ($_POST['fleas']=='dog'?'Yes':'No');
echo"<br />";
echo ($_POST['fleas']=='cat'?'Yes':'No');
echo"<br />";
echo ($_POST['fleas']=='fish'?'Yes':'No');
echo"<br />";
echo ($_POST['fleas']=='none'?'Yes':'No'); 
 ?>

qadeer_ahmad

Hi ,
see next

qadeer_ahmad

Hi ,
Save correct answer in database with uniqe id's when you got answer from the user against any question get correct answer from the database and compare it with user selected answer so you don't need to put answer in hidden fields but when you are displaying you radio button give value answer which one user selecting so you can handle it easily.
<input name="rad[]" type="radio" value="answer is this">
So which answer user select compare this answer with your database answer ofcourse thier is one true so you can handle easily.

adding some more if you have a fixed quiz like a surway then you don't need to save answer in database you know that which answer is okey so when you are get user reply just compare with correct answer on php page and no body can see correct answer.

obrienkev

Thanks for all the help.
Now I have decided to enter the answers into a database.

I want to create a web interface to allow an administrator to enter the multiple answers for a question and using a radio button to mark the correct one.

What would be the best way of doing this?

Thanks.