Here is the structure of the exported file XML that need to be insert in 2 different MySQL table
Dates Client Name Service Address City State Zip Resources Budgeted Hours Actual Hours Amount Actual $/Man Hr Bdgt $/Man Hr Status
ALL the information in this XML need to be inserted in two differents tables and columns.
So i got a table for CUSTOMER and another for SERVICES
So exemple, table CUSTOMER will grab and insert all value of the XML colums CLIENT NAME into the column of Mysql table NAME
And the other table SERVICES, should grab and insert Dates, service, address, city, state, zip, resources, budgeted hour, actuals hour, amount, and all the rest
So, i need someone can import me all the columns of this XML export, into 2 MySQL table, depending wich XML column.
30 freelancers are bidding on average $37 for this job
Hi I can write this PHP script to read a XML and store data in a MySQL DB in 2 tables Please be sure to check my Bid price. Habilidades y experiencia relevante MySQL, XML, PHP Htos propuestos $100 CAD - Happy Client
It`s one time job or you will need something for regulary importing? Could you show example of your xml? Relevant Skills and Experience php, mysql Proposed Milestones $111 CAD - Milestone 1