From XML to MySQL
Posted: Thu Aug 03, 2006 5:21 am
Hi, at my place where I work wants that every news produced from the central should be at the news section of the branches' website also.
I was using RSS or XML to retrieve the data and display them in the website, but the problem is, whenever XML was updated from the central, the archive is gone, and the user of our website can't see the archive, unless they should go to the main server in the central. But the central department doesn't want much traffic. What I mean with the archive is, when our user wants to view the news which was last week...they can't find one in our website.
I am a newbie in PHP world...so, which is better do you think of these possibilities ?
1. Load and save the XML files...and store all the XML files into the MYSQL Database...including the nodes ?
2. Retrieve the value of XML , and store only the VALUE from the XML into the MySQL Database, then display it.
Thanks for your reply.
Chris
I was using RSS or XML to retrieve the data and display them in the website, but the problem is, whenever XML was updated from the central, the archive is gone, and the user of our website can't see the archive, unless they should go to the main server in the central. But the central department doesn't want much traffic. What I mean with the archive is, when our user wants to view the news which was last week...they can't find one in our website.
I am a newbie in PHP world...so, which is better do you think of these possibilities ?
1. Load and save the XML files...and store all the XML files into the MYSQL Database...including the nodes ?
2. Retrieve the value of XML , and store only the VALUE from the XML into the MySQL Database, then display it.
Thanks for your reply.
Chris