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?
utf8_general_ci error ??
I have all kinds of data to be inserted in database table//I am getting this errorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
setcookie and isset($_COOKIE(name)) seem very finnicky.
I'm currently playing around with a user system with login and registration. I'm trying to use cookies to log the user in but the cookie either doesn't set or it sets after I travel through a few
Multi-user card game
I'm writing a batch of games and such. Lottery is finished, Poker,blackjack,etc are next. They will be multi-user. I've got the multi-deck shoe and dealing table done and other parts rough coded. What
Reading Most Recent CSV File in Directory
I thought I had wrapped this project up, but found out that the program I use to FTP a csv file to my website is best used in time stamp mode. That is, each day a newly named csv file is uploaded with
Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the username of the person and a avatar type thing. When the script tries to send the avatar image to
Modal Popup Help
Hi guys, I have a modal popup with an iframe. How can i send data from a label or textbox to the iframe without code behind?
Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What fields should go to sql table, after username and password? How to keep data in cookies safely? And
Problem with array max size.
Hi to everyone,
Undefined Variable: PHP_SELF, pls help
Hi,Im a newbie on PHP / MySQL programming and Im running a script to search one field on my DB table. The results will show after I key in my search word but there's an error below that says:
Problem with a select distinct
I have a problema with a select distinct, I have the next sql: