How to return data to a jquery ajax callback function?

Question

How to return data to a jquery ajax callback function in which the data is coming from a PHP mysql query..

<script language="javascript" type="text/javascript">
   $(document).ready(function() {
        $.post("getMySqlData", function(data){

        });
   });
</script>

here's the PHP code which perform the mysql query to select data from a mysql database

  <?php
    $host = "127.0.0.1";
    $user = "root";
    $password = "problem2";
    $database = "scsi_test_log";
    $cxn = mysqli_connect($host, $user, $password, $database) or die ("couldnt connect to server");

    $query = "SELECT test_header FROM scsi_test";
    $result = mysqli_query($cxn, $query) or die ("Couldn't execute query.");
  ?>

please read this: ditio.net/2008/07/17/php-json-and-javascript-usage — Baz1nga
– Baz1nga, Commented Aug 28, 2011 at 20:12

Rijk · Accepted Answer · 2011-08-28 19:53:40Z

2

Fetch the result into an array, and echo that in JSON encoding;

$rows = array();
while ( $row = mysqli_fetch_assoc( $result ) ) {
    $rows[] = $row;
}

echo json_encode( $rows );

answered Aug 28, 2011 at 19:53

Rijk

11.3k3 gold badges33 silver badges46 bronze badges

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

1 Comment

Bruc Walker Over a year ago

Does the echo return this data back to the callback function of the jquery ajax?

Collectives™ on Stack Overflow

How to return data to a jquery ajax callback function?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related