php - 如何禁用该复选框并使用 php 更新数据库

Question

如何禁用该复选框并使用 php 更新数据库？我的意思是，如果值为 1，则选中该复选框并在数据库中更新，但如果我取消选中该复选框，我希望数据库中的该复选框更新为 0。

$watered = $row['water'];
$i =$watered;
$check = $i == 1 ? 'checked' : '';


<input type="checkbox"  name="check" value = "$watered" <?php echo $check;?> OnClick="doAction(<?php echo $id;?>);" > </td>

函数 doAction 谁不重要，文件也不见了:

  if (isset($_GET['id'])) {

        $id = $_GET['id'];
        $query = mysql_query("update plants set watered = 1 where id = $id ");
        if ($query){
            echo "you have watered the plants.";
        }else {
            echo "you cannot watered the plants";
        }
    }else{
        echo "vvvvvvvvv";
}

Answer 1

试试这个

$check = $row['water'] == 1 ? 'checked' : '';

<input type="checkbox"  name="check" value = "<?php echo  $row['water']; ?>" <?php echo $check;?> OnClick="doAction(<?php echo $id;?>);" > </td>

还有

if (isset($_GET['id'])) {

  $id = mysql_real_escape_string($_GET['id']); //some security...
  $check = mysql_real_escape_string($_GET['check']); //some security...
        $query = mysql_query("update plants set watered = ".$check." where id = ".$id);
        if ($query){
            echo "you have watered the plants.";
        }else {
            echo "you cannot watered the plants";
        }
    }else{
        echo "vvvvvvvvv";
}

抱歉，很难理解您的代码...请使用 PDO 或 mysqli 完成所有操作，mysql_* 函数已已弃用。有效吗？