In Progress

import easy XML file to mysql using PHP

I need a basic script to import information from xml files to a mysql database.

I will create the database table and structure, I just need it updated when a new xml file appears. I will be running this script from a cron job. It will parse the use the script to parse and import the xml data to the mysql database and then the cron job will move the file out.

Note:

1) I can handle the cron job, I just need help with the PHP script.

2) The xml files will contain both new table entries as well as changes to existing entries. The field "unique ID" is to be the table's key unique field.

3) I need this done ASAP, please only quote if you can start this wihtin hours of quoting, it should not be a big job.

4) I have purposely made the examples below simplified so that the job is done quickly. I will then take your coding and modify it to work with the full "REAXML" format myself as I am pretty good with PHP.

Here is an example of an xml file with two new entries:

<propertyList date="2009-01-01-12:30:00" username="xmluser" password="xmlpassword">

<!-- FIRST NEW ENTRY EXAMPLE-->

<residential modTime="2009-01-01-12:30:00" status="current">

<uniqueID>ABCD1234</uniqueID>

<price display="yes">500000</price>

<headline>SHOW STOPPER!!!</headline>

<images>

<img id="m" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

<img id="a" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

<img id="b" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

<img id="c" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

</images>

</residential>

<!-- SECOND NEW ENTRY EXAMPLE-->

<residential modTime="2009-01-01-12:30:00" status="current">

<uniqueID>EFGH2345</uniqueID>

<price display="yes">700000</price>

<headline>Really Good Property!!!</headline>

<images>

<img id="m" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

<img id="a" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

<img id="b" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

<img id="c" modTime="2009-01-01-12:30:00" url="[url removed, login to view]" format="jpg"/>

</images>

</residential>

</propertyList>

Here is an example of an xml file with one ammendment to an existing entry:

<propertyList date="2009-01-01-12:30:00" username="xmluser" password="xmlpassword">

<!-- EXAMPLE OF UPDATE TO EXISTING ENTRY -->

<residential modTime="2009-01-01-12:30:00" status="withdrawn">

<agentID>XNWXNW</agentID>

<uniqueID>ABCD1234</uniqueID>

<soldDetails>

<price display="yes">480000</price>

<date>2009-01-10-12:30:00</date>

</soldDetails>

</residential>

</propertyList>

Please quote asap.

Skills: MySQL, PHP

See more: import xml mysql php, import xml file mysql, php import xml mysql, mysql import xml file, import xml mysql, php import xml, import xml mysql example, php mysql import xml, import mysql xml, xml import mysql php, mysql script import xml, format uniqueid import, cron import xml mysql, xml mysql php, php xml import mysql, xml import php mysql, mysql import xml, mysql xml import php, table data structure, property id, price file, key data structure, job quote example, examples data structure

About the Employer:
( 23 reviews ) Australia Fair, Australia

Project ID: #1128271

Awarded to:

yunussaha

ready to start. please check pmb.

$50 AUD in 1 day
(84 Reviews)
6.6

7 freelancers are bidding on average $82 for this job

toinnisfree

quick pro help. ftp and escrow required.

$77 AUD in 1 day
(520 Reviews)
7.8
jqMike

Can be done. Please contact me.

$150 AUD in 0 days
(58 Reviews)
6.7
dracco

hello, I'm really interested in your project and I can do this script in a short time, I have a lot of experience and I would like work with you in this project. Do you have the structure of your table so, it will be More

$40 AUD in 0 days
(128 Reviews)
5.8
gangabass

I can do this for you. See PM for details.

$40 AUD in 0 days
(107 Reviews)
5.7
tooltor

Expert programer here, please read the private message.

$50 AUD in 2 days
(17 Reviews)
3.8
RossKim

Let me start this ASAP

$70 AUD in 1 day
(8 Reviews)
3.8
rickysingh904

HELLO SIR ! we are her to help you in your project, we have well experienced PHP developers in our team. just have an experience to work with us. thanx!!!!!!!

$210 AUD in 4 days
(0 Reviews)
0.0
ooboo

Pay me after the work, I can do it I am a freelancer. Regards Jeohan

$80 AUD in 2 days
(0 Reviews)
0.0