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.