Peruttu

Load XML fily into MySQL table with PHP

I have an XML file with new entries on a daily basis (new entries are automatically added every day) The XML file currently has 1400 entries, I would like to take this XML file and upload its contents to a table i created on MySQL database. The table and XML file are already created.

I have started creating the PHP script, but i cannot figure out how to properly parse the xml file and insert the entries into the SQL database. Also It is important for the script to check for duplicates, since the xml file is updated daily i wouldn't want entries already on the database to be added again.

The script must be commented on its entirety in case future changes are needed. If you believe PHP is not the best solution for this please let me know im open to other solutions as well.

confidentially its very important!! Please keep in mind this is a very small project, only a few hours worth of work :D

Taidot: MySQL, PHP, XML

Näytä lisää: mysql load xml, php is, creating php table, im solutions, best php script, sql duplicates, open xml, load php, php script open file, php insert xml, php mysql load table, php load table, php script sql, xml mysql php script, check table mysql script, insert mysql table, script xml file sql, upload mysql, xml table contents, mysql check, sql script mysql, script load, php sql script project, upload xml, script sql table

About the Employer:
( 5 reviews ) Southampton, United States

Projektin tunnus: #1697253

8 freelanceria on tarjonnut keskimäärin 29 $/tunti tähän työhön

canlan318

Dear sir. i sent you a private message. Please check it. Regards.

$25 USD / tunti
(70 arvostelua)
6.8
VileGnosis

Details in PMB

$30 USD / tunti
(187 arvostelua)
6.8
waelfree

Hi, I can do that

$50 USD / tunti
(81 arvostelua)
6.7
sachin007007

Hello, I am a reliable PHP developer (my reviews and completion rate prove this). I'm very interested about the jobs and ready to start.Pls Check PM.Thanks for your time!

$30 USD / tunti
(16 arvostelua)
4.7
tauitdnmd

I can do this for you. pls check pm

$25 USD / tunti
(17 arvostelua)
4.3
lamlnq

Hi, I can handle this project for you and ensure can complete it with a few hours. Please check your PM for more details.

$25 USD / tunti
(11 arvostelua)
3.8
dharmeshs

Hi I have done xml parsing and code is ready. Can do it quickly for you! Please read PM.

$25 USD / tunti
(11 arvostelua)
2.7
firoz110

Hi, I am interested in working on this project. Please check PMB for more details.

$25 USD / tunti
(0 arvostelua)
0.0