how to delete a row using javascript and php mysql

Question

I'm having a problem sending the id from javascript and send it to the php to delete the selected row. It seems

I am fine here since it is printing each row a delete button but unfortunately each time i click the delete button it is not deleting the row.

my javascript code is

$(document).ready(function(){

 function fetch_product_data()
 {
  $.ajax({
   url:"fetch.php",
   method:"POST",
   dataType:"json",
   success:function(data)
   {
    for(var count=0; count<data.length; count++)
    {
     var html_data = '<tr><td><button type="button" name="delete" class="btn btn-danger btn-xs delete" data-pk="'+data[count].id+'">Delete</button></td>';
     html_data += '<td data-name="productArea" class="productArea" data-type="text" data-pk="'+data[count].id+'">'+data[count].productArea+'</td>';
     html_data += '<td data-name="productLongName" class="productLongName" data-type="text" data-pk="'+data[count].id+'">'+data[count].productLongName+'</td>';
     html_data += '<td data-name="productShortName" class="productShortName" data-type="text" data-pk="'+data[count].id+'">'+data[count].productShortName+'</td>';
     html_data += '<td data-name="documentName" class="documentName" data-type="text" data-pk="'+data[count].id+'">'+data[count].documentName+'</td>';
     html_data += '<td data-name="docID" class="docID" data-type="text" data-pk="'+data[count].id+'">'+data[count].docID+'</td>';
     html_data += '<td data-name="author" class="author" data-type="text" data-pk="'+data[count].id+'">'+data[count].author+'</td>';
     html_data += '<td data-name="supportedFormat" class="supportedFormat" data-type="checklist" data-pk="'+data[count].id+'">'+data[count].supportedFormat+'</td>';
    html_data += '<td data-name="whereToFind" class="whereToFind" data-type="checklist" data-pk="'+data[count].id+'">'+data[count].whereToFind+'</td>';

     $('#product_data').append(html_data);
    }
   }
  })
 }

 fetch_product_data();

delete js. it is not deleting and not updating as well. I'm not sure if i passed the ID properly that's why it is not deleting after all.

   $(document).on('click', '.delete', function(){
   var id = $(this).attr("id");
   if(confirm("Are you sure you want to remove this?"))
   {
    $.ajax({
     url:"delete.php",
     method:"POST",
     data:{id:id},
     success:function(data){
      $('#alert_message').html('<div class="alert alert-success">'+data+'</div>');
      $('#product_data').destroy();
      fetch_data();
     }
    });
    setInterval(function(){
     $('#alert_message').html('');
    }, 5000);
   }
  });

the delete function is im not sure as well. delete.php

<?php
$connect = mysqli_connect("localhost", "root", "", "infodev");
if(isset($_POST["pk"]))
{
 $query = "DELETE FROM product WHERE id = '".$_POST["pk"]."'";
 if(mysqli_query($connect, $query))
 {
  echo 'Data Deleted';
 }
}
?>

Sebastien D · Accepted Answer · 2018-02-07 08:38:32Z

3

You are sending id from your Ajax call and retrieving $_POST["pk"] in your php function. That's an error. You should do:

<?php
$connect = mysqli_connect("localhost", "root", "", "infodev");
if(isset($_POST["id"]))
{
 $query = "DELETE FROM product WHERE id = '".$_POST["id"]."'";
 if(mysqli_query($connect, $query))
  {
  echo 'Data Deleted';
  }
}
?>

answered Feb 7, 2018 at 8:38

Sebastien D

4,5024 gold badges23 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Robert Over a year ago

i changed it $_POST["id"] but still not delating

Daniel E. Over a year ago

Are you sure you are posting the id ? check in your browser. I think the other bug is : data:{id:id} as in your html it's data-pk

Robert Over a year ago

I think so Daniel E that is why it is not passing but if I changed the data:{id:id} to data-pk it won't work @DanielE.

Sebastien D Over a year ago

Ad @DanielE. said : what does your console display when you call the Ajax? Is the id a correct value?

Robert Over a year ago

@SebastienD there's no error on my console log. Do i need to put also on the fetch.php? <?php //fetch.php $connect = mysqli_connect("localhost", "root", "", "infodev"); $query = "SELECT * FROM product"; $result = mysqli_query($connect, $query); $output = array(); while($row = mysqli_fetch_assoc($result)) { $output[] = $row; } echo json_encode($output); ?>

Rizwan · Accepted Answer · 2018-02-07 12:58:18Z

0

You Can also give id in url(ajax) like this try this

url: 'delete.php' +"/"+ id,

answered Feb 7, 2018 at 12:58

Rizwan

791 silver badge6 bronze badges

Collectives™ on Stack Overflow

how to delete a row using javascript and php mysql

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related