Update database table using ajax call

Question

I have HTML page which contains a Editable table, Where I am fetching the data from database using PHP and inserting into the that table. As my table is Editable, I want to update the values into the database when the user update any row value.

Please suggest me,because I don't know how to make AJAX call when user edits and click anywhere on browser.

You should learn the ajax to implement this because no other option. — PayPal_Kartik
– PayPal_Kartik, Commented Mar 29, 2017 at 10:54
Possible duplicate of How do I call ajax() when user enter(using keyboard) on input box using jquery — gabba
– gabba, Commented Mar 29, 2017 at 12:06

Thomas Rbt · Accepted Answer · 2017-03-29 12:14:41Z

2

You have to catch the moment where the datas are saved in your datatable: Often a click on a button. So you need a code like that :

$(document).ready(function(){
 $('#save-row-4').on('click', function(){
   // Your ajax call here
 });
});

The ajax have to be like :

$.ajax({
    url: '/path/to/php/script.php',
    type: 'POST',
    data: {
       variable1: 'val1',
       variable2: 'val2',
       variable3: 'val3'
    },
    error: function(return) {
        alert("error");
    },
    success: function(return) {
        console.log("Datas saved");
    },
});

Don't forget to replace val1, val2 with the value of your inputs. Then, in your php script, you will be able to get these datas with $_POST['variable1'] .

edited Mar 29, 2017 at 12:14

answered Mar 29, 2017 at 11:18

Thomas Rbt

1,5421 gold badge15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sForSujit Over a year ago

Thanks a lot. That solves my problem. I got idea to proceed

Thomas Rbt Over a year ago

No problems :-)

Collectives™ on Stack Overflow

Update database table using ajax call

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related