php - 动态创建mysql select查询

Question

我的网站中有多个复选框:复选框1复选框2复选框 3 等

我想根据上面的复选框动态生成mysql查询。

i:e 如果第一个复选框被选中，那么查询应该是:

$mysql="Select * from mytable where colname=" . $checkbox1 .;

如果选中第一个和第二个复选框，则查询应为:

$mysql="Select * from mytable where colname=" . $checkbox1 ."AND colname=" . $checkbox2 ." ;

如果全部选择，那么它应该是:

$mysql="Select * from mytable where colname=" . $checkbox1 . "AND colname=" . $checkbox2 ."AND colname=" . $checkbox3 .  ;

有人可以帮忙吗:

Answer 1

您必须像下面这样更改表单，因为它采用多个值，应该将其作为数组发布

<form action="register.php" method="POST"> 
  <input type="checkbox" name="rating[]" value="5">5 Star 
  <input type="checkbox" name="rating[]" value="4">4 Star 
  <input type="checkbox" name="rating[]" value="3">3 Star 
  <input type="checkbox" name="rating[]" value="2">2 Star 
  <input type="checkbox" name="rating[]" value="1">Less than 2 Star 
</form>

然后在php中

  $where = '';
   if(isset($_POST['rating'])){
     $data = implode(',',$_POST['rating']); // beacuse your rating is only one column in db i think
     $where = "WHERE cloumn_name IN($data)";
   }
  $query = "SELECT * FROM your_table $where";