PHP json_encode multidimensional associative array

Question

I've used php's json_encode() function many times, but for some reason I can't seem to find the problem here...

Note: I've removed error checking for clarity purposes.

//PHP

<?php
session_start();
require 'global/query.php';
$sql = "SELECT sfl,station,latitude,longitude,address,city FROM maps";
$stmt = $pdo->prepare($sql);
$stmt->execute();
while($result = $stmt->fetch(PDO::FETCH_ASSOC)){
    $trows[] = $result;
}
echo json_encode($trows);
?>

I'm using AJAX and am just console.log()-ing the output to print the response like so...

//JS

var callback = {
    "projects": function(e){
        console.log(e.target.response);
    }
};

In the console it prints a blank line with none of the data...

Now if I var_dump the $trows the output in the console will print the data so I know my sql statement works just fine...

//PHP

var_dump($trows);

//CONSOLE

array(522) {
  [0]=>
  array(6) {
    ["sfl"]=>
    string(1) "1"
    ["station"]=>
    string(26) "COMPRESSOR STATION"
    ["latitude"]=>
    string(2) "23"
    ["longitude"]=>
    string(4) "-115"
    ["address"]=>
    string(10) "Unnamed Rd"
    ["city"]=>
    string(9) "blah"
  }
  [1]=>
  array(6) {
    ["sfl"]=>
    string(1) "2"
    ["station"]=>
    string(17) "STA TERMINAL"
    ["latitude"]=>
    string(2) "16"
    ["longitude"]=>
    string(4) "-101"
    ["address"]=>
    string(11) "15 Ranch Dr"
    ["city"]=>
    string(8) "Blah Blah"
  },

Questions: Why isn't my php's json_encode function working? I've used this exact code before and the output was fine.

Did you test your page by simply opening it in a browser? Do you get the expected output? If yes: problem in your AJAX code, if not: What exactly are you receiving? — Kep
– Kep, Commented Oct 22, 2015 at 16:29
You're using the console already; why not look in the Net tab of the dev tools to see what the actual http response looks like? — Simba
– Simba, Commented Oct 22, 2015 at 16:29
@ccKep Yea if I var_dump the $trows variable it will dump the data to the console, if I use json_encode it prints blank line — Jordan Davis
– Jordan Davis, Commented Oct 22, 2015 at 16:32
@Simba Yea I've looked at that as well it and it's blank response. — Jordan Davis
– Jordan Davis, Commented Oct 22, 2015 at 16:33
@VincentWilkie yea I thought that might of been it at first, but I did test that before and it wasn't related, thanks for your input though! — Jordan Davis
– Jordan Davis, Commented Oct 22, 2015 at 16:43

AbraCadaver · Accepted Answer · 2015-10-22 17:28:31Z

3

Try and add:

 header("Content-type: application/json; charset=utf-8");

Before you echo your JSON encoded result.

EDIT:

If the encoding doesn't work try the following:

while ($result = $stmt->fetch(PDO::FETCH_ASSOC)) 
{
    $trows[] = array_map('utf8_encode', $result);
}

edited Oct 22, 2015 at 17:28

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

answered Oct 22, 2015 at 16:29

Ralph Melhem

7575 silver badges12 bronze badges

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

2 Comments

Jordan Davis Over a year ago

You nailed it, it was encoding error and the array_map() fixed it!

Ralph Melhem Over a year ago

Cheers mate, glad i could help

dave · Accepted Answer · 2015-10-22 16:29:23Z

1

I would see what PHP tells you:

Change

echo json_encode($trows);

to

$json = json_encode($trows);
$error = json_last_error();
if ($error !== JSON_ERROR_NONE) {
    echo json_last_error_msg();
} else {
    echo $json;
}

answered Oct 22, 2015 at 16:29

dave

65.1k6 gold badges81 silver badges98 bronze badges

2 Comments

Jordan Davis Over a year ago

I'll throw that in there in try it 1 sec

Jordan Davis Over a year ago

Ok yea it finally outputted encoding error, thank you for your help +1

Collectives™ on Stack Overflow

PHP json_encode multidimensional associative array

2 Answers 2

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Linked

Related