javascript variable from mysql database

Question

Hi I'm trying to plot multiple values and successfully done using this variable.

    var locations = [
  ['Bacolod City', 10.64073 ,122.9689, 4],
  ['Bago City', 10.5333 ,122.8333, 5],
  ['Cadiz City', 10.950, 123.29, 3],
  ['Sipalay City', 9.7519, 122.40, 2],
  ['Kabankalan City', 9.896, 122.831, 1]
];

Now my next step is instead of static data like above, I would like to retrieve data from my mysql database and use it for var locations. Would appreciate any help on how to perform that. most i have seen is complicated and use json which i have no experience in. Thanks in advance.

Note:Btw I'm trying to plot using google maps api. sorry for not mentioning.

echo "var data = ".json_encode(data).";\n". That's not complicated. — John Dvorak
– John Dvorak, Commented Dec 17, 2012 at 15:37

Vytautas Butkus · Accepted Answer · 2012-12-17 15:40:48Z

1

You should read about Ajax or could use one of many tutorials: http://www.php4every1.com/tutorials/jquery-ajax-tutorial/

answered Dec 17, 2012 at 15:40

Vytautas Butkus

5,5556 gold badges34 silver badges46 bronze badges

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

Comments

geocodezip · Accepted Answer · 2012-12-17 15:59:52Z

0

If you look at the Articles section of the documentation there are several examples of how to use PHP/MySQL with the Google Maps API v3:

answered Dec 17, 2012 at 15:59

geocodezip

162k14 gold badges228 silver badges257 bronze badges

Collectives™ on Stack Overflow

javascript variable from mysql database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related