checkboxes in form

[skullJ]

hello,

im trying to find some checkboxes help in form but i think my quetion is very specially!

Here iam...this is my form's file that i wana see the checkbox as checked and my value when is checked as "on"(when is unchecked value will be "off").

(in this "musictable" i have add the id as increasment)
[code]if($submit)
{
$music= $_POST['music'];

$result = mysql_query("INSERT INTO musictable (music)
                       VALUES ('$music')",$connect);
}else{
    $music_value="on";
$music_check="checked";

      Enable music:<input type="checkbox" name="music" value="<?php echo $music_value ?>" checked="<?php echo $music_check ?>"><br>
  } [/code]


And here it is my edit form's file:

[code]if($submit)
  { $music= $_POST['music'];

$result = mysql_query("UPDATE musictable SET music='$music'
WHERE id='$id' ",$connect);

}
elseif($id)
{
$result = mysql_query("SELECT * FROM musictable WHERE id='$id' ",$connect);
while($myrow = mysql_fetch_assoc($result))
             {               if($myrow['music']=="on"){
$music_value="on";
$music_check="checked";
   }else{
$music_value="off";
$music_check="0";
   }

Enable music:<input type="checkbox" name="music" value="<?php echo $music_value ?>" checked="<?php echo $music_check ?>"><br>
}[/code]

Actually i wana use the iclude "form.php" when this input display thats why i use '$music_value' and '$music_check'.

Thank you! :)

[gerkintrigg]

no no no... in your second file, you're saying checked = $music_check. what you need to do is end the echo statement first, then add the if satement to check whether the box is checked and if it is, then echo the word "checked".

so change: [code]Enable music:<input type="checkbox" name="music" value="<?php echo $music_value ?>" checked="<?php echo $music_check ?>"><br>[/code]to[code]echo 'Enable music:<input type="checkbox" name="music" value="'.$music_value.'"';
if ($music_check=="checked){
echo 'checked';
echo'><br>[/code]

[obsidian]

actually, checked does nothing in PHP. that's a javascript command. if you're wanting to see if a checkbox has been checked in a form submission, you have to check it with isset(). then, to keep the box checked, you've got to check if it is isset again:
[code]
<?php
if (isset($_POST['myCheck'])) {
  echo "You checked the box!\n";
}
?>

<form name="test" action="" method="post">
<input type="checkbox" name="myCheck" value="1" <?php echo isset($_POST['myCheck']) ? 'checked="checked" ' : ''; ?>/> Check me!<br />
<input type="submit" name="submit" value="Submit" />
</form>
[/code]

[gerkintrigg]

sorry... you're right. My mistake.

[skullJ]

hmmm...so the edit part of mine first post should be looks like:

[code]if($submit)
  { $music= $_POST['music'];

$result = mysql_query("UPDATE musictable SET music='$music'
WHERE id='$id' ",$connect);

}
elseif($id)
{
$result = mysql_query("SELECT * FROM musictable WHERE id='$id' ",$connect);
while($myrow = mysql_fetch_assoc($result))
             {             

if(isset($_POST['nonhtml'])) 
$music = $myrow['music'];

Enable music:<input type="checkbox" name="music" value="on" <?php isset($_POST['music'] ? 'checked="checked" ':' '?>/><br>
}[/code]

Am I right?

And i have a second quetion...what kind of values can be in 'music'!I can use "on" and "off" or simply "1"?

Thank u!

[skullJ]

*bump*

[redarrow]

so how does he display the checkbox has been checked with a session then cheers.

[code]
<?php
if (isset($_POST['myCheck'])) {
  echo "You checked the box!\n";
}
?>

<form name="test" action="" method="post">
<input type="checkbox" name="myCheck" value="1" <?php echo isset($_POST['myCheck']) ? 'checked="checked" ' : ''; ?>/> Check me!<br />
<input type="submit" name="submit" value="Submit" />
</form>
[/code]

[skullJ]

sory i cant understand! :(

can someone write the right code? :-\