How to make a JavaScript function that will delete table rows from a MySQL database

Question

As the title says, I was wondering if there is any way to create a function in JavaScript that will delete a row from a table? Maybe by calling some PHP to delete a row in the table?

Start with reading a book about it. Cures the wondering disease. ;) — hakre
– hakre, Commented Mar 6, 2012 at 12:15
A little hint: You'll find both parts answered on this site. So if you split the question and search for each part you'll find useful stuff. — hakre
– hakre, Commented Mar 6, 2012 at 12:16

hsz · Accepted Answer · 2012-03-06 12:17:19Z

3

For example if you have a table with a few columns, add a new column with some delete me button:

<tr rel="34">
  <td>34</td>
  <td>Joe</td>
  <td><a class="deleteRow" href="#">delete me</a></td>
</tr>

Then in jQuery for example add a click event to .deleteRow class:

$('.deleteRow').click(function(){
  var parent = $(this).parent('tr');
  var rowId  = parent.attr('rel');
  $.ajax({
    type: 'post',
    url: "delete.php",
    data: {id:rowId},
    success: function(){
      parent.remove();
    }
  });
});

And in delete.php script:

if ( $_SERVER['REQUEST_METHOD'] == 'POST' ) {
  $id = (int) $_POST['id'];
  // make sql query to remove element with given id
}

answered Mar 6, 2012 at 12:17

hsz

153k63 gold badges268 silver badges320 bronze badges

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

2 Comments

jose Over a year ago

And if jQuery is an option :)

hsz Over a year ago

If so - it was the quickest way to explain it for me. If it is not available, then OP should implement it by his own. ;-)

user1199657 · Accepted Answer · 2012-03-06 12:16:09Z

1

I think the only way to call a php function from javascript is by making an ajax call. Since javascript is client side and php is server side so there is no other way to do so.

answered Mar 6, 2012 at 12:16

user1199657

Collectives™ on Stack Overflow

How to make a JavaScript function that will delete table rows from a MySQL database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related