php - 如何编辑带有复选框的表单并在数据库端反射(reflect)更改

Question

注:1为勾选，0为未勾选

<input type='checkbox' name='payed' value='".$row['payed']."' /> //checkbox on form

检查从表单接收的数据的代码片段

if (isset($_POST['payed'])) 
{
    $sug_query = "Update invoices SET payed = 1, WHERE id = $id"; 
    $db->exec($sug_query);
}

Answer 1

只需检查复选框的名称是否作为 POST 变量存在:

if (isset($_POST['checkbox_name'])) {
    //Checkbox was checked and you should update the column in question.
} else{
    //Checkbox unticked. Set column to 0.
}

或者，使用三元运算符:

$val = isset($_POST['checkbox_name']) ? 1 : 0;
$sug_query = "Update invoices SET payed = $val WHERE id = $id"; 
$db->exec($sug_query);