CODEWITHSUNDEEP
phpmysqlxmldatabasestorage
max_
max_

Reputation: 24481

Saving XML File to Database Every Week

I am downloading the same XML file every-week when the XML file is updated. However I would like to know how I could store this file weekly in a MySQL database.

A sample RSS feed is: http://itunes.apple.com/us/rss/topalbums/limit=10/xml

My Database scheme is:

link    text    utf8_unicode_ci                                      
name    text    utf8_unicode_ci                                      
type    text    utf8_unicode_ci                              
category    text    utf8_unicode_ci                                      
categorylink    text    utf8_unicode_ci                                      
artistlink  text    utf8_unicode_ci                                      
price   text    utf8_unicode_ci                                      
image55 text    utf8_unicode_ci                                      
image60 text    utf8_unicode_ci                      
image170    text    utf8_unicode_ci
rights  text    utf8_unicode_ci
itemcount   text    utf8_unicode_ci

Upvotes: 0

Views: 341

Answers (1)

BenM
BenM

Reputation: 53198

Set up a cron job:

http://en.wikipedia.org/wiki/Cron

Upvotes: 1

Related Questions