Ajax Jquery: Delete data from db using ajax.
index.php
function deleteRow(rowID) {
if (confirm('Are you sure??')) {
$.ajax({
url: 'ajax.php',
method: 'POST',
dataType: 'text',
data: {
key: 'deleteRow',
rowID: rowID
}, success: function (response) {
$("#country_"+rowID).parent().remove();
alert(response);
}
});
}
}
ajax.php
if ($_POST['key'] == 'deleteRow') {
$conn->query("DELETE FROM country WHERE id='$rowID'");
exit('The Row Has Been Deleted!');
}