What is the best way to generate MySQL database XML output using PHP
Slightly on my requirements, at this point I am passing a search string from a Cocoa application to a PHP script that queries the database and then generates XML output for Cocoa again.
The only bit I'm currently running into is generating XML output from the db request.
At the moment I am trying to view the results and output them, however I am having problems, I can create an XML file, but it is not getting the results from the loop.
I can post my code if needed, but I'm sure someone will have a more efficient method.
+2
a source to share
1 answer
Don't use PHP at all to generate XML. MySQL can do this . If the XML is in a specific format you can use XSLT , but at this point it might be easier to use PHP.
+2
a source to share