Multi Delete using checkbox

Question

I am learning Cakephp and I've been trying to delete multiple (checked) record using checkbox, but still not success. here's my jQuery :

            var ids = [];
  $(':checkbox:checked').each(function(index){
   ids[index] = $(this).val();;
   alert(ids[index]);

  });

  //alert(ids);
  var formData = $(this).parents('form').serialize();


  $.ajax({
         type: "POST",
         url: "tickets/multi_delete",
         data:"id="+ids,
         success: function() {
     alert('Record has been delete');
    },
    error:  function(XMLHttpRequest, textStatus, errorThrown) {
       alert(XMLHttpRequest);
       alert(textStatus);
       alert(errorThrown); 
             }
   });

and here is code in controller :

function multi_delete() {
  $delrec=$_GET['id'];
  //debuger::dump($del_rec);
  foreach ($delrec as $id) {

   $sql="DELETE FROM tickets where id=".$id;

   $this->Ticket->query($sql);
  }; 


 }

anybody will help me please. thank

Answer 1

you could try a .join(',') on the array of IDs and then an explode() on the server side to get the array of IDs passed to the script.

e.g.

var idStr = ids.join(','); 

pass it (idStr) to the ajax call

$.ajax({
     type: "POST",
     url: "tickets/multi_delete",
     data: {id:idStr},
    //more code cont.

on the server side:

$ids = explode(',',$_POST['ids']);

OR

check the jquery.param() function in the jquery docs. Apply and to the IDS array and then pass it to $.ajax({});

Note: You are using POST and not GET HTTP METHOD in the code you provided

Answer 2

use json encode and decode for serialized data transfer