SQL复选框PHP表单


sql checkboxes php form

谁能帮帮我?我想做一个小的"系统",当我点击我的复选框一个SQL语句将被执行。例如这个语句:

SELECT * FROM Customers WHERE ID = 6;

如果有人能帮我,那就太好了。

我会用ajax

 <input type='checkbox' onclick'clicked();'>
javascript

+ Jquery

function clicked(){
  $.ajax({
     type: "GET",
     url: "phpfile.php",
     data:{checked:$("checkboxselector")[0].checked}
   })
}
PHP

//phpfile.php
 $checked = isset($_GET['checked']) && $_GET['checked'] == "true" ?1:0;
 if($checked){
    $query = "SELECT * FROM Customers WHERE ID = ''";
    // execute your query
 }