AJAX

Insert AJAX

$(document).ready(function(){
// Add Category
$('#addCategoryForm').on('submit', function(e){
e.preventDefault();
let name = $('#categoryName').val().trim();
if(!name){ Swal.fire('Warning','Enter category name!','warning'); return; }
$.ajax({
url: 'ajax/Add_Category.php',
type: 'POST',
data: {name:name},
dataType: 'json',
success: function(res){
if(res.status==='success'){
Swal.fire('Success', res.message, 'success').then(()=>{ location.reload(); });
} else {
Swal.fire('Error', res.message, 'error');
}
}, error: function(){ Swal.fire('Error','AJAX error occurred!','error'); } }); }); });

GET Data From Table AJAX

function editCategory(id) {
$.ajax({
url: 'ajax/Get_Category.php', // the backend script
type: 'POST', // HTTP method
data: {id: id}, // data to send
dataType: 'json', // expecting JSON response
success: function(res){
if(res.status === 'success'){
$('#editCategoryId').val(res.data.id);
$('#editCategoryName').val(res.data.name);
// Show modal
var editModal = new bootstrap.Modal(document.getElementById('editCategoryModal'));
editModal.show();
} else {
Swal.fire('Error', res.message, 'error');
}
},
error: function(){
Swal.fire('Error', 'AJAX error occurred!', 'error');
}
});
}

Edit Data From Table AJAX

$('#editCategoryForm').on('submit', function(e){
e.preventDefault();
let id = $('#editCategoryId').val();
let name = $('#editCategoryName').val().trim();
if(!name){
Swal.fire('Warning','Enter category name!','warning');
return;
}
$.ajax({
url: 'ajax/Update_Category.php', // backend file
type: 'POST',
data: {id: id, name: name},
dataType: 'json',
success: function(res){
if(res.status === 'success'){
Swal.fire('Success', res.message, 'success').then(()=>{
// Hide modal
var modalEl = document.getElementById('editCategoryModal');
var modal = bootstrap.Modal.getInstance(modalEl);
modal.hide();
location.reload();
});
} else {
Swal.fire('Error', res.message, 'error');
}
},
error: function(){
Swal.fire('Error', 'AJAX error occurred!', 'error');
}
});
});

Delete Data From Table AJAX

function deleteCategory(id) {
Swal.fire({
title: 'Are you sure?',
text: "You won't be able to revert this!",
icon: 'warning',
showCancelButton: true,
confirmButtonColor: '#3085d6',
cancelButtonColor: '#d33',
confirmButtonText: 'Yes, delete it!',
cancelButtonText: 'Cancel'
}).then((result) => {
if (result.isConfirmed) {
// AJAX call to delete
$.post('ajax/Delete_Category.php', {id: id}, function(res) {
if(res.status === 'success'){
Swal.fire(
'Deleted!',
res.message,
'success'
).then(() => {
location.reload();
});
} else {
Swal.fire('Error', res.message, 'error');
}
});
}
});
}