How to delete a record from MySQL database using AJAX and PHP in Codeigniter

SholleyonlineJava

I want to delete records from a MySQL database table using AJAX. I have done it with PHP and work fine. But I've not been able to get it through with AJAX.

AJAX

$(document).ready(function() {
    $(".confirm").click(function() {
        var bid = $(this).closest("div.box2").find('input[name="dbid"]').val();
        var dataString = 'id=' + bid;
        $.ajax({
            type: "POST",
            url: "<?php echo site_url('user/delete_article')?>",
            data: dataString,
            cache: false,
            success: function() {

                $.alert('Confirmed!');
            }
        });
    });
});

PHP

public function delete_article($id){
  $data['success']='';
  $data['error']='';
  include_once ('query/user_query.php');  
  $this->db->where('bid', $id);
  $data['countEarticle'] = $this->db->count_all_results('blog');
  if($data['countEarticle'] >= 1){

      $this->db->where('bid',$id);
      $this->db->delete('blog');

  }
  if($data['countEarticle'] <= 0){

  }          
}

HTML

<div class="box-footer box-comments box2" style="display: block;">
    <input type="hidden" name="dbid" value="<?php echo $draftfull['bid']?>">
    <p>
        <btn class="btn btn-azure btn-sm confirm"><i class="fa fa-trash-o"></i>Delete Article</btn>
    </p>
</div>

I need your help. What am I doing wrong?

Parvej Alam

try this code:-

public function delete_article(){
    $id=$this->input->post('bid');
    $data['success']='';
    $data['error']='';
    include_once ('query/user_query.php');

    $this->db->where('bid', $id);
    $data['countEarticle'] = $this->db->count_all_results('blog');
    if($data['countEarticle'] >= 1){

        $this->db->where('bid',$id);
        $this->db->delete('blog');

    }
    if($data['countEarticle'] <= 0){

    }          
   }

Collected from the Internet

Please contact [email protected] to delete if infringement.