Java script array with php, fetch array [closed]

Question

I am trying to fetch latitude, longitude and venue by using

sites[0] // gets latitude
sites[1] // gets longitude
sites[2] // gets venue

This is my code, don't mind the sql queries, I know they are bad but it's functional for now. I just need help with this array:

  var sites = [<?php

include_once'config/connect.php';

$search= $_POST['search'];
$search = stripslashes($search);

$search = mysql_real_escape_string($search);

$sql= "select * from venue where vID in (select vID from sv where sID in (select sID from sports where sN = '$search'));";

$result=mysql_query($sql)or die(mysql_error()); 

while($data=mysql_fetch_array($result))
{
    echo ",[".$data['latitude']."]";
    echo ",[".$data['longitude']."]";
    echo ",[".$data['venue']."]";

}

?> ];

Answer 1

Create a normal PHP array containing the values you want, and call json_encode to convert it to JSON. Echo that, and parse it on the client.

<?php
    $data = mysql_fetch_array($result);
    $array = array($data['latitude'], $data['longitude'], $data['venue']);
?>

<script>
    var sites = <?php echo json_encode($array); ?>;
</script>

Edit: as @kba points out, the mysql_ methods are deprecated.

Answer 2

If you sql is working fine, then you just need to remove the extras "[" "]", so it will be like this:

echo $data['latitude'].", ";
echo $data['longitude'].", ";
echo $data['venue'];

Then your javascript array will be working ok

Answer 3

if u hav a php array $sites, u need to add it to js array sites

<?php
$sit="";
foreach($sites as $ar)
{
    if($sit=="")
    {
        $sit=$ar;
    }
    else
    {
        $sit=$sit.",".$ar;
    }
}
?>

in js:

var sites = [<?php echo $sit;] ?>;