XML Feeds - How do I use them?
Hi,
This is bit of an open question, and I'm not after any hidden tips and tricks from anyone, but I 'm totally fine with CSV data files, loading them into MySQL - creating pages with PHP etc, but now a lot of merchants are supplying XML feeds, sometimes instead of CSV files, but I have not got a clue what to do with them.
I don't think you can load XML into MySQL, unlike Oracle.
So I take it you have to have the basic XML file on your server and then parse it with PHP, but how do you search for say a distinct list of categories out of an XML feed, like you would on a DB?
In essence what is the best way to use an XML Feed?
Ta very much
Daniel
|