update_multiple_rows using ajax and php

Question

please in need help in updating multiple rows based on dynamic data fetched from mysql database. I have implemented this using $_Post to udate.php file, but how can i do this using ajax.

//THIS SCRIPT FETCH FROM DATABASE
<body>
    <?php
    mysql_connect("localhost","root","");
    mysql_select_db("student") or die("Unable to select database");

    $sql = "SELECT * FROM students ORDER BY id";

    $result = mysql_query($sql) or die($sql."<br/><br/>".mysql_error());

    $i = 0;

    echo '<table width="50%">';
    echo '<tr>';
    echo '<td>ID</td>';
    echo '<td>Name</td>';
    echo '<td>Address</td>';
    echo '</tr>';

    echo "<form name='form_update' method='post' action='update.php'>\n";
    while ($students = mysql_fetch_array($result)) {
    echo '<tr>';
    echo "<td>{$students['id']}<input type='hidden' name='id[$i]'value='{$students['id']}' /></td>";
    echo "<td>{$students['name']}</td>";
    echo "<td><input type='text' size='40' name='address[$i]' value='{$students['address']}' /></td>";
    echo '</tr>';
    ++$i; 
    }
    echo '<tr>';
    echo "<td><input type='submit' value='submit' /></td>";
    echo '</tr>';
    echo "</form>";
    echo '</table>';
    echo $i; ?>


    </body>

// HERE IS THE UPDATE SCRIPT // On clicking submit all rows are updated but i still cant achieve dis with ajax. UPDATE.PHP

    $size = count($_POST['address']);

    $i = 0;
    while ($i < $size) {
    $address= $_POST['address'][$i];
    $id = $_POST['id'][$i];

    $query = "UPDATE students SET address = '$address' WHERE id = '$id' LIMIT 1";
    mysql_query($query) or die ("Error in query: $query");
    echo "$address<br /><br /><em>Updated!</em><br /><br />";
    ++$i;
}
?>

HERE IS WHAT I HAVE TRIED ON AJAX

function update(){
var j=0;
while(j< <?php echo $i ; ?>){
var id=$("#id" + j);    
var address=$("#address" + j);

$.ajax(
{
url:"update.php",
type:"post",
data:{id:id.val(),address:address.val()},
success:function(response)
{
}
});



}

ANY HELP WILL BE APPRECIATED

score 0 · Accepted Answer · edited May 23 '17 at 12:21

You shouldn't need to loop and execute multiple POSTs. Simply serialize the form data and send it to the script, e.g.:

$.ajax({
    url: 'update.php',
    type: 'post',
    data: $('#your-form-id').serialize(), 
    success:function(response){
        // do something
    }
});

Also, you should consider revising your PHP to prevent SQL injection: How can I prevent SQL injection in PHP?

update_multiple_rows using ajax and php

1 Answers1