删除多行从数据库中复选框 [英] Deleting multiple rows from database by checkboxes

问题描述

我想通过复选框我有工作脚本检查所有来删除数据库中多行，但是当我想删除一个或两个，没有什么happend。

I want to delete multiple rows from database by checkboxes i have working script for "Check All" but when i want delete one or two , nothing happend.

的JavaScript

<script type="text/javascript">
jQuery(function($) {
    $("form input[id='check_all']").click(function() { // triggred check

        var inputs = $("form input[type='checkbox']"); // get the checkbox

        for(var i = 0; i < inputs.length; i++) { // count input tag in the form
            var type = inputs[i].getAttribute("type"); //  get the type attribute
                if(type == "checkbox") {
                    if(this.checked) {
                        inputs[i].checked = true; // checked
                    } else {
                        inputs[i].checked = false; // unchecked
                     }
                }
        }
    });

    $("form input[id='submit']").click(function() {  // triggred submit

        var count_checked = $("[name='data[]']:checked").length; // count the checked
        if(count_checked == 0) {
            alert("Please select a comment(s) to delete.");
            return false;
        }
        if(count_checked == 1) {
            return confirm("Are you sure you want to delete these comment?");
        } else {
            return confirm("Are you sure you want to delete these comments?");
          }
    });
}); 
</script>
<script type="text/javascript">

    $(document).ready(function(){
        $('.submit').click(function(){
            var checkValues = $('input[name=data[]]:checked').map(function()
            {
                return $(this).val();
            }).get();

            $.ajax({
                url: 'resources/ajax/ajax_delete_comment.php',
                type: 'post',
                data: { data: checkValues },
                success:function(data){

                }
            });
        });
    });

</script>

HTML / PHP

<form method="post" id="form">
Check All <input type="checkbox" id="check_all" value="">

Here im displaying record from database and <input name=\"data[]\" type=\"checkbox\" id=\"data\" value=" . $row['id'] . ">

<input name="submit" class="submit" type="submit" value="Delete" id="submit">
</form>

在删除SCRIPT

if(isset($_POST['data'])) {
    $id_array = $_POST['data']; // return array
    $id_count = count($_POST['data']); // count array

    for($i=0; $i < $id_count; $i++) {
        $id = $id_array[$i];
        $sql = $db->query("DELETE FROM comments WHERE `id` = '$id'");
        if ($sql)
            {
                echo "success";
            }
            else
            {
                echo "Failed to delete the comment.";
            }
    }}

所以其检查工作，而是当即时检查一个或两个对象，什么happend，也许有人可以帮助？

So its work for check all, but when im checking one or two objects, nothing happend, maybe someone could help?

推荐答案

Javascript的
由于您使用jQuery有更好的办法：）

Javascript
Since you are using jquery there is better way :)

<script type="text/javascript">
  var is_activate = true; // we will track which input button was clicked :)

  jQuery(function($) {
    $("#form input#check_all").change(function() {
      var inputs  = $("#form input[type='checkbox']");
      if ( $(this).is(":checked") ) {
        inputs.prop( "checked", true );
        // inputs.attr( "checked", true ); // if its not working
      }
      else {
        inputs.removeAttr( "checked" );
      }
    });

    // Track clicked button
    $("#form input[type=submit]").on("click",function(e) {
      is_activate = ( $(this).hasClass("activate_btn") ) ? true : false;
    });

    $("#form").submit(function(e) {
      e.preventDefault();
      var string  = ( is_activate ) ? 'activate' : 'delete';
      var data    = $(this).serialize();
      var checked = $(this).find("input[name='data[]']:checked").length;
      if ( checked == 0 ) {
        alert( "Please select a comment(s) to "+string+"." );
        return false;
      }
      var text  = "Are you sure you want to "+string+" these comment"+( ( checked == 1 ) ? "?" : "s?" );
      if ( confirm( text ) ) {
        $.ajax({
          url: 'resources/ajax/'+( ( is_activate ) ? 'ajax_activate_comment.php' : 'ajax_delete_comment.php' ),
          type: 'post',
          data: data,
          success: function( data ) {

          }
        });
      }
    });
}); 
</script>

HTML

<form method="post" id="form">
  <label>Check All</label>
  <input type="checkbox" id="check_all" value="">

  <label>Here im displaying record from database and</label>
  <input name="data[]" type="checkbox" id="data1" value="1">
  <input name="data[]" type="checkbox" id="data2" value="2">

  <!-- Activate Button -->
  <input class="activate_btn" type="submit" name="activate" value="Activate" id="submit">
  <!-- Delete Button -->
  <input class="delete_btn" type="submit" name="delete" value="Delete" id="submit">
</form>

PHP
一个查询就足够了：）

PHP
A single query is enough :)

<?php
  if ( isset( $_POST['data'] ) ) {
    $id_array = $_POST['data'];
    if ( !empty( $id_array ) ) {
      $id_array = implode( ",", $_POST['data'] ); // dont forget to sanitize
      $sql = $db->query( "DELETE FROM comments WHERE `id` IN (".$id_array.")" );
    }
  }
?>

请记住，它不是很好，这样做的所有的客户端。
你可以做 POST 请求到一个单一的文件，因为你的每个输入按钮都有唯一的名称。
因此，在你的 PHP code，你可以找到哪个按钮被点击了这个样子。

And remember, its not good that doing this all in client side.
You can do POST request to a single file, since your each input button has a unique name.
So in your PHP code, you can find which button was clicked like this.

<?php
  if ( isset( $_POST["activate"] ) ) {
    $sql  = $db->query( "UPDATE comments SET status = '1' WHERE `id` IN (".$id_array.")" );
  }
  else {
    $sql  = $db->query( "DELETE FROM comments WHERE `id` IN (".$id_array.")" );
  }
?>

看多么简单:)是吗？

look how simple :) Isn't it?

这篇关于删除多行从数据库中复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！