generating an XML doc from PHP?

[paul brown]

I've been looking up the in the documentation, but I can't seem to find
what I'm looking for.

I want to do query a MySQL table and return the results to the browser
as an XML doc. What's the best way to do it?

Thanks,

Paul

[Manuel Lemos]

Re: generating an XML doc from PHP?

Hello,

On 02/15/2004 06:46 PM, paul brown wrote:[color=blue]
> I've been looking up the in the documentation, but I can't seem to find
> what I'm looking for.
>
> I want to do query a MySQL table and return the results to the browser
> as an XML doc. What's the best way to do it?[/color]

You may want to try this class for generating generic XML documents:

http://www.phpclasses.org/xmlwriter

Then there are more mysql specific classes like these:

http://www.phpclasses.org/mysql_xml

http://www.phpclasses.org/jmysqlxml

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator

http://www.meta-language.net/metastorage.html

[Tony Marston]

Re: generating an XML doc from PHP?

Try this: http://www.tonymarston.co.uk/php-mysql/domxml.html which has the
title "Using PHP's DOM XML functions to create XML files from SQL data".

Tony Marston

http://www.tonymarston.net

"paul brown" <paul@paulbrown .net> wrote in message
news:gNRXb.1303 8$ZK6.3421@news svr29.news.prod igy.com...[color=blue]
> I've been looking up the in the documentation, but I can't seem to find
> what I'm looking for.
>
> I want to do query a MySQL table and return the results to the browser
> as an XML doc. What's the best way to do it?
>
> Thanks,
>
> Paul
>[/color]

[paul brown]

Re: generating an XML doc from PHP?

> "paul brown" <paul@paulbrown .net> wrote in message[color=blue]
> news:gNRXb.1303 8$ZK6.3421@news svr29.news.prod igy.com...
>[color=green]
>>I've been looking up the in the documentation, but I can't seem to find
>>what I'm looking for.
>>
>>I want to do query a MySQL table and return the results to the browser
>>as an XML doc. What's the best way to do it?
>>
>>Thanks,
>>
>>Paul
>>[/color]
>
>[/color]
Tony Marston wrote:[color=blue]
> Try this: http://www.tonymarston.co.uk/php-mysql/domxml.html which[/color]
has the[color=blue]
> title "Using PHP's DOM XML functions to create XML files from SQL data".
>
> Tony Marston
> http://www.tonymarston.net
>
>[/color]

I found your page right after I posted this request, and it's pretty
much what I was looking for.

Thanks,

Paul