PHP MySQL associative array using array_push

Question

I'm trying to create a associative array using PHP. I'm using a ajax script that calls a json file.

I have tested the script using the following PHP code:

$testLocs = array(
'loc5' => array( 'info' => 'Some random info', 'lat' => 0, 'lng' => 60 ),
'loc6' => array( 'info' => 'Some random info', 'lat' => 0, 'lng' => 40.345 )
);
echo json_encode($testLocs);

which echos:

{"loc1":{"info":"Some random info","lat":0,"lng":60},"loc1":{"info":"Some random info","lat":0,"lng":40.345}}

The ajax code will work correctly. Now I'm trying to write a PHP script that will get the info from the database. My PHP code is below

$query = "Select * from table";
$result = mysql_query($query);

$json_data = array();

while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$lat = $row['lat'];
$lon = $row['lon'];
$page = $row['page'];
array_push($json_data, array('info' => 'Some random info', 'lat' => $lat, 'lng' => $lon)); 
}


echo json_encode($json_data);

which echos:

{"info":"Some random info","lat":"-31.9522","lng":"115.8614"},{"info":"Some random info","lat":"40.7842","lng":"-73.8422"}

I cannot figure out how to put 'loc' => in front of each array. The ajax is using The locNUM as a unique ID.

Thank you

Change mysql_* to mysqli or PDO?

hjpotter92
– hjpotter92

2013-02-10 09:33:37 +00:00
Commented Feb 10, 2013 at 9:33 — hjpotter92
– hjpotter92, Commented Feb 10, 2013 at 9:33

scones · Accepted Answer · 2013-02-10 09:31:56Z

1

try

$json_data = array();
$i = 0;

while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$lat = $row['lat'];
$lon = $row['lon'];
$page = $row['page'];
$json_data["loc" . ($i++)] = array('info' => 'Some random info', 'lat' => $lat, 'lng' => $lon); 
}

instead of array_push. array_push is meant as a pure array function, not as a hash manipulating function.

answered Feb 10, 2013 at 9:31

scones

3,35526 silver badges36 bronze badges

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

1 Comment

chillers Over a year ago

Thank you it works now. I seen a tutorial how to do it but then I had arrays inside arrays.

Antony · Accepted Answer · 2013-02-10 09:34:07Z

0

If $row['id'] is the unique ID for locNUM:

$json_data["loc".$id] = array('info' => 'Some random info', 'lat' => $lat, 'lng' => $lon)

array_push() is the same as $array[] = $var;, which gives you an incremented numeric key.

answered Feb 10, 2013 at 9:34

Antony

15.2k10 gold badges48 silver badges76 bronze badges

Collectives™ on Stack Overflow

PHP MySQL associative array using array_push

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related