I'm working on a project using PHP, XML, and possibly MySQL, and wanted to run the scenario by everyone and get some feedback.
We want to store all of our marketing information in XML documents so we can publish our website, PDF files, and printed marketing materials from once source of documents.
Here's the tricky part: we set up partner websites for a few of our partners, and each one has the same site as ours, minus some of the products from their competitors. Our site has 10 products listed, partner one may have 6 products listed, partner 2 has 8 products listed, etc. Right now we have 10 different websites all using static webpages (YIKES!). I've made other sites that generate content on the fly from a MySQL db, but here at the new job, we need to put our content into XML.
The question revolves specifically around the use of XML and the MySQL db. Should we load the XML file straight into the db, or reference the XML from the db? I'm pretty sure we want each page will come from a separate XML document, as PHP parses the entire XML document, right? No sense in having all 10 pages in one document if it will take 10 times as long to parse it, correct?
Thanks for any help, comments, and suggestions!
Tom
We want to store all of our marketing information in XML documents so we can publish our website, PDF files, and printed marketing materials from once source of documents.
Here's the tricky part: we set up partner websites for a few of our partners, and each one has the same site as ours, minus some of the products from their competitors. Our site has 10 products listed, partner one may have 6 products listed, partner 2 has 8 products listed, etc. Right now we have 10 different websites all using static webpages (YIKES!). I've made other sites that generate content on the fly from a MySQL db, but here at the new job, we need to put our content into XML.
The question revolves specifically around the use of XML and the MySQL db. Should we load the XML file straight into the db, or reference the XML from the db? I'm pretty sure we want each page will come from a separate XML document, as PHP parses the entire XML document, right? No sense in having all 10 pages in one document if it will take 10 times as long to parse it, correct?
Thanks for any help, comments, and suggestions!
Tom