PHP Page to take xml file and upload to mysql database
$30-100 USD
Concluído
Publicado há mais de 15 anos
$30-100 USD
Pago na entrega
Code PHP page that will
1. Download XML file from a URL that I will provide
2. Take data downloaded from XML file and upload it to a mysql database
I have provided the following
1. A graphical mapping of the xml fields to the database
2. A copy of the mysql database
3. A copy of the xml file
Things to be aware of
1. The layout of the XML file allows for multiple elements for complete and owner sections.? However in realily this data can be flattened.? There will never be more then one owner or more then one record for complete
2. PHP page should run 'delete from table task' at the start of the page to clear the table
3. The notes and description elements may have characters that could cause the sql statements to fail.? Any invalid characters can just be removed on upload.? My sample xml file only has 23 records for task.? However I have a larger file that I will provide a winner that we want to check for invalid characters.
4. I have provide a sample of the xml file here but the actual project should be able to download that file from a url that I will provide.