updating question???? help

cs7536 · Oct 30, 2003

I created an application to insert questions into a quiz, I then created a update/modify form so that I can update my questions rather than deleting them and recreating a new ones. This is so that I can keep the same ID's..

The correct andwers are entered into the DB by way of radio buttons..

question:
________________
| |
| |
| |
-----------------------

a. O
b. O
c. O
d. O none of the above

when I select a question for update, my update/modify script re-inserts the data back into the question textarea but it will not re-insert the selected radio option.

can someone render assistance on this one?

thanks

Nothing is hard when you realy want to learn it.

Max

dkdude · Oct 30, 2003

Hi cs7536,

... something like this, perhaps?!

Code:

<? $index = $_REQUEST['index']; $answer = $_REQUEST['answer']; $question[] = "Is PHP the best Server Side Scripting Language ever?"; $answer1[] = "Yes"; $answer2[] = "No"; $answer3[] = "Sometimes"; $answer4[] = "None of the above"; $question[] = "Is this cool or what?"; $answer1[] = "Yes"; $answer2[] = "No"; $answer3[] = "Not really"; $answer4[] = "None of the above"; function saveAnswer($questionNo, $answer) { echo "You selected answer <B>$answer</B><BR>"; echo "... to question no. <B>$questionNo</B>"; // Your DB handler goes here... } ?> <HTML> <HEAD> <TITLE>POP QUIZ</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#800080" ALINK="#FF0000"> <H1>POP QUIZ</H1> <? if(!$index) $index = 0; else saveAnswer(($index-1),$answer); ?> <BR><BR> <FORM ACTION="<? echo $PHP_SELF; ?>" METHOD="POST"> <TABLE BORDER="0" CELLPADDING="5"> <TR> <TD> <B>Question</B> </TD> <TD> <B>Your answer</B> </TD> </TR> <TR> <TD VALIGN="TOP"> <? echo $question[$index]; ?> </TD> <TD> <INPUT NAME="answer" TYPE="RADIO" VALUE="a"> <? echo $answer1[$index]; ?> <BR> <INPUT NAME="answer" TYPE="RADIO" VALUE="b"> <? echo $answer2[$index]; ?> <BR> <INPUT NAME="answer" TYPE="RADIO" VALUE="c"> <? echo $answer3[$index]; ?> <BR> <INPUT NAME="answer" TYPE="RADIO" VALUE="d"> <? echo $answer4[$index]; ?> <BR> </TD> </TR> </TABLE> <INPUT TYPE="hidden" NAME="index" VALUE="<? $index++; echo $index; ?>"> <INPUT TYPE="submit" VALUE="Next Question ..."> </FORM> </BODY> </HTML>

Good luck with your project §;O)

Jakob

cs7536 · Oct 30, 2003

Thanks jacob I will try to follow your instructions.

I've been having problems with making the info pop back up inside the radio buttons, partial because the radio buttons all have the same name, when I insert the data initialy the seleted radio is inserted into a single column in a table in the DB. so there is not a, b, c or d in the DB..

there is only one column name: answer. so when trying to retreive back to radio button for update being that they all have the same name it is not clear to me as to how answer finds the correct radio button. In return being that it reconizes all the radios the same it does not choose a radio at all..

My radio script currently looks like this:

<input type='radio' name='answer' value='<?php echo "answer", ?>

keep in mind that there is 4 duplicate lines of this.

The php is so that it will load the data back into the radio button.

Originally in the insert page value was value='a' and so on, but for updating value='a' was replaced with the PHP so that it would load the data there from the DB.

So how can it know to put it back there if all the radios share the same name, and how will it know what the new answer would be if I decided to change the answer? if the value is no longer a, b, c or d it is <?php

can you explain

Nothing is hard when you realy want to learn it.

Max

dkdude · Oct 30, 2003

Max,

I'm not sure what you're asking. However:

Radio-inputs with same name allows users to select only one of the inputs.

In my example, [/code]$question[/code] is an array. Just add more questions like I did it. [/code]$answer1[/code] thru [/code]$answer4[/code] are arrays too. They each contain one option to select.

When the first question has been answred, the result is stored in [/code]$answer[/code], so if you like, you can add that to your database table coloumn.

Please elaborate a bit... §;O)

Jakob

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

updating question???? help

cs7536

Programmer

dkdude

Programmer

cs7536

Programmer

dkdude

Programmer

Similar threads

Part and Inventory Search

Sponsor