Checkbox help

lee-bartlett

Ok in my database i have 2 collums, free and paid, when the check box is ticked i would like it to display a experession like '1' but it doesnt ticked or un ticked it only displays '0' can anyone help me with that please

        <td>Free or Paid:</td>
      <td>
	  <label>Free
        <input type="checkbox" name="type" id="free" value="free">
        </label>
        <label >Paid
        <input type="checkbox" name="type" id="paid" value="paid">
        </label>

  </td>
</tr>
<tr>
  <td>&nbsp;</td>
  <td><label for="button"></label>
  <input type="submit" name="button" id="button" value="Submit">
  <label for="button2"></label>
  <input type="reset" name="button2" id="button2" value="Reset">       
  <label for="sub"></label></td>
</tr>
  </table>
</form>

<?php

$sql="INSERT INTO tblbasicform (name, email, buissnes_name, location, freeyes, paidyes)
VALUES
('$_POST[name]','$_POST[email]','$_POST[buissnes_name]','$_POST[location]','$_POST[freeyes]','$_POST[paidyes]')";

if (!mysql_query($sql,$connect))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

this is some of the code i use atm

lee-bartlett

i tried that and no such luck 🙁 anyone ?

 
if (isset($_POST['type'])){
   $r = $_POST['type'];
}


if ($r == "freeyes"){
   $sql = "INSERT INTO tblbasicform ('freeyes') VALUES ('$r')";
}
else {
   $sql = "INSERT INTO tblbasicform ('paidyes') VALUES ('$r')";
}


mysql_query($sql);

ReadyF

I think if you have to chose between paid or free you should use radio group instead of checkbox !!!

try this code

HTML :

<input type="radio" name="type" value="paid"  /> Paid
    <br />
<input type="radio" name="type" value="free"  /> Free

PHP :

$type = $_POST['type'];

if($type == "paid"){
	$sql = "INSERT INTO tblbasicform (freeyes) VALUES ('$r')";

}elseif($type =="free"){
	$sql = "INSERT INTO tblbasicform ('paidyes') VALUES ('$r')";

}else{
exit;
}

lee-bartlett

In my database tho, which is in phpmyadmin, the collum either freeyes, or paidyes is still empty, and i cant see any result being put into there. if i fill in a text feild i can see it in there but the radio buttons i cant. What i would like to achive, is when the i choose a button, say a 1 goes into my DB for yes or 0 for no. In each collum, so if they select paid, it would go 0 (freeyes collum) and 1 in paid collum

lee-bartlett

The ini on the webpage is giving me this

Notice: Undefined variable: paidyes in C:\xampp\htdocs\Website\form.php on line 68
1 record added

this is the same for all varibles