On 12/11/2003 12:57 PM, Mark Roberts wrote:
I am about to embark on a project that requires me to access several mysql files (customer order entry), gather the information and output an XML formatted file that will be used as an input file to another accounting application.
Question is this. As a seasoned developer, my natural instinct is to just write a script(s) to access all the information that I need and write the appropriate information out to the file. Is there a better way to do this? Is there some type of application that has been developed that will take a select statement as input and automatically generate XML output?
That depends on how you query your database. There are classes for what you want that use different database API. Here you can find several of them:
http://www.phpclasses.org/browse.html/class/4.html
For generating generic XML with whatever data you retrieve, you may want to try this class:
http://www.phpclasses.org/xmlwriter
--
Regards, Manuel Lemos
Free ready to use OOP components written in PHP http://www.phpclasses.org/
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
