Thursday, July 1, 2010

11:33 PM
I’m a huge fan of WordPress’ method of individual article deletion. You click the delete link, the menu item animates red, and the item disappears. Here’s how to achieve that functionality with jQuery JavaScript.

The PHP – Content & Header

The following snippet goes at the top of the page:

    $query = 'DELETE FROM my_table WHERE item_id = '.(int)$_GET['delete'];
    $result = mysql_query($query,$link);

The following is used to display the records:

$query = 'SELECT * FROM my_table ORDER BY title ASC';
$result = mysql_query($query,$link);
while($row = mysql_fetch_assoc($result))
    echo '<div class="record" id="record-',$row['item_id'],'">
                <a href="?delete=%27,$row[%27item_id%27],%27" class="delete">Delete</a>

The jQuery JavaScript

$(document).ready(function() {
    $('a.delete').click(function(e) {
        var parent = $(this).parent();
            type: 'get',
            url: 'jquery-record-delete.php',
            data: 'ajax=1&delete=' + parent.attr('id').replace('record-',''),
            beforeSend: function() {
            success: function() {
                parent.slideUp(300,function() {

For every link, we add a click event that triggers the AJAX request. During the request, we transition the containing element to a red background. When the AJAX request returns a “success” response, we slide the element off of the screen.