We need an XML file to be read and placed into a MySQL database. There is a single XML file that can contain multiple entries of each of the top elements. Flight_Records, Checkin_Counters, FIDS_Messages.
Each child element would have an associated field in the database within the tables described in the deliverable's below. A sample structure file has been attached. A file with more elements will be given to the successful Freelancer. Access to the MySQL database will be given, but I will need upload the file to the website for testing.
1. 3 MySQL tables - fidsFlightRecords, fidsCounterInfo, fidsMessages
2. PHP script to parse the XML file in the MySQL database tables.
3. MySQL table creation script for the above 3 tables
Please do not bid unless you fully understand the requirements. I am always happy to give more details as required. I have compared similar projects and would not expect it to be more than $80. Thanks.