Posted inphp / Ajax / JavaScript / jQuery / Mysql / Mysqli

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.

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Leave a Reply

Your email address will not be published. Required fields are marked *

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype