Live Table Insert Update Delete in php using jquery and ajax example

Today, We want to share with you live table edit with jquery and ajax php.In this post we will show you inline table editing using jquery ajax php and mysql, hear for jquery editable table we will give you demo and example for implement.In this post, we will learn about PHP Inline Editing Table Using JQuery Ajax with an example.

Live Table Edit with Jquery and Ajax

Step 1: index.php

CREATE TABLE `jobs` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`skills` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
`gender` varchar(255) NOT NULL,
`appointment` varchar(255) NOT NULL,
`age` int(11) NOT NULL,
`image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Step 2: Include jQuery and Tabledit plugin

jquery.tabledit.js
custom_table_edit.js
jquery.js

Step 3: index.php

Id
Name
Gender
Age
Appointment
Address

Step 4: custom_table_edit.js
Make HTML table Editable with Tabledit Plugin

$(document).ready(function(){
$('#response_table').Tabledit({
deleteButton: false,
editButton: false,
columns: {
identifier: [0, 'id'],
editable: [[1, 'name'], [2, 'gender'], [3, 'age'], [4, 'appointment'], [5, 'location']]
},
hideIdentifier: true,
url: 'live_edit.php'
});
});

Step 5: live_edit.php
Save Live HTML Table Edit into MySQL Database

I hope you get an idea about Create Live Editable Table with jQuery, PHP and MySQL.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.