Update database using ajax php – How to edit or update Data using PHP Ajax?

update database using ajax php : Here for update or edit data, first we want to fetch existing data from database using Ajax request send to PHP Crud.

update database using ajax php

Here I using main 4 file for update data from MySql database using Ajax.

1. connection_db.php
2. member_update.php
3. member_listing.php
4. members.php

jQuery ajax add edit delete records in database using php Example with demo.

Table member_data

Step 1: Crate a Database Table

   CREATE TABLE `members_details` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

step 2: Connection Database table into PHP

PHP Mysql Create connection
connection_db.php

Step 3: update database using ajax jquery

member_update.php

200));
	} 
	else {
		echo json_encode(array("statusCode"=>201));
	}
	mysqli_close($conn);
?>

Step 4: ajax add edit delete records in database using php

member_listing.php
how to edit data in php?

query($sql);
	if ($result->num_rows > 0) {
		while($row = $result->fetch_assoc()) {
?>	
		
			
			
			
			
			Edit
		

		No Result found !
		";
	}
	mysqli_close($conn);
?>

Don’t Miss : Bootstrap Toggle Switch Update Database Field Using Ajax

Step : 5 Full View Code

update data using ajax in php
members.php

        


  
  
  
  
  
  
  



  
View Members
  

	  ×
	
	

    

      

        
Member Name
        
Member Email
        
Member Mobile
		
Member Address
		
Action
      
    
    

      
    
  


    

		

		  

			

			  
 Update
			 
			
			

			
				
				

					

					    Name
					
					

						
					
	
				
			    
				

					

					    Email
					
					

						
					
	
				
			    
				

					

					    mobile
					
					

						
					
	
				
				
				

					

					    address
					
					

						
					
	
				
				
			
			

			
Save
			Close
			
		  
		  
		
	

I hope you get an idea about insert delete update data using ajax in php.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.