checkbox value = 1 if checked?

[Gayner]

Private?: <input type="checkbox" name="private" />

 

now my php for update is

 

$private = $_POST['private'];

mysql_query("INSERT INTO `prays` (`title` ,`text` ,`private` ,`time`) VALUES (
'". mysql_real_escape_string($_POST['title']) ."',
'". mysql_real_escape_string($_POST['text']) ."',
'". mysql_real_escape_string($_POST['private']) ."',
'$time');");

 

 

 

and im getting:

 

when it insert to database if somone clicks on the checkbox it still 0

 

i need it to be value =1 if somone clicks

 

[Gayner]

ROFL ALL I HAD TO DO WAS ADD VALUE="1" LOL

 

But what if, they dont check it? how can i add it so it changes the value to whatever i want?

[mrMarcus]

what do you want the value to be if they don't check it?

[FaT3oYCG]

That isn't how checkbox's work.

 

Search into the isset(); function.

 

A simple google search returns this: http://www.homeandlearn.co.uk/php/php4p11.html

[Gayner]

what do you want the value to be if they don't check it?

 

4

[mrMarcus]

<?php
if (isset ($_POST['private']) || (!empty ($_POST['private'])))
{ $private = 1; }
else
{ $private = 4; }
?>

[Gayner]

<?php
if (isset ($_POST['private']) || (!empty ($_POST['private'])))
{ $private = 1; }
else
{ $private = 4; }
?>

 

ty sir