And that can be further improved if you cast numeric results to
numeric types:
while($r = mysql_fetch_assoc($sth)) {
$r['lat']=(float) $r['lat'];
$r['lng']=(float) $r['llng'];
$rows[] = $r;
}
Your encoded JSON when eval'd will now create numeric and not string
properties for lat and lng.
Martin.
On Feb 3, 10:08 pm, duncan_m <[email protected]> wrote:
> You're massively overcomplicating this.. Here's my PHP file that
> produces JSON for all the markers I need to map.. Javascript on the
> client side does the rest:
>
> <?php
> require 'killguest.php';
> require 'db_connect.php';
>
> $sth = mysql_query("SELECT id, speed, name as details, time, latitude
> as lat, longitude as lng, category_id, crewname as code from
> z_cached_locations");
> $rows = array();
>
> while($r = mysql_fetch_assoc($sth)) {
> $rows[] = $r;}
>
> echo json_encode($rows);
> mysql_close();
> ?>
>
> Duncan.
>
> On Feb 3, 3:51 pm, guido Schmidt <[email protected]> wrote:
>
> > I did manage to make a website with markers.
> > The lat/ lng is stored in the database extra data is also in the database.
>
> > A xml file is outputed:http://www.finnschmidt.nl/gen_xml2.php?regio=aare
> > It is read in the following
> > map:http://www.finnschmidt.nl/reis/aare/map/index2.php
>
> > I want also use polyline between several markers. Markers with Type="X"
> > should display a line beteween the markers.
> > (http://econym.org.uk/gmap/example_map7.htm/ http://econym.org.uk/gmap/example4.xml)
>
> > The php file needs to do this, I have little programming scills, but so far
> > it was working.
>
> > Could some point me in the right direction, or give me some hints.
>
> > If you need more info, please let me know.
>
> > Guido
>
> > <?php
> > require("connect.php");
>
> > // Get parameters from URL
> > $regio = $_GET["regio"];
>
> > // Start XML file, create parent node
> > $dom = new DOMDocument("1.0");
> > $node = $dom->createElement("markers");
> > $parnode = $dom->appendChild($node);
>
> > // Opens a connection to a mySQL server
> > $connection=mysql_connect (localhost, $username, $password);
> > if (!$connection) {
> > die("Not connected : " . mysql_error());
>
> > }
>
> > // Set the active mySQL database
> > $db_selected = mysql_select_db($database, $connection);
> > if (!$db_selected) {
> > die ("Can\'t use db : " . mysql_error());
>
> > }
>
> > // Search the rows in the markers table
> > $query = sprintf("SELECT id, naam, lat, lng, info, url, type FROM markers
> > WHERE `regio` = '$regio' ",
> > mysql_real_escape_string($center_lat),
> > mysql_real_escape_string($center_lng),
> > mysql_real_escape_string($center_lat),
> > mysql_real_escape_string($radius));
> > $result = mysql_query($query);
>
> > $result = mysql_query($query);
> > if (!$result) {
> > die("Invalid query: " . mysql_error());
>
> > }
>
> > header("Content-type: text/xml");
>
> > // Iterate through the rows, adding XML nodes for each
> > while ($row = @mysql_fetch_assoc($result)){
> > $node = $dom->createElement("marker");
> > $newnode = $parnode->appendChild($node);
> > $newnode->setAttribute("naam", $row['naam']);
> > $newnode->setAttribute("id", $row['id']);
> > $newnode->setAttribute("info", $row['info']);
> > $newnode->setAttribute("url", $row['url']);
> > $newnode->setAttribute("type", $row['type']);
> > $newnode->setAttribute("lat", $row['lat']);
> > $newnode->setAttribute("lng", $row['lng']);
>
> > }
>
> > echo $dom->saveXML();
> > ?>
--
You received this message because you are subscribed to the Google Groups
"Google Maps API V2" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-maps-api?hl=en.
