Putting mysql stored points on a google map

Question

I have a MySQL database with a table full of geographic points, latitudes and longitudes. I want these coordinates displayed on a Google map as points. Is it possible for JavaScript to directly access the database or would I need to do that first using PHP?

You'll need a server side script/program to interact with the database, so using PHP would be the way to go. — Chris C
– Chris C, Commented Sep 16, 2011 at 18:58

stealthyninja · Accepted Answer · 2011-09-16 19:03:51Z

2

Yes, it's possible and you'd have to use PHP to retrieve your points from the database. For examples of the Google part of your request, have a look at the Google Maps Javascript API V3 reference and update your question when you've put some code together.

answered Sep 16, 2011 at 19:03

stealthyninja

10.4k11 gold badges57 silver badges61 bronze badges

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

1 Comment

stealthyninja Over a year ago

Here's a more direct link to the code samples from the API reference: code.google.com/apis/maps/documentation/javascript/examples/…

Steve Robbins · Accepted Answer · 2011-09-16 19:10:40Z

0

You would need some sort of server side language to be involved. Likely ajax/json request or pulling an XML file and looping through the data. If you're more comfortable with PHP you would loop through your results within a script tag:

<script type="text/javascript">

    var mapArray = new Array;

    <?php

        $i = 0;

        $result = mysql_query('SELECT * FROM location');

        while ($row = mysql_fetch_assoc($result)) {

            echo 'mapArray[' .$i++ . '] = new Array(' . $row['lat'] . ',
                         ' . $row['lng'] . '");

        ';
        }

    ?>

    for (var i in mapArray) {

        var myLatLng = new GLatLng(mapArray[i][0], mapArray[i][1]);
        GMarker(myLatLng);
    }
</script>

edited Sep 16, 2011 at 19:10

answered Sep 16, 2011 at 19:05

Steve Robbins

13.8k12 gold badges81 silver badges129 bronze badges

Comments

Sceak · Accepted Answer · 2011-09-16 19:00:41Z

0

It is possible to use a PHP script as a link between JavaScript and the SQL database witht he use of the JavaScript XMLHttpRequest object.

answered Sep 16, 2011 at 19:00

Sceak

211 bronze badge

Collectives™ on Stack Overflow

Putting mysql stored points on a google map

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related