Save Checkbox Value (1 or 0) With mySQL

[mcfly1204]

I have a form with several checkboxes that I would like to save a bit value in the corresponding column in mySQL. As far as the html is concerned, I have each checkboxs' value set to '1'. I have created variables to capture the POST value for each html field, and then I use that variable in a SQL insert statement.

if(isset($_POST['action']) && $_POST['action'] == 'submitform')
{
	$personalizedname = $_POST['personalizedname'];
	$personalizedaddress = $_POST['personalizedaddress'];
	$personalizedphone= $_POST['personalizedphone'];
	$mountain = $_POST['mountain'];
	$surfboards = $_POST['surfboards'];
	$bird = $_POST['bird'];
	$sailboats = $_POST['sailboats'];
	$beach = $_POST['beach'];
	$name = $_POST['Name'];
	$company = $_POST['Company'];
	$address1 = $_POST['address1'];
	$address2 = $_POST['address2'];
	$citystatezip = $_POST['citystatezip'];
	$phone = $_POST['phone'];
	$email = $_POST['email'];
	$comments = $_POST['comments'];
	//$type = $_POST['type'];
	$mailingbrochureoffer = $_POST['mailingbrochureoffer'];
	$emailoffer = $_POST['emailoffer'];
	$tradeshowoffer = $_POST['tradeshowoffer'];
	$otheroffer = $_POST['otheroffer'];
        $othertext = $_POST['othertext'];
	$couponcode = $_POST['couponcode'];
}

$insert_query = sprintf("INSERT INTO BagTags (personalizedname, personalizedaddress, personalizedphone, mountain, surfboards, bird, sailboats, beach, name, company, address1, address2, citystatezip, phone, email, asippaiupicid, comments, mailingbrochureoffer, emailoffer, tradeshowoffer, otheroffer, othertext, couponcode) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, 'CompanyA', %s, %s, %s, %s, %s, %s, %s)",
	sanitize($personalizedname, "text"),
	sanitize($personalizedaddress, "text"),
	sanitize($personalizedphone, "int"),
	$mountain,
	$surfboards,
	$bird,
	$sailboats,
	$beach,
	sanitize($name, "text"),
	sanitize($company, "text"),
	sanitize($address1, "text"),
	sanitize($address2, "text"),
	sanitize($citystatezip, "text"),
	sanitize($phone, "int"),
	sanitize($email, "text"),
	sanitize($comments, "text"),
	//sanitize($type, "text"),
	$mailingbrochureoffer,
	$emailoffer,
	$tradeshowoffer,
	$otheroffer,
	sanitize($othertext, "text"),
	$couponcode);

On the database side, the columns where the checkboxes will be saved are currently varchar(32) with a default value of '0'. I plan to change them back to a bit value once I have things working correctly. Currently, I receive a SQL error if any of the checkboxes are unchecked. If all of the checkboxes are checked, the value in the checkbox columns does not equal '1' as I would have expected.

[code green]

Unchecked check boxes are not set as a POST[] element.
So you need something like

if(isset($_POST['checkbox']) { 
 $var = 1; 
} else { 
 $var = 0;

You are blindly placing a lot of form data into a DB with no validation,
not only is this bad practice, but it leads to problems such as yours

[mcfly1204]

I realize now that there is no value returned for unchecked checkboxes. Thanks for the assumption in the last tip chief.

[s4mm77]

I might be missing some vital point here but...

$var = isset($_POST['checkbox']);

I mean, you wouldn't even need the whole $var, just surround it with isset()? It's what i've been doing ._.

[viirre]

IF you have an automated insert/update procedure, it's pretty easy to just output a hidden input with value = 0 right before the checkbox:
<input type="hidden" name="cb" value="0" />
<input type="checkbox" name="cb" value="1" />

Now you'll allways either get 0 or 1 from the POST