Sorry for the delay in replying to this thread, thanks for the input
so far.

@bratliff - thx, but I dont want an IE only solution.

@Albert_Sun

I have looked into storing the polygon in a Mysql table row as you
suggested, and yes, this looks a really good solution, with lots of
downstream benefits I am sure I will be able to profit from.  BTW
There are certainly some gotchas involved with Polygon data and Mysql
which I will try and share at a later date.

But, here is where my head is starting to spin a little ... Lets say I
am retrieving a polygon for edit/review.

In my Mysql table, If I understand correctly, the data has to be
stored as a string in the format:

[POLYGON[lng lat,lng lat,lng lat]]

You will notice that it requires points in the order:  longitude,
latitude.

I have a JS object which draws an existing Polygon from an array which
is passed to it from my script.

Any experience on the best way to pass that data into a JS array?

Is it just a case of string manipulation in PHP?

//pseudocode

$sql = "select polygon from mytable where etc" ;
remove brackets and word POLYGON
explode on commas to get points

foreach( point )
  explode on spaces;
  and reverse order

create JS array in the format
a = [lat, lng] ;

OR is there a neater/cleverer way of doing this that anyone has come
across?

-- 
You received this message because you are subscribed to the Google Groups 
"Google Maps JavaScript API v3" 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-js-api-v3?hl=en.

Reply via email to