how to save checkbox value into mysql database using php

Question

hi i have a form which has a checkbox and i want to save the value of the checkbox into my database but when i click on the checkbox and save it it works fine and when i try to save the form without checking on the chekbox it shows undefined index can any one help me out

here is my html

<input type="checkbox" name="active" value="1"></input>

here is my php

$nactive  = $_POST["active"];

here is my save part

mysql_query("INSERT INTO `usermain`( `username`, `password`, level, active,`zimname`, zimmob, `email`, admin, makhtab)
            Values
                   ('$nuser', '$npwd', '$nlevel', '$nactive', '$nzname', '$nzmob', '$nemail', '0', '$makh')") or die(mysql_error());

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — TNK
– TNK, Commented Mar 11, 2013 at 15:02

mcryan · Accepted Answer · 2016-01-12 18:01:53Z

8

If the checkbox isn't checked, the browser won't actually send the data in your POST request. You'll need to check if the value is set, and then update your variable accordingly.

$inactive = isset($_POST["active"]) ? $_POST["active"] : 0;

edited Jan 12, 2016 at 18:01

answered Mar 11, 2013 at 14:55

mcryan

1,57610 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

UnholyRanger · Accepted Answer · 2013-03-11 14:56:02Z

3

If the checkbox is not checked, the value is not posted to the script. You must check if it is set before using it.

if(isset($_POST['active'])){
    //do something if is
}
else{
    //do something if not
}

answered Mar 11, 2013 at 14:56

UnholyRanger

1,97114 silver badges24 bronze badges

Comments

Chris · Accepted Answer · 2013-03-11 14:57:07Z

0

Use an isset control in the next page like this :

if (!isset($nactive)) $nactive = 0;

If your checkbox isn't checked, the value will be 0

answered Mar 11, 2013 at 14:57

Chris

1565 bronze badges

Collectives™ on Stack Overflow

how to save checkbox value into mysql database using php

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related