Hi,
How do I go about creating a XML document from information requested from multiple tables ?
Do I need to split the queries up or can I just run it as one complete query ?
Then how do I set it up so that information is output into an XML file like so:
JobPost
Job Name
Job Sector
Job Description
Job Location
Job Type
Company Name
JobPost
Any help much appreciated....
Thanks
You can query the database, and build the XML just as you would HTML. That is the easiest way to do it.
You can also use one of the XML parsers such as SimpleXML to build your XML object and retrieve the XML output string when done.
http://php.net/manual/en/book.simplexml.php
With SimpleXML the output string is retrieved using asXML(); http://www.php.net/manual/en/simplexmlelement.asXML.php
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.