need help with checkboxes

kaos057

I am trying to make a form for a user profile where checkbox values are stored in a database, and then when the profile is updated the values are returned. The problem is I cant get the values to store in the database. All the rest of the stuff gets stored just not the checkbox. Here is the code I have been trying...

<?php

?><input type="checkbox" name="epic" value="<?php echo $myrow["epic"] ?>"

<?php

if ($myrow[epic] == "1") // IF THE CHECKBOX IS CHECKED 
{ 
    ?>checked="checked">
    <?
} 
else // IF THE CHECKBOX IS NOT CHECKED
{
    ?>>
    <?
}

I also have the field set as TINYINT. Is there a different way to do this or does anyone know what is wrong with the code?

raymie

You do not seem to have the code in your example for storing the value in the database but I suspect that your problems is related to the fact that checkbox fields are not returned when the checkbox is not selected.

Your code should probably check for the data item being set using the isset command when deciding what to populate in the database and if not set then set the value to zero.

planetsim

i wouldnt use isset for this.

Because a empty $_POST['value'] will be sent. Id use empty()

AS it would check for an empty feild.

raymie

I disagree.

If my memory serves the last time I checked a POST variable for an unchecked checkbox is NOT returned from a form.

kaos057

Thanks for the posts and all but I still never got an answer. How can I store a checkbox value in my database?

raymie

The same way you store any other variable, by taking the value (or lack thereof) and recording that in a database field.

As I mentioned initially you did not include your code for storing the other fields and so we cannot tell what is wrong with your current attempt at storing the field.

kaos057

Here is the code that processes the form:

if ($submit) {

$db = mysql_connect("localhost", "user", "password");

mysql_select_db("dbname",$db); 

$sql = "INSERT INTO profiles (id,user,name,lvl,race,class,aas,epic,vpkey,stkey,pov,hoh,cod,bot,magelo,email,screenshot,bio) VALUES ('','$user','$name','$lvl','$race','$class','$aas','$epic','$vpkey','$stkey','$pov','$hoh','$cod','$bot','$magelo','$email','$screenshot','$bio')";

$result = mysql_query($sql);

echo "<center>Thank you! Information updated.\n";

echo "<br><a href=welcome.php?user=$user>Back to Control Center</a>\n";

} else {

kaos057

Ok, I figured it out. In case anyone else has this problem do this:

if ($submit) {

$db = mysql_connect("localhost", "user", "password");

mysql_select_db("dbname",$db);

    if ($epic='checked')  {

        $epic = '1';

    }

$sql = "INSERT INTO dbname (epic) VALUES ('''$epic')";

$result = mysql_query($sql);

echo "<center>Thank you! Information updated.\n";

then for the visual part put:

<input type="checkbox" name="epic" value="<?php echo $myrow["epic"] ?>"

<?php

if ($myrow[epic] == "1") // IF THE CHECKBOX IS CHECKED

  { 

       ?>checked="checked"> <?

   }  else // IF THE CHECKBOX IS NOT CHECKED 

   { 

     ?>><? 

    }

kaos057

Disregard the last post. I thought it worked but it didn't. I did however find another method. It is so easy that it almost upsets me.

yep thats right only one line and it works great. In order for this to work you must have the field type as text.