Php json encode - specific format for json objects

Question

I am currently using a third party api. I am having some diffulties formatting my db values into json objects. The api takes the values on if they’re in a certain format. In the php code below I am using foreach loop to fetch the results. Then array_push to place the values inside the array. I am getting string data instead of numerical for coordinates. In the end, I am not getting the desired result. How can I format the json objects to look like the example below?

Current Result:

{
coordinates: [
"-121.2808, 38.3320"
],
attributes: "Sacramento"
},

Desired Result:

{
    coordinates: [-121.2808, 38.3320],
    attributes: {
        name: 'Sacramento'
    }
},

PHP loop and json_encode

header("Content-type: application/json");
//get the course list
$location_query = $db_con->prepare("SELECT city, X(location) as latitude, Y(location) as longitude
FROM company
");
$location_query->execute();
$data = $location_query->fetchAll();
$output = array();
foreach ($data as $row) {
    array_push($output, array('coordinates'=>array($row["latitude"].",".$row["longitude"]), 'attributes'=>$row["city"]));


}// foreach ($data as $row) {
echo json_encode($output);

Community · Accepted Answer · 2023-11-17 20:24:57Z

4

You need to get the float representation of that string, try using either floatval or casting it to a float.

floatval

floatval($row["latitude"])

Casting

(float) $row["latitude"]

Do this for both latitude and longitude.

Also for some reason you are building a string with a comma in it. To produce the proper representation it should look like this.

array_push($output, array(
    'coordinates' => array((float) $row["latitude"], (float) $row["longitude"]),
    'attributes' => array('name' => $row["city"]))
));

Arrays with keys represent objects, hence the array with a key => value.

Edit: Thanks to Mike for pointing out the attribute error, was too focused on the casting :)

edited Nov 17, 2023 at 20:24

CommunityBot

11 silver badge

answered Jan 12, 2014 at 0:22

SamV

7,5964 gold badges41 silver badges50 bronze badges

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

2 Comments

Mike Over a year ago

Close. You need 'attributes'=> array('name' => $row["city"]))

user1434156 Over a year ago

Thank you! Now it makes sense. I will use float.

Collectives™ on Stack Overflow

Php json encode - specific format for json objects

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related