[OpenLayers-Users] Displaying Multiple Markers from Database

[Eric Lemoine]

On Feb 16, 2008 8:16 AM, schone <prashant.g.raju at gmail.com> wrote:
>
> Hello all,
>
> New to OpenLayers but I think it is an amazing project!
>
> So here is my situation...
>
> I have around 200 long/lat in a database attached with unique locations.
> (MySQL database)
>
> I would like to display all these markers on the map using OpenLayers but
> I'm finding it hard to display multiple markers.
>
> Has anyone got any good examples of working with Multiple Markers and MySQL
> or an XML document?
>
> Thanks for the help!
>
> Kind Regards
> Prashant

Hi Prashant

You'd need to have some software on the server side to extract the
data from your database and send it to the client. If I had to do
that, I'd implement a simple web sevice in Python that reads the
lon/lat's from the database and sends a JSON representation of this
data to the client. On the client side, I'd write code that requests
the data through Ajax and uses OpenLayers to create and display a
marker for each lon/lat in the response. This is just off the top of
my head...

Cheers,
--
Eric