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, parse table, php insert xml, php mysql load table, php load table, php script sql, xml mysql php script, check table mysql script, insert mysql table, parse php, script xml file sql, upload mysql, php parse xml table, xml table contents, mysql check, sql script mysql, script load

Tietoa työnantajasta:
( 5 arvostelua ) Southampton, United States

Projektin tunnus: #1697253

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


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

$25 USD / tunti
(70 arvostelua)

Details in PMB

$30 USD / tunti
(187 arvostelua)

Hi, I can do that

$50 USD / tunti
(81 arvostelua)

Hello, I am a reliable PHP developer (my reviews and completion rate prove this). I'm very interested about the jobs and ready to [url removed, login to view] Check [url removed, login to view] for your time!

$30 USD / tunti
(16 arvostelua)

I can do this for you. pls check pm

$25 USD / tunti
(17 arvostelua)

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)

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

$25 USD / tunti
(11 arvostelua)

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

$25 USD / tunti
(0 arvostelua)