选择或取消选择复选框并在PHP中运行不同的查询 [英] Selecting or deselecting checkboxes and running different queries in PHP

问题描述

因此，我有多个复选框.我的目标是如果选中，则在MySQL中插入复选框值，如果未选中，则从MySQL中删除复选框值.除删除值外，一切正常. PHP不知道哪些复选框是未选中的".有什么主意吗?

So, I have multiple checkboxes. My goal is to insert checkbox value in MySQL if is checked, and to delete checkbox value from MySQL if is not checked. Everything works fine except deleting the value. PHP doesn't know which checkboxes are "unchecked". Any idea?

到目前为止，我有这个:

So far I have this:

if(isset($_POST['values']))
{
    foreach($_POST['values'] as $checked)
    {
        $query5 = ("
        INSERT INTO ecust_user_contract (fk_contract, fk_cust_user)
        VALUES ('".$checked."','".$username_u."')
        ");
        $result5 = mysqli_query($conn,$query5); 
    }
}
if(!isset($_POST['values']))
{
    foreach($_POST['values'] as $unchecked)
    {
        $query5 = ("
        INSERT INTO ecust_user_contract (fk_contract, fk_cust_user)
        VALUES ('".$unchecked."','".$username_u."')
        ");
        $result5 = mysqli_query($conn,$query5);
    }
}

推荐答案

假设您已使用POST方法提交表单，则可以执行以下操作:

Assuming that you have used POST method for form submission, you can do something like this:

html :

<input type="checkbox" name="values[]" value="val1">
<input type="checkbox" name="values[]" value="val2">
<input type="checkbox" name="values[]" value="val3">

php :

if(isset($_POST['values'])) {
 foreach($_POST['values'] as $checked){
 mysqli_query("insert into tablename(value) values($checked)");
  }
 }else{
 // use Delete query
  }

这篇关于选择或取消选择复选框并在PHP中运行不同的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！