Whats the best way to generate a XML output of a MySQL database using PHP

Question

A bit on my requirements, at the moment i'm passing on a search string from a Cocoa app to a PHP script which queries the database, and then generates an XML output for Cocoa again.

The only bit I am having issues with now is generating the XML output from the db query.

At the moment, i'm trying to loop through the results and output them, however I am having issues, I can create the XML file but it doesn't get the results from the loop.

I can post my code if needed, but I'm sure somebody will have a more effective method.

Gordon · Accepted Answer · 2011-11-16 11:22:39Z

2

Do not use PHP at all for the XML generation. MySQL can do that. If the XML in a specific format you can use XSLT, but at that point it may be easier to use PHP instead.

edited Nov 16, 2011 at 11:22

Gordon

318k76 gold badges548 silver badges566 bronze badges

answered May 18, 2010 at 19:14

Artefacto

98.1k17 gold badges207 silver badges230 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

S1syphus Over a year ago

Ideally I would, but I'm it's from a client app using search string, however I did see something about using XPath from a PHP script that looks promising.

Collectives™ on Stack Overflow

Whats the best way to generate a XML output of a MySQL database using PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related