Write a PHP script to import an XML file to MySQL database
- or -
Post a project like this4321
$$
- Posted:
- Proposals: 25
- Remote
- #146842
- Awarded
PHP (WordPress, Shopify, Squarespace, Woo-Commerce, Joomla, Magento, Laravel, Drupal, CakePHP, Codeigniter) + iOS/Android Developer
Chandigarh
Mobile App development | iPhone app development | Android app development | | MEANS| MERN| PHP| Node.js| MongoDB| Angular JS
Mumbai
9405849918310178305525303918284518273774226805226353223618200203185901
Description
Experience Level: Intermediate
I need a programmer familiar with importing XML into mysql to write a script to import a large XML datafeed file into a MySQL database.
The XML is a database of hotels from www.hotelscombined.com and you can download it here - http://downloads.hotelscombined.com/IndexFiles/HotelListXML.zip
You'll note this is a compressed file (around 15MB). Within that there is an XML index file which references a large number of hotel records - each hotel has its own XML file linked from the index file and the script you write needs to import each of these individual hotel XML files into the MySQL database.
The reason this needs to be a script is that the hotel database changes regularly so we need to be able to run an update and reimport data on a daily basis (for example using a cron job).
All fields from the individual XML files for each hotel need to be imported into the database - 1 hotel per row, 1 field per column.
I've suggested PHP to do this, although would be open to other solutions to achieve the same thing within reason if you can think of a better way!
Any questions please ask
Thanks
John
The XML is a database of hotels from www.hotelscombined.com and you can download it here - http://downloads.hotelscombined.com/IndexFiles/HotelListXML.zip
You'll note this is a compressed file (around 15MB). Within that there is an XML index file which references a large number of hotel records - each hotel has its own XML file linked from the index file and the script you write needs to import each of these individual hotel XML files into the MySQL database.
The reason this needs to be a script is that the hotel database changes regularly so we need to be able to run an update and reimport data on a daily basis (for example using a cron job).
All fields from the individual XML files for each hotel need to be imported into the database - 1 hotel per row, 1 field per column.
I've suggested PHP to do this, although would be open to other solutions to achieve the same thing within reason if you can think of a better way!
Any questions please ask
Thanks
John
John M.
98% (39)Projects Completed
59
Freelancers worked with
55
Projects awarded
47%
Last project
8 Jul 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies