[OpenLayers-Users] which is the best way to display a set of points coming from database?

[BMcBride]

Hey Alberto,

I've had luck using PHP with a SELECT statement on a MySQL database to write
a KML file for use in OpenLayers.  As long as your query returns a
relatively small subset of features (<500) and your users have a snappy
connection with a decent browser, you should be OK using this method. 
Fortunately you are returning point features with a single set of coordinate
pairs, as opposed to complex polygons!  A benefit of using KML is that you
can also let the user download the results in a fairly common and readily
usable GIS format without having to write any additional code.  If you are
interested I can post my MySQL -> KML PHP script.

Best of luck!

BRYAN

-----
Bryan R. McBride, GISP
http://www.bryanmcbride.com bryanmcbride.com 
http://geoserving.net/ geoserving.net 
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5487113.html
Sent from the OpenLayers Users mailing list archive at Nabble.com.