How to use a radio button with php

[fjm]

Hi everyone,

Can somebody please tell me or maybe show me an example of how to use multiple radio buttons in php?

I have a form with 1 textbox and 4 radio buttons. What I want to do is have a user, type in a search string and then check a radio button that will cooraspond to a field in a database. The problem I am having is that the input name must be the same for all of the radio buttons to ensure that only one button is checked. All four buttons must have the same name to be in the same group within the html.

If I make all of the names the same, then how do I differentiate between one POST value and another? I was thinking that maybe from the html button's value but I can't get php to see it.

Can someone please provide a sample or the direction I need to go in?

Thanks,

Frank

[bergy]

How you tell is in the value of the variable (also set in the value attribute of the input tag). Look at the radio buttons below:
[html]
<input type="radio" name="radio" value="radio" />
<input type="radio" name="radio" value="radio2" />
<input type="radio" name="radio" value="radio3" />
[/html]
[php]echo $_POST['radio'];[/php]
If the first radio button was checked the code above would output "radio", if the second was checked the very same code would output "radio2" and if the third was checked the very same code would output "radio3".

So basically, one variable 3 different possible values for that variable depending what which radio button you've checked.

[bergy]

I assume you could just set the value of the radio buttons to correspond with the column name of your table so...

[html]
<input type="text" name="textBox" />
<input type="radio" name="updateFie ld" value="name" />
<input type="radio" name="updateFie ld" value="address" />
<input type="radio" name="updateFie ld" value="phoneNum ber" />
[/html]

[php]
$column = $_POST['updateField'];
$value = $_POST['textBox'];
mysql_query("up date myTable set ".$column." = `".$value."`;") ;
[/php]

[fjm]

How you tell is in the value of the variable (also set in the value attribute of the input tag). Look at the radio buttons below:
[html]
<input type="radio" name="radio" value="radio" />
<input type="radio" name="radio" value="radio2" />
<input type="radio" name="radio" value="radio3" />
[/html]
[php]echo $_POST['radio'];[/php]
If the first radio button was checked the code above would output "radio", if the second was checked the very same code would output "radio2" and if the third was checked the very same code would output "radio3".

So basically, one variable 3 different possible values for that variable depending what which radio button you've checked.

Bergy,

Thank you very much for the explanation. I am going to try and see if I can get it working with what you gave me.

I have exactly what you have as far as all of the name values being the same and a different value assigned to each button but I can't get it to work. I'm sure this problem has much to do with my lack of php experience.


Thanks,

Frank

[fjm]

I assume you could just set the value of the radio buttons to correspond with the column name of your table so...

[html]
<input type="text" name="textBox" />
<input type="radio" name="updateFie ld" value="name" />
<input type="radio" name="updateFie ld" value="address" />
<input type="radio" name="updateFie ld" value="phoneNum ber" />
[/html]

[php]
$column = $_POST['updateField'];
$value = $_POST['textBox'];
mysql_query("up date myTable set ".$column." = `".$value."`;") ;
[/php]

Hey Bergy,

That is exactly what I have done. Each value coorasponds to a field in my db.

Let me ask you this Bergy, if you wanted to SELECT a different column that would cooraspond to a different radio button in your example, how would you write your sql. Maybe that is where I am getting hung up.

I have 4 buttons relating to a vehicle search. make, model, vin and license_Plate

Each button has its own value such as

<input type="radio" name="vehicle" value="plate" />License Plate

the way I am doing it now is writing 4 different sql statements such as

SELECT * FROM vehicle where license_Plate = $_POST[vehicle]
SELECT * FROM vehicle where vin = $_POST[vehicle]

My issue is that I think I need to use an if conditional to find the correct sql code. I can only do that with its value. I'm sorry if I am not clear.

Frank

[bergy]

I just tested it to make sure and it does in fact work for me. When trying to figure out minor stuff like this, I like to just do a print_r(_POST); which will print everything posted from the form. Copy and paste the following code into a PHP file and you should get someting like [updateField] => name if you check the first radio button.

[php]
<form id="form1" name="form1" method="post" action="">
<input type="text" name="textBox" />
<input type="radio" name="updateFie ld" value="name" />
<input type="radio" name="updateFie ld" value="address" />
<input type="radio" name="updateFie ld" value="phoneNum ber" />
<input type="submit" name="button" id="button" value="Submit" />
</form>
<pre>
<?php
print_r($_POST) ;
?>
</pre>
[/php]

[fjm]

I just tested it to make sure and it does in fact work for me. When trying to figure out minor stuff like this, I like to just do a print_r(_POST); which will print everything posted from the form. Copy and paste the following code into a PHP file and you should get someting like [updateField] => name if you check the first radio button.

[php]
<form id="form1" name="form1" method="post" action="">
<input type="text" name="textBox" />
<input type="radio" name="updateFie ld" value="name" />
<input type="radio" name="updateFie ld" value="address" />
<input type="radio" name="updateFie ld" value="phoneNum ber" />
<input type="submit" name="button" id="button" value="Submit" />
</form>
<pre>
<?php
print_r($_POST) ;
?>
</pre>
[/php]

Thanks for sticking with me Bergy. I have already used print_r($POST);

My output is the key which is vehicle and the value which is whatever button was pressed which is correct.

( [search] => [vehicle] => plate

[bergy]

The value in <input type="radio" value="somethin g"> should be the exact name of your column. So if your column's name is license_Plate you need to make it "license_Pl ate" not "plate" - this way you won't need any if statements.

I think your SQL is incorrect it shouldn't be:
SELECT * FROM vehicle where license_Plate = $_POST[vehicle]

But rather:
SELECT * FROM vehicle where $_POST['vehicle'] = 'searchTerm'

(edit - clarification) This way, if the radio button for license plate is checked, $_POST['vehicle'] = license_Plate and that is the column used in your SQL query. Here is the PHP i would use:

[php]
mysql_query("SE LECT * from vehicle where ".$_POST['vehicle']." like 'searchTerm'");
[/php]
I assume searchTerm would be replaced with the value from the textbox? So, $_POST['textBoxName']?

[fjm]

[php] if(isset($_POST['vehicle'])){
if($_POST['plate']){
echo "plate";
}elseif($_POST['vin']){
echo "vin";

}else{
echo "none";
}
}[/php]

Here is the php

[fjm]

The value in <input type="radio" value="somethin g"> should be the exact name of your column. So if your column's name is license_Plate you need to make it "license_Pl ate" not "plate" - this way you won't need any if statements.

I'm a bit confused Bergy. Sorry.. Ok, I can change my radio button values to exactly match the column names in the db. thats cool. But I am not following you on the sql. I have never seen sql written the way you are showing me. :)

SELECT * FROM vehicle where $_POST['vehicle'] = 'searchTerm'

the way I am reading this, the post global will output "vehicle" and the rest will follow.

vehicle = search_term??

I was looking to use the post global to match the column name in the db. Of course, if I can use the value, thats great too but I'm sorry, I don't quite understand how to do that with your example.

Ok, here is what I have in my html. I have 1 textbox and 4 radio buttons. I want to use the html to complete the sql statements.

So... If the user enters 2ERQ267 in the textbox for a license plate and then checks the license plate button, *I was thinking* to have an if conditional check to see if the license_Plate button was checked. If so, execute that sql. Else if html button VIN was checked, execute the VIN sql.

edit:

I have 4 different columns that I want to search on and 1 textbox to input the information into.