Send response immediately PHP Jquery AJAX

Question

I have a basic idea on how to do AJAX request but what I really want is to send a response immediately after fetching data, not waiting for all of the mysql query results to finish. Is there any way to do this? Can you give an idea?

What I really imagined is for example:

When the document is ready, then the client shall send request of all the list in the database. While PHP on the server side is fetching data, it'll send the rows as json then the client keeps on parsing those response until the server side cannot fetch rows anymore.

Is it possible? If so, do you have an idea?

You means to say you want to immediate another ajax call on first ajax call response? — Geee, Apr 23 '17 at 12:44
@GhanshyamBhava yeah while mysql is fetching rows those rows are being sent immediately — Ehmz Yoshino Mamei, Apr 23 '17 at 12:59
Are you looking for something like this: http://stackoverflow.com/a/15273676/6067322 — kikkula kokkula, Apr 23 '17 at 13:04
I don't know but what I imagine is when the document is ready then fetch data while fetching data send it immediately to the client. if there are no more rows to fetch, then request is done. then the list would appear one by one, something like that. — Ehmz Yoshino Mamei, Apr 23 '17 at 13:08

score -1 · Accepted Answer · answered Apr 23 '17 at 13:30

I have small piece of code for this. might be you accept!

JQuery:

<script>

    $(document).ready(function() {
        view();
    });

    function register()
    {
        var f = $('#fname').val();
        var l = $('#lname').val();

        $.ajax({
            url:'index.php/control/insert',
            data :{fname : f, lname : l},
            type:'post',
            success:function(msg){
                return view();
            }
        });
    }

  function view()
  {
        $.ajax({
            url:'index.php/control/show',
            data :{},
            type:'post',
            success:function(msg){
                $('#table').html(msg);
            }
        });
    }
</script>

HTML Form:

<form action="" method="post">
    <table align="center" border="11">
        <tr>
            <td>First name</td>
            <td><input type="text" name="fname" id="fname" /></td>
        </tr>
        <tr>
            <td>Last Name</td>
            <td><input type="text" name="lname" id="lname" /></td>
        </tr>
        <tr>
            <td colspan="2"><input type="button" id="submit" name="submit" onclick="register()" value="Register"></td>
        </tr>
    </table>
</form>

My Controller for Mysql function:

public function insert()
{
    $sql = "INSERT INTO MyGuests (firstname, lastname) VALUES ('".$_REQUEST['fname']."', '".$_REQUEST['lname']."')";

    if ($conn->query($sql) === TRUE) {
        echo "New record created successfully";
    }
}
public function show()
{
    $sql = "SELECT * FROM MyGuests";

    if ($data = $conn->query($sql) === TRUE) {
        echo "New record created successfully";
    }

    echo "<br><table border='1' align='center'>
            <tr>
                <th>Firstname</th>
               <th>Lastname</th>
            </tr>";
            foreach($data as $s)
            {
               echo "<tr><td>".$s->fname."</td>";
                echo "<td>".$s->lname."</td></tr>";
            }
    echo "</table>" ;
}

make sure code is not tested this is the sample for your requirement, aim to aware call immediate function. here i have called view() function just after inserting data in to the database.

Send response immediately PHP Jquery AJAX

1 Answers1