[RESOLVED] Inserting check box answer into database

snoopgreen

Hello everyone

i was hoping someone could help / advise me on how to go about inserting a check box answer into a database

Ive got a form which has yes no check boxes on
code below:

<td>Programme Spec Regs: </td>
<td width="75">Yes:
<input type="checkbox" name="spec" value="1"> </td>
<td colspan="3">No:
<input type="checkbox" name="spec" value="1"></td>

And my Insert statement is below:
query1 = "INSERT INTO programme " . "
(programme.prog_spec_regs)" . "
VALUES ( '$spec')";

my field prog_spec_regs is of type enum ('Yes', 'No') im using phpMyAdmin for my database
at mo im only getting the answer yes all the time
I just dont understand how 2 field names can go into 1 database field?

any help would be greatly appreciated
thanks
snoopgreen

snoopgreen

ive jsut realised ive got check boxes instead of radio buttons
so im off to change that then i will have another bash

dotnotwhat

You shouldn't have two checkboxes with same name, in same form. You have two checkboxes in your HTML, 1 for yes and 1 for no. Surely you just want a single checkbox that means 'yes' when checked and 'no' when left blank?

Presuming you remove the duplicate checkbox, so you have a single checkbox called 'spec', when the form is submitted, if 'spec' was checked, you will have a POST / GET variable called 'spec' (e.g. $POST['spec']). I can't remember what the contents of this var will be, but it doesn't matter. If the checkbox was not checked, the $POST['spec'] (or $_GET['spec']) will NOT be set.

So, you just need to determine if the $POST / $GET 'spec' variable exists after form is submitted. If yes, set your enum column to 'Yes', if no, set your enum column to 'No'.

Does this make sense?

snoopgreen

hello

i have now changed the check boxes to radio buttons
so only one of the buttons can be pressed

so me code is

  <td width="75">Yes: 
  <input name="radiobutton" type="radio" value="1"> </td>
  <td colspan="3">No: 
  <input name="radiobutton" type="radio" value="0"></td>

and me insert code is

$query1 = "INSERT INTO programme " . "
(programme.prog_spec_regs)" . "
VALUES ( '$radiobutton')";

This still isnt working
do you have to do something like
Values ('$radiobutton1 or $radiobutton')

thanks for help
snoopgreen

dotnotwhat

Your HTML looks ok now, but you can make things a little easier by using values of Yes and No for the radiobuttons (as you have already used Yes and No as an enum in your table).

So...

<td width="75">Yes: <input name="radiobutton" type="radio" value="Yes"> </td>
<td colspan="3">No: <input name="radiobutton" type="radio" value="No"></td>

Now, when form is submitted, the POST / GET var called 'radiobutton' (might want to call this something more descriptive) should contain either 'Yes' or 'No'.

So you can use this:-

// Get form result. Use $_GET if you use form method GET.
$form_result = $_POST['radiobutton'];

// Validate input. Should be 'Yes' or 'No' - anything else is bad.
if ($form_result != "Yes" && $form_result != "No")
{
    die("Invalid answer!");
}

// Make SQL query.
$query = "INSERT INTO programme (programme.prog_spec_regs) VALUES ('$form_result')";

// Perform query, etc....

Hope this helps...

snoopgreen

yeah thanks for help

i ve been able to get it working

thanks again for time and help
apprecaited
snoopgreen