ajax php crud example

1<?php
2// Check if the form is submitted
3$personName = $_POST['personName'];
4$address = $_POST['address'];
5$mobile = $_POST['mobile'];
6$email = $_POST['email'];
7$message = $_POST['message'];
8$tdate=new DateTime();
9// form a sql query
10$sql = "INSERT INTO tbquery (name, email, mobile,address, comment, postdate)
11VALUES ('". $personName."',
12'". $email ."',
13'". $mobile ."',
14'". $address ."',
15'". $message ."',
16'". $tdate->format('Y-m-d') ."'
17)";
18if (mysqli_query($conn, $sql)) {
19echo "Your query posted successfully";
20} else {
21echo "Error: " . $sql . "" . mysqli_error($conn);
22}
23
24mysqli_close($conn);
25 
26?>
27

1	$(document).on('click','#btn-add',function(e) {
2		var data = $("#user_form").serialize();
3		$.ajax({
4			data: data,
5			type: "post",
6			url: "backend/save.php",
7			success: function(dataResult){
8					var dataResult = JSON.parse(dataResult);
9					if(dataResult.statusCode==200){
10						$('#addEmployeeModal').modal('hide');
11						alert('Data added successfully !'); 
12                        location.reload();						
13					}
14					else if(dataResult.statusCode==201){
15					   alert(dataResult);
16					}
17			}
18		});
19	});
20	$(document).on('click','.update',function(e) {
21		var id=$(this).attr("data-id");
22		var name=$(this).attr("data-name");
23		var email=$(this).attr("data-email");
24		var phone=$(this).attr("data-phone");
25		var city=$(this).attr("data-city");
26		$('#id_u').val(id);
27		$('#name_u').val(name);
28		$('#email_u').val(email);
29		$('#phone_u').val(phone);
30		$('#city_u').val(city);
31	});
32	
33	$(document).on('click','#update',function(e) {
34		var data = $("#update_form").serialize();
35		$.ajax({
36			data: data,
37			type: "post",
38			url: "backend/save.php",
39			success: function(dataResult){
40					var dataResult = JSON.parse(dataResult);
41					if(dataResult.statusCode==200){
42						$('#editEmployeeModal').modal('hide');
43						alert('Data updated successfully !'); 
44                        location.reload();						
45					}
46					else if(dataResult.statusCode==201){
47					   alert(dataResult);
48					}
49			}
50		});
51	});
52	$(document).on("click", ".delete", function() { 
53		var id=$(this).attr("data-id");
54		$('#id_d').val(id);
55		
56	});
57	$(document).on("click", "#delete", function() { 
58		$.ajax({
59			url: "backend/save.php",
60			type: "POST",
61			cache: false,
62			data:{
63				type:3,
64				id: $("#id_d").val()
65			},
66			success: function(dataResult){
67					$('#deleteEmployeeModal').modal('hide');
68					$("#"+dataResult).remove();
69			
70			}
71		});
72	});
73	$(document).on("click", "#delete_multiple", function() {
74		var user = [];
75		$(".user_checkbox:checked").each(function() {
76			user.push($(this).data('user-id'));
77		});
78		if(user.length <=0) {
79			alert("Please select records."); 
80		} 
81		else { 
82			WRN_PROFILE_DELETE = "Are you sure you want to delete "+(user.length>1?"these":"this")+" row?";
83			var checked = confirm(WRN_PROFILE_DELETE);
84			if(checked == true) {
85				var selected_values = user.join(",");
86				console.log(selected_values);
87				$.ajax({
88					type: "POST",
89					url: "backend/save.php",
90					cache:false,
91					data:{
92						type: 4,						
93						id : selected_values
94					},
95					success: function(response) {
96						var ids = response.split(",");
97						for (var i=0; i < ids.length; i++ ) {	
98							$("#"+ids[i]).remove(); 
99						}	
100					} 
101				}); 
102			}  
103		} 
104	});
105	$(document).ready(function(){
106		$('[data-toggle="tooltip"]').tooltip();
107		var checkbox = $('table tbody input[type="checkbox"]');
108		$("#selectAll").click(function(){
109			if(this.checked){
110				checkbox.each(function(){
111					this.checked = true;                        
112				});
113			} else{
114				checkbox.each(function(){
115					this.checked = false;                        
116				});
117			} 
118		});
119		checkbox.click(function(){
120			if(!this.checked){
121				$("#selectAll").prop("checked", false);
122			}
123		});
124	});
125