Returning an array from PHP to jQuery from Ajax

Question

I'm trying to get PHP returned array from Ajax.

Here is my Ajax call:

And my PHP code is this:

Query is running perfectly.

I have tried to get values like alert(data[0].program_title) in ajax success. But it also returns Undefined.

How can I fix this issue?

Please don't do that, include your code as text in your question not as screenshots — empiric, Sep 12 '19 at 12:50
But to answer your question: `json_encode` your php array and `echo` it in your function to get it in your ajax callback — empiric, Sep 12 '19 at 12:52
The code you've posted doesn't actually output anything since `return` doesn't output the data. You should also return it as json. — Magnus Eriksson, Sep 12 '19 at 12:52
Ok, Thank you for your advice. I will do it from the next question — Kalpa Wijesooriya, Sep 12 '19 at 12:53

score 2 · Accepted Answer · answered Sep 12 '19 at 12:58

2

In your PHP code:

//remove
return $data

//change with
echo json_encode($data);

answered Sep 12 '19 at 12:58

Stefano Pascazi

341
1
10

score 1 · Answer 2 · answered Sep 12 '19 at 13:10

Just before flushing the data back to the stream (returning), convert your data ($data variable in this case) to JSON string using json_encode and add the proper content-type application/json using header function.

However, the best practice is to provide some metadata to your data included in your transfer, like the size of data and count of elements in data and if paginated, which page the data refers to and what the maximum available pages and maximum element size of a page are.

Here's a sample body structure for a more robust data transfer:

$response = [
   'page'          => 0,   // e.g.
   'count'         => count($data),
   'data'          => $data,
   'max_page'      => 3,   // e.g.
   'item_per_page' => 15,  // e.g.
   'status_code'   => 200, // e.g.
];
header ( "Content-Type: application\/json", true , 200);
return json_encode(
   $response
   , JSON_INVALID_UTF8_SUBSTITUTE
      | JSON_NUMERIC_CHECK
      | JSON_PRESERVE_ZERO_FRACTION
      | JSON_UNESCAPED_LINE_TERMINATORS
      | JSON_UNESCAPED_SLASHES
      | JSON_UNESCAPED_UNICODE
);

score 0 · Answer 3 · answered Sep 12 '19 at 13:00

0

Try this:

$data = [];
if ($numRows>0) {
    while($row=$result->fetch_assoc()) {
        $data[] = $row;
    }
}

Replace return with echo and add json_encode

echo json_encode($data);

answered Sep 12 '19 at 13:00

failedCoder

1,235
1
7
28

Returning an array from PHP to jQuery from Ajax

3 Answers3