Posted by OmegaJunior on 02/01/07 10:27

Hi Jeff!

"Stored on the server" is a broad term. You can similate this, and it wi=
ll =

work as desired. Let me explain:

Say you create a file named geolocations.php.
In that file you create your script to retrieve the wanted geo locations=
.. =

You'll probably want to hand it some parameters so you could call it lik=
e =

this:

geolocations.php?id=3D5&lat=3D41&lng=3D-97&zoom=3D10

then using the $_GET variables to read the parameters and use them in yo=
ur =

sql query.

Then from the result of your query, you build your xml file. Fastest way=
=

to do this as far as I've seen is to create it yourself, using plain tex=
t.

Then this xml file will be the output of your page, just like you'd outp=
ut =

an html page using php, which means that you can use the call to =

geolocations.php directly in the javascript that handles the xml file. =

Don't forget to send a content header, like header('Content-type: =

application/xml') or header('Content-type: text/plain').

I've done this with a none-xml file to query for locations that near a =

given location.

Hope this helps!



On Tue, 30 Jan 2007 14:39:17 +0100, Jeff =

<it_consultant1@hotmail.com.NOSPAM> wrote:

> Hey
>
> I'm developing a web site using PHP 5.2.0 and MySql5.
>
> Now I'm trying to implement Google Map into the web site. My problem =

> here is
> that this ajax service wants the Geo Locations sent in a xml format...=

>
> Lets say this is the select
> select lattitude, longitude from location where id =3D 1;
>
> The result of that select is what I want converted into a xml format a=
nd
> then sent to the requesting ajax service....
>
> All the examples I've read about this subject are using a flat xml fil=
es
> stored on the server... but that is no good solution.. -> I want the x=
ml =

> to
> be dynamically generated and sent over to the requesting ajax service.=
... =

> I
> don't know how to generate such a xml output of a database select..
>
> Any suggestions?
>
> Jeff
>
>



-- =

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

[Back to original message]