Getting checkbox value into mysql db

Anon

I'm a newbie. I'm trying to figure out how to check or uncheck a box and have it pass a value of yes or no to mysql database. I'm using the following to determine if box is already checked or not.

<pre>
Faxlist:</td><td><input type="checkbox" name="faxlist" value=<?php echo $faxlist ?> <?php if ($faxlist="YES") { echo "CHECKED"; } ?>></td></tr>

</pre>

thanks

Anon

You have a checkbox that looks like this:
<input type=checkbox name="faxlist" value="YES">

then on your form action page you should have somthing like this:

if(empty($faxlist)) {
$faxlist = "NO"
}

The empty function checks to see if the $faxlist function has been set, if it has, the value will be yes, if it hasn't the value will be st to no.

then you enter the value of $faxlist into the DB:
Insert into table_name values ('$faxlist');

Hope this helps.

Tim.

Anon

Take a look at this.
<pre>

<body>

<?php

$db = mysql_connect("server");

mysql_select_db("mydb",$db);

$count = mysql_query("SELECT COUNT(*) FROM members")
or exit();

if ($row = mysql_fetch_array ($count))
echo "<P>The list currently has " . $row[0] . " members.<BR> <br>";

if ($submit) {

// here if no member_id then adding else we're editing

if ($member_id) {

$sql = "UPDATE members SET first_name='$first_name',last_name='$last_name',address='$address',company='$company',faxlist='$faxlist',city='$city' WHERE member_id=$member_id";

} else {

$sql = "INSERT INTO members (first_name,last_name,address,company,faxlist,city) VALUES ('$first_name','$last_name','$address','$company','$faxlist','$city')";

}

// run SQL against the DB

$result = mysql_query($sql);

echo "Record updated/edited!<p>";

} elseif ($delete) {

// delete a record

$sql = "DELETE FROM members WHERE member_id=$member_id";	

$result = mysql_query($sql);

echo "$sql Record deleted!<p>";

} else {

// this part happens if we don't press submit

if (!$member_id) {

// print the list if there is not editing

$result = mysql_query("SELECT * FROM members ORDER BY last_name",$db);

while ($myrow = mysql_fetch_array($result)) {

  printf("<Table border=1 cellpadding=2><TR><TD width=150><a href=\"%s?member_id=%s\">%s %s</a> \n</td><td width=200>%s</td><td width=75>EDIT</td>", $PHP_SELF, $myrow["member_id"], $myrow["first_name"], $myrow["last_name"], $myrow["company"]);

printf("<a href=\"%s?member_id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["member_id"]);

}

<P>

<a href="<?php echo $PHP_SELF?>">ADD A RECORD</a>

<P>

<?php

if ($member_id) {

// editing so select a record

$sql = "SELECT * FROM members WHERE member_id=$member_id";

$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);

$member_id = $myrow["member_id"];

$first_name = $myrow["first_name"];

$last_name = $myrow["last_name"];

$address = $myrow["address"];

$city = $myrow["city"];

$company = $myrow["company"];

$faxlist = $myrow["faxlist"];

// print the member_id for editing



?>

<input type=hidden name="member_id" value="<?php echo $member_id ?>">

<?php

}

First:<input type="Text" name="first_name" value="<?php echo $first_name ?>"><br>

Last:<input type="Text" name="last_name" value="<?php echo $last_name ?>"><br>

Address:<input type="Text" name="address" value="<?php echo $address ?>"><br>

City:<input type="Text" name="city" value="<?php echo $city ?>"><br>

company:<input type="Text" name="company" value="<?php echo $company ?>"><br>

Faxlist:<input type="checkbox" name="faxlist[]" value=<?php echo $faxlist ?> <?php if ($faxlist="YES") { echo "CHECKED"; } ?>>

</form>
<?php if(isset($faxlist)){ $faxlist="YES";} else { $faxlist = "NO";} ?>

<?php

}

</body>

</pre>