Small problem with radio button input

os2al

I have a simple problem involving my html form and mysql input.
Radio buttons from my form don't seem to put anything into the database when they are selected.
I'm sure the solution to this is quite simple but it escapes me.

Something like this code from my form I figure would put in a 1 into the database when selected:

But instead I get only zeros as nulls. Perhaps someone can point out what I'm doing wrong. The button is to choose "Age," of course, and the database field name is Age. The field has a size of one and is tinyint(1).

I've tried a number of things but can't get anything into the database from the form. Can somyone help me here?

nnichols

You need to post the code that you are trying to use to input the data into the db.

website

I would recommend keeping value as 0 and 1 if the field in the database is integer. then you can just send it streight instead of needing to convert it first.

K0ma

OK,

I am a little confused but if you have a form with a radio group
that has ranges like Age 8-12,13-17,18-21 then you can set an index in your database like 1,2,3 1=8-12, 2=13-17, 3=18-21. Then when a user chooses a radio button it will send a 1,2 or 3.

Ex.
<input type="radio" value="1">Age 8-12<br>
<input type="radio" value="2">Age 13-17<br>
<input type="radio" value="3">Age 18-21<br>

If you want the persons exact age I would make a list box with a range and then send that value to your database.

Ex.
<select name="select" size="1">
<option value="10">10 yr.</option>
<option value="11">11 yr.</option>
</select>

I hope this helps.

K0ma

os2al

I appreciate the help.

But I don't seem to be making things clear, at least from the responses, although I do understand what is being offered.

Let's say I have three fields in the database, Age, Business, Child. (There are 15 or so more choices but this should be enough for our purposes.) I figure each button would enter something into a corresponding field in the database when checked or selected, a "1" or a "0". Let's say they click on the Age button. The button is checked. They might also click on another one, say, Child, and that is checked. But the Business button is not selected or checked.

As I said above, the field Age in the database is tinyint(1). As are the others, Business and Child. From the choices made above by the user, I figure in the field Age in the database there would be a "1", in Business a "0" and in Child a "1." Is this not so from this html code here?

<input type="radio" value="Age" name="Age">Age<br>
<input type="radio" value="Business" name="Business">Business<br>
<input type="radio" value="Child" name="Child">Child<br>

[etc. with more radio buttons for the other choices]

</td>

That is what I'm trying to accomplish. But I get only zeros whether the buttons are checked or not.

run_GMoney

Here's what I would guess your problem is. I'm by no means an expert, though. I think when you submit items to a database from a form, like a radio button, it wants to submit whatever is in the value field, correct? So there may be some kind of "Type Mismatch" going on or something. You may need some kind of "If" statement in there to get what you need. Something that checks to see if the radio button is checked and if so, insert 1 into the database. Is that sort of what you're looking for?

sissy

Hi os2al,

I think i know what you want if the radio button is checked then it adds a 1 to the DB else it adds a 0 to it correct?

heres there code

<?php

$_POST['radiobutton'] ? $check = 1 : $check = 0;

$query = mysql_query("INSERT INTO table (age) VALUES ('$check')");
$row = mysql_fetch_array($query)

?>
<form name="form1" method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
  <input type="radio" name="radiobutton" <?php echo $row['age'] == 1 ? 'checked' : ''; ?>>
  <input type="submit" name="submit" value="Submit">
</form>

This will also show you when reading the form back if its checked or not.

hope this is what you were after

website

Hmm, I must say that you are on the wrong track. Radio are used when you have many possibilities but only ONE is allowed, as Koma said it is used for example if you have something like age and then you check the age you are, but not both, all radio buttons in that example have the same name, but different value.

What you are looking for I think is checkboxes. Here is the W3 definition...

checkboxes
Checkboxes (and radio buttons) are on/off switches that may be toggled by the user. A switch is "on" when the control element's checked attribute is set. When a form is submitted, only "on" checkbox controls can become successful.
http://www.w3.org/TR/html4/interact/forms.html#checkbox

Example:

<form action = "<? echo($_SERVER['PHP_SELF']); ?>" method="post">
Age: <input type="checkbox" name="age" /><br />
Buisness: <input type="checkbox" name="buisness" /><br />
Child: <input type="checkbox" name="child" /><br />
input type="submit" name="submit" value="submit" />
</form>

Then when you click submit you would execute a script something like this

<?
$submit = $_POST['submit'];
if ($submit == "submit") {
	$age = $_POST['age'];
	$buisness = $_POST['buisness'];
	$child = $_POST['child'];

$query = "UPDATE(INSERT INTO) table_name SET buisness = '" . 
	$buisness . "', age = '" . 
	$age . "', child = '" .
	$child . "'";
mysql_query($query);
?>

If I am not very much mistaken the checkboxes output a boolean value.
If so, then this script should work.

Hope that helps.

os2al

I think out of all of these I'll get the answer. The last posts, probably because I explained a bit more, I think will solve my problem. I appreciate the fact that someone explained about radio buttons versus checkboxes, because they were checkboxes before I changed them to radio -- not that I could get the checkboxes to work either, but that info helps a lot.
But with the code here I will give these suggestions a try and I believe I can get a solution that works from them. Thanks so much. I much appreciate you taking the time to help me out.