Our company operates an online hotel reservation service. The system is a PHP / MySQL application. One of the tables of the DB holds the list of customers with all the relevant information. We need to develop the following functionality:
- from the database in our site an XML file needs to be generated and made available to all the websites that require this information.
- any webmaster who wishes to use this data should be provided by us with some code (to be copied and pasted into a new page of the receiving website) so that the list of hotels (updated on a daily basis) is always complete.
To better explain: all these hotels belong to a chain. Each hotel has its own website that may be static or dynamic. On each one of the websites there is the need to have a page with the directory of all of the hotels belonging to the chain. This list is modified 3 to 4 times a week. Each hotel has its own webmaster. These webmaster may or may be not proficient in using external data sources. We need to be able to provide a document with an easy way for them to generate the new page within the hotel's website containing the updated list of hotels belonging to the chain.