Developer Snippet Diary

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!');
}
Posted by: R GONDAL
Email: rizikmw@gmail.com