Checkbox value

[fernandodonster]

How to insert checkbox values to mysql using php ? could u help me? 🆒

[schwim]

<input type="checkbox" name="demo" <?php if($demo == "1"){echo " CHECKED";}?>>

On submittal:

$demo = $_POST['demo'];

mysql_query("UPDATE table SET demo = '$demo'") or die("Cannot query the database.<br><br>" . mysql_error());

I think that would work for you.

thanks,
json

[Savahn]

schwim code is correct however if you wish to uncheck the box and update mysql you will need to test to see if $_POST['demo'] is null since an unchecked checkbox does not pass anything thru POST or GET.

if(is_null($_POST['demo'] {
$demo = FALSE // or $demo = 0
}
else {
$demo = TRUE // or $demo =1
}
mysql_query("UPDATE table SET demo = " . $demo . ") or die("Cannot update the database.<br>" . mysql_error());

[NogDog]

A trick you can use to always get a value for each checkbox is to insert a hidden field with the same name for the "unchecked" value, placing it before the checkbox field so that the latter will override it when checked:

<input type="hidden" name="check1" value="0">
<label><input type="checkbox" name="check1" value="1">Check This</label>

[fernandodonster]

thanks

[schwim]

NogDog wrote:

A trick you can use to always get a value for each checkbox is to insert a hidden field with the same name for the "unchecked" value, placing it before the checkbox field so that the latter will override it when checked:

<input type="hidden" name="check1" value="0">
<label><input type="checkbox" name="check1" value="1">Check This</label>

very, very cool.. Thanks for sharing that one!

thanks,
json