How to delete records from DB using $_POST method

[eluser]Cristian Gilè[/eluser]
HTML does not directly support such a feature. You need javascript. Try something like this:

delete link in the view:

Code:

<a href="#" class="delete" value="&lt;?=$record-&gt;id?&gt;">delete</a>

javascript code:

Code:

$(document).ready(function()
{
      $(".delete").live('click', function(e)
      {
        e.preventDefault();

        var record_id = $(this).attr('value');

        $.ajax({  
             type: "POST",  
             url: "<?php echo site_url('location/delete');?>",  
             data: "delete="+ record_id,
             dataType: 'json',  
             success: function(res){  
                  var obj = eval(res);
                  alert(obj.message);
             }
         });  
      });    
});

In your controller, after a successful delete operation, return a json var like this:

in your controller: (location/delete)

Code:

function delete()
{
     if(empty($_POST))
     {
        //redirect if no var was post
     }
    
     if($id = $this->input->post('delete'))
     {
         //if delete was successful
         $data['message'] = 'Record '.$id.' was deleted successfully';
         //else
         $data['message'] = 'An error occurred during the delete operation';

         echo json_encode($data)
     }

     ....
     ....
}

Cristian Gilè