can i move array from php to javascript retrive from mysql database

Question

my php code get_marker_connect2.php

<?php
$servername = "localhost";
$username = "root";
$passcode = "";
$dbname = "complaint_system";
$con=mysqli_connect($servername,$username,$passcode,$dbname);
// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

//store query
$result = mysqli_query($con,"SELECT l_longitude,l_latitude FROM register_complain");

echo "<table border='1'>

<tr>
<th>Latitude</th>
<th>Longitude</th>
</tr>";

while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['l_longitude'] . "</td>";
    echo "<td>
    " . $row['l_latitude'] . "</td>";
    echo "</tr>";
}
echo "</table>";
header('Location:http://localhost/cca/View_Map.html');
mysqli_close($con);
?> 

This is my javascript named as javascript1.js

function initialize() {    
    var myLatLng = new google.maps.LatLng(24.86, 67.01);
    var mapOptions = {

    center: myLatLng,
    zoom: 14,
    mapTypeControl: true,
    mapTypeId: google.maps.MapTypeId.ROADMAP};

    alert('alert array here');

    /*for (var i = 0; i < latlong1.length; i++) {
    alert(" Longitude = ". latlong1[i].longitude);
    alert(" Latitude = ". latlong1[i].latitude);
    }
    */

    map = new google.maps.Map(document.getElementById("view-map"),
        mapOptions);
    var marker = new google.maps.Marker({
    position: simple,
    map: map,
    title: 'Hello Karachi!'});  
}
google.maps.event.addDomListener(window, 'load', initialize);

can i move php array $row['l_longitude'] and $row['l_latitude'] directly to my javascript? i have google it alot but have not found solution yet. i want to alert that array in my javascript at "alert array here"

Answer 1

If you wish to print a complex structure into your page that is worked in a browser, you need a syntax that Javascript can parse, and the serverside language can print.

The neareset possibilities are:

• XML
• JSON

I recommend JSON for now.

So with PHP, you write somewhere:

echo "var myTransportedArrayJson = \"" . json_encode($my_array) . "\"";

And then let the Javascript parse your json expression:

var myTransportedArray = JSON.parse(myTransportedArrayJson);
alert(myTransportedArray);   // <<< and here you are.

Of course the snippet must be part of the response, otherwise it won't reach the server. Also, you should embrace the parsing with try .. catch. If you go on and work with even more complex structures, you have to consider escaping certain chars. So you will find now some literature :-)