Inserting radiobutton value

hellyna

Does anyone know how to insert radiobutton value into database? i did the insert but the in the database, there is no value is stored.

Ludichrist

If you've posted it from a form, the value should be stored in a post variable like $_POST['radio'].

bpat1434

Did you assign a value to the radio button? If not, then it's just a boolean true or false.... and of course the above post is also correct...

Ludichrist

The value is assigned on the submitting form like this:

<input type="radio" name="radio" value="1" checked="checked" />
<input type="radio" name="radio" value="2" />
<input type="radio" name="radio" value="3" />

Houdini

If you could post the code for the form and also the code you have for your sql query it is quite possible that you could be helped but it seems that everyone is kinda shooting in the dark without seeing anything you have or have not done yet.

hellyna

My coding for form is (addform.php):

<form name="add" method="post" action="addprocess.php" id="signup" onSubmit="return checkform(this);">
<table width="452" border="1" align="right" cellpadding="4" cellspacing="3" bordercolor="#003093" id="table">
<tr>
<td class="labelfield">Payment:</td>
<td nowrap class="labelfield">
<input type="radio" name="types" value="1" checked>
Paid
<input type="radio" name="types" value="2">
None
</td>
</tr>
</table>
<input name="submit_rec" type="submit" class="button" id="submit_rec" value="Add New Record" >
<input type="submit" name="reset" value="Reset" class="button">
</form>

For (addprocess.php) is:

include "connection.inc";

if(isset($_POST['submit'])) {

$types = $_POST['types'];

$sql = "INSERT INTO records VALUES('$types')";
$results = mysql_query($sql);
if (!$results) {
echo "Unable to store data";
}

}

mysql_close();

I did this already, BUT still it didn't work. The radiobutton value didn't insert into database.
Anyone help me please...

bpat1434

Have you tried echoing the value of $types to see if it actually is what you expect?

P.s. There are BBCode tags for code, php, and HTML. It helps a lot when we look. They're easy to use:
[php] // Some PHP Code Here (can be mixed with HTML) [/php]
[html] <!-- Your HTML code here (only HTML, no PHP) [/html]
[code] Any code you want in here... any language!! [/code]
Just some tips....

Blulagoon

To add to what bpat1434 suggests, might be an idea to also echo out $sql, your SQL query to see if it really is trying to insert the value of $types into the database.

Blu