php function call from on button click using jquery/ajax

Question

trying to call php function on button click to delete row from db which i'm looping... need to pass button tag id attribute to the function. cant get it work

$('button').click(
    function(){
        var id = $(this).attr('id');
        $.ajax({
            url: "ins.php",
            type: "POST",
            data: id,
            success: function(data){
            }
        });
    });

// html button in table to delete a row
<td><button id='.$i.' name="delete"><img src="delete.png"></button></td>

// ins.php
if (isset($_POST['delete'])){
    DB_delete($conn, $_POST['delete']); 
}

// function that deletes the row
function DB_delete($conn,$id){

    $sql = "DELETE FROM person WHERE id = ?";

    $stmt=$conn->prepare($sql);
    $stmt->bind_param('i',$id);
    $stmt->execute();
    $stmt->close();
}

skrilled · Accepted Answer · 2014-05-21 23:24:38Z

1

You're simply not passing the data correctly. Since you're looking for the $_POST['delete'], then you must submit it with that key/value.

$.ajax({
      url: "ins.php",
      type: "POST",
      data: {"delete": id},
      success: function(data){
      }
  });

answered May 21, 2014 at 23:24

skrilled

5,3712 gold badges28 silver badges49 bronze badges

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

Comments

pakalbekim · Accepted Answer · 2014-05-21 23:39:00Z

0

Your data parameter in ajax call is not right. Now it's just a plain number, but it should be an object in order to be treated as $_POST or $_GET (depending on the 'type' parameter) in your ins.php. So it should be like this:

$.ajax({
  url: "ins.php",
  type: "POST",
  data: {"delete": id},
  success: function(data){
  }
});

answered May 21, 2014 at 23:39

pakalbekim

1293 silver badges13 bronze badges

1 Comment

pakalbekim Over a year ago

What do you get, when you run var_dump($_POST['delete']) in your ins.php?

Collectives™ on Stack Overflow

php function call from on button click using jquery/ajax

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related