PHP checkbox提交数据库增改方法

新增:
<input name="state" type="checkbox" id="checkbox" value="3" />

<?
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
...............
$state=$_POST['state'];
if($state=="")
{
 $state=0;
}
............
$conn->execute("INSERT INTO [Products] (Title,Key,state) VALUES ('$Title','$Key','$state')");
echo "<script>alert('添加成功！');location='ADDProducts.php';</script>";
}
?>

修改:
<input name="state" type="checkbox" id="checkbox"  value="<? echo $rs->Fields(state)->value; ?>"<? if ($rs->Fields(state)->value==3 ){?>  checked="checked" <? }?> />

<?
..............
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$id=$_POST['id'];
$Title=$_POST['Title'];
$Title2=$_POST['Title2'];
$state=$_POST['state'];
if($state=="")
{
 $state=0;
}
else
{
 $state=3;
}
...........
$rsUPDATE=new COM("adodb.recordset");
$rsUPDATE->open("UPDATE [Products] SET Title = '$Title',state = '$state',Key = '$Key' where [ID]=".$id,$conn,1,1);

echo "<script type='text/javascript'>alert('更改成功！');window.location.href='Products_Manage.php';</script>";
}
?>