Only add new information from XML to MySQL

Posted on 16th Feb 2014 07:03 pm by admin

What I am doing, is taking a xml file, and adding the values to a database. However, what I want to do is only add the new values.

I am guessing that a script that compared the first xx chars of the xml value to the value in the database would work best.

The script would be ran (in theory) once a day.

Example:

day1.xml
<fruits>
<fruit>apple</fruit>
<fruit>pear</fruit>
<fruit>orange</fruit>
</fruits>

day2.xml
<fruits>
<fruit>carrot</fruit>
<fruit>apple</fruit>
<fruit>pear</fruit>
<fruit>grape</fruit>
<fruit>orange</fruit>
</fruits>

Does anyone have any tips or code I could mooch off them?

Your Answer:

Login to answer

Other forums

How to Handle more than one submit button in single form?
Hi
I have one PHP file which contains one Form. In this form there are two Submit type Buttons

Problem with PHP code- simple contact form
Hi Folks,
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a co

Php mysql - select?
Hi i have this code:
Code: $iteminfo = mysql_query("SELECT desc FROM wc_items WHERE itemid =

Custom list order
Hi there,

I have checked this tutorial and it's great till the point where I want to display

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

Time-based image rotation script
I'm trying to write a PHP script that rotates an image based on what time of day it is. I want the

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var