How do I delete a MySQL record using Ajax and Jquery?

Question

I'm not sure how to get the post title into the jquery .ajax call. I am able to create and display my blog posts, now I'm trying to add functionality to delete and edit. I'm starting with delete since it's obviously the easier of the two. How do I get the blog title from the post array into my functions.js file so that I can delete the matching record in my Database? Also... Thanks!

HTML

 <?php
        include 'scripts/db_connect.php';
        include 'scripts/functions.php';
        sec_session_start();
        $sql = "SELECT * FROM blog";
        $result = mysqli_query($mysqli, $sql);
        while($row = mysqli_fetch_array($result))
        {
            echo'<div class="blog"><h3 class="blog">' . $row['Title'] . "</h3><h3>" . $row['Date'] . "</h3><h3>" . $row['Tag'] . "</h3><hr>";
            echo'<p class="blog">' . $row['Body'] . '</p><button id="editPost" type="button">Edit</button><button id="deletePost" type="button">Delete</button><button id="commentPost" type="button">Comment</button></div>';
        }

?>

Functions.php

$function= $_POST['function']; 
$title = $_POST['title'];
if($function == "deletePost")
 deletePost($title)
 function deletePost($title){
$sql = "DELETE FROM blog WHERE Title = '$title';";
mysqli_query($mysqli, $sql);
}

Functions.js

$(document).ready(function(){
    $('#deletePost').on('click', function(){
        $.ajax({
            url: 'functions.php',
            data:{function: "deletePost", title: "how do I get the blog title here"}
            success: function(data){
         //confirmation of deletion
        }
        });
    });
});

techfoobar · Accepted Answer · 2013-11-27 02:44:51Z

1

Since you are expecting a POST request, you'll need to specify that while making the AJAX request.

$.ajax({
    url: 'functions.php',
    type: 'POST', // specify request method as POST
    ...
});

That should do it.

answered Nov 27, 2013 at 2:44

techfoobar

66.8k14 gold badges117 silver badges138 bronze badges

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

2 Comments

CodeManiak Over a year ago

So if I use type: 'POST' then I can grab the same variables that I used on the previous php page?

techfoobar Over a year ago

When you use POST, you will be able to access all POST parameters passed to your PHP script by the AJAX request.

Vishal · Accepted Answer · 2013-11-27 07:10:46Z

Try This

<?php
            include 'scripts/db_connect.php';
            include 'scripts/functions.php';
            sec_session_start();
            $sql = "SELECT * FROM blog";
            $result = mysqli_query($mysqli, $sql);
            while($row = mysqli_fetch_array($result))
            {
                echo'<div class="blog"><h3 class="blog">' . $row['Title'] . "</h3><h3>" . $row['Date'] . "</h3><h3>" . $row['Tag'] . "</h3><hr>";
                echo'<p class="blog">' . $row['Body'] . '</p><button id="editPost" type="button">Edit</button><a class="deletePost" rel="'. $row['Title'] .'" href="#" >Delete</a><button id="commentPost" type="button">Comment</button></div>';
            }

?>

$(document).ready(function(){
    $(".deletePost").on('click', function(){
        $.ajax({
            url: 'functions.php',
            type: 'POST',
            data:{function: "deletePost", title: $(this).attr('rel')}
            success: function(data){
         //confirmation of deletion
        }
        });
    });
});

Collectives™ on Stack Overflow

How do I delete a MySQL record using Ajax and Jquery?

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