Radio Group Databind

Techissue2008

I have a radio group:

<input type="RADIO" value="1" name="subject" checked>English
<input type="RADIO" value="2" name="subject">History
<input type="RADIO" value="3" name="subject">Maths

DB table - subject
subjectid subject
1 English
2 History
3 Maths

I have an Edit page to update the subject info.

How to do data bind with the edit page? If I input '3' for the subjectid previously, how can it show Maths to be checked in edit page?

<input type="RADIO" value="1" name="subject">English
<input type="RADIO" value="2" name="subject">History
<input type="RADIO" value="3" name="subject" checked>Maths

numerical25

once you submit the form. It will only pick the one that was clicked on

you just got to retrieve it by using the $_GET['name'] varible in the edit page.

then you can jus throw it in a mysql query

SELECT * FROM subject where id = '{$_GET['name']}'

bradgrafelman

<input type="radio" value="1" name="subject" <?php print ($_POST['subject'] == 1 ? 'checked="checked"' : '') ?>>English
<input type="radio" value="2" name="subject" <?php print ($_POST['subject'] == 2 ? 'checked="checked"' : '') ?>>History
...

Techissue2008

DB table - subject
subjectid subject
1 English
2 History
3 Maths
4 Econ
5 Geog
6 AMaths
7 Phy
8 Chem
9 Bio

Sorry, I think I asked the wrong question.
The radio group / drop down menu is dynamic as it can increase the numbers of subject.

I want to have a databind for both radio group and drop down menu.

Are there any tutorials?

Thanks for help.

bradgrafelman

Techissue2008 wrote:
Are there any tutorials?

I'm sure there's some out there, just search for "php dynamic dropdown" or something, but the concept is very simple:

// execute query to get list of subjects, SELECT'ing subjectid and subject, then:

$sid = (isset($_POST['subject']) ? $_POST['subject'] : '');

while($row = mysql_fetch_assoc($query))
    echo '<input type="radio" name="subject" value="' . $row['subjectid']
	   . '"' . ($sid == $row['subjectid'] ? 'checked="checked"' : '') . '>'
	   . $row['subject'] . "<br>\n";

Dropdowns are similar; output the <select> tag, then loop through the database to echo out each <option> tag, and then echo out the closing </select> tag.

Techissue2008

Dear Sir

If i want to do it in row, do I need to use the same method?

Here is my post in database forum:
http://phpbuilder.com/board/showthread.php?t=10356967

Thanks for help

Techissue2008

$query = "select subjectid, subject from subject ";
$result = mysql_query($query) or die('Error : ' . mysql_error());
$sid = (isset($_POST['subject']) ? $_POST['subject'] : '');

while($row = mysql_fetch_row($result))
{
echo '<input type="radio" name="subject" value="' . $row['subjectid']
. '"' . ($sid == $row['subjectid'] ? 'checked="checked"' : '') . '>'
. $row['subject'] . "<br>\n"; 
}

It only shows 3 radio buttons vertically, the last radio button was checked, and there are no labels for those 3 radio buttons.

bradgrafelman

Well it displays vertically because I added the <br> tag at the end of the echo(); you can modify the HTML so it displays however you want it to.

As for the missing text, try doing a [man]print_r/man on the $row array - what does it show?

Techissue2008

<?php 
$query = "select subjectid, subject from subject ";
$result = mysql_query($query) or die('Error : ' . mysql_error());
$sid = (isset($_POST['subject']) ? $_POST['subject'] : '');
while($row = mysql_fetch_assoc($result))
{
echo '<input type="radio" name="subject" value="' . $row['subjectid']
. '"' . ($sid == $row['subjectid'] ? 'checked="checked"' : '') . '>'
. $row['subject'] . "<br>\n"; 
}
?>

It can show the radio group. But, it does not show corresponding checked value.