wrong output in address array after using json_encode() and JSON.parse

Question

I have this PHP which is fetching all rows of address column from the database and i an using json_encode() function to convert it into string and JSON.parse in javascript but i am not getting output as expected

 <? 

 include('dbcon.php');
 $result = mysql_query("SELECT address FROM markers");

 while ($row = mysql_fetch_assoc($result)) {
 $new_array[] = $row; 
 }
 print_r($new_array);

 $add_js = json_encode( $new_array );

 print_r($add_js);
 ?>

with print_r($new_array); i am getting two dimentional arrary and getting null in zeroth location. any changes i make it keeps on giving null at zeroth location.

   var address = [JSON.parse( '<?php echo $add_js ?>' )];

var address should store array of addresses but it is giving output when i alert in the array.

[object Object],[object Object],[object Object],[object Object],[object Object]

i want to store array of addresses after fetching them from database

Answer 1

So $new_array is an array of associative arrays, and it is decoded in JavaScript as an array of objects. If you want an array of strings instead, then you need to store strings in $new_array:

$new_array = array();
while ($row = mysql_fetch_assoc($result)) {
   $new_array[] = $row['address'];   // <-- This line
}

print_r($new_array);

$add_js = json_encode( $new_array );

print_r($add_js);

Answer 2

I think this is enough for your need:

var address = <?php echo $add_js ?>