PHP array and Ajax response

Question

I am currently trying to call a php script through Ajax so I can read it in my html file. I am using Json and Ajax to achieve this. I am having an issue with my php script where I can't get the information to format correctly when sending it over to the html. Here's my php:

$return_arr = array();
$fetch = mysqli_query("SELECT User_Id, First_Name, Last_Name FROM Users"); 

while ($row = mysqli_fetch_array($fetch, MYSQLI_ASSOC)) {
    $row_array['User_Id'] = $row['User_Id'];
    $row_array['First_Name'] = $row['First_Name'];
    $row_array['Last_Name'] = $row['Last_Name'];
    array_push($return_arr,$row_array);
}

echo json_encode($return_arr);

I am getting the following type of response:

[{"User_Id":"6","First_Name":"Joe","Last_Name":"Shmo"},
{"User_Id":"17","First_Name":"Test","Last_Name":"Test"},
{"User_Id":"18","First_Name":"Test","Last_Name":"Test"},
{"User_Id":"19","First_Name":"Test","Last_Name":"Test"},
{"User_Id":"21","First_Name":"HI","Last_Name":"HI"}]

Now this causes me to have troubles while accessing in the html. I am trying to access it like:

data[0].User_Id

This gets undefined. I suspect the brackets are in the wrong places but can figure out how to switch them around.

Could you include the Javascript code you're using to fetch the data? — Cully
– Cully, Commented Jul 29, 2015 at 22:44

Cully · Accepted Answer · 2015-07-29 22:43:36Z

1

You need to do something like this:

<?php

header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');

echo json_encode( $return_arr );

answered Jul 29, 2015 at 22:43

Cully

6,9956 gold badges43 silver badges64 bronze badges

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

4 Comments

RightLeftRight12 Over a year ago

Very interesting. That worked correctly. What does this do exactly?

Cully Over a year ago

It tells the client that you're sending JSON data back.

Cully Over a year ago

The response you pasted above is probably just one big string (i.e. the string returned by json_encode). It looks like a JS object, but it isn't until you parse it into one. Instead of setting the header correctly, you could have done var dataJson = JSON.parse(data) and converted the string response into a JS object. Or told your AJAX library to expect JSON back.

Steve Chamaillard Over a year ago

It told your AJAX call that you were using JSON. When you don't tell your JS what data type you're using, it'll try to look into the Content-type. You can also simply write the datatype in your JS code. That's simpler to write and easier to understand.

Collectives™ on Stack Overflow

PHP array and Ajax response

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related