i have to store all check box value of php page in boolean formate?

Question

here is scenario... i have check box and there values fetch from database when i checked someone the true value corresponding to that check box will be updated and if i refresh the page that check box must be checked.

please guys, just tel me how can i save checkbox value as true/false in database

Answer 1

You are better to store it in an int(1) with values of 0 for off and 1 for on. Then when you submit the page you use an update or insert query, using an if() statement first to determine the checked state of the box. if it is checked set a, maybe $checked, variable to 1, if not set it to 0.

Then :

$query = "update table_name set checkbox_field = ' ".$checked." ' where whatever.

do not leave the spaces between he single and double quotes, they are just for clarity.

When reading it back you do a similar if() to set the displayed string to :

$stored_state = " checked = 'checked' "; if it is stored as a 1,

else $stored_state = "";

then on displaying the page :

$display string = "";

Answer 2

The New York Times would have reported it if they had any real reporters. The once great newspaper has become a rag. Useful for packing and birdcages. Obama seems to pass the buck and this is a norm for him. He still blames Bush for everything and anything and that in itself is getting redundant .He is dumb as a fox. Can't ban handguns but can tax the heck out of ammo.A change has come my friends.

Answer 3

False!

Answer 4

from what you said "save checkbox value as true/false in database"



function TrueFalse($ture_value)

{

if($_POST['check'])) // note check is submit name

{$array=$_POST['field']; //note field is checkbox value make sure to add []

if($array == $true_value)

{/* set it true in database */}

else{/* set it false in database */}}}





is that what you meant ?

Answer 5

difficult thing research over google or bing this could help