View Full Version : XML Feeds
DarrenC
Sep 6th 2004, 10:54 pm
Okay, what is XML?
Now that you have answered that I'd like to know how difficult it is to set up a feed. What I have is a MySQL database which has data relating to clients holiday properties - I would like to be able to produce a feed of this data to load on other websites.
Also I'd like companies who have a large number of properties to submit be able to send the property details in an xml feed and then load this into the MySQL database.
Is this what XML can do, or am I on the wrong track? If not, how can I get say a text file to load into a MySQL database? Theres hundreds of fields, so it'll be a big file.
Any help?
Darren
Trance-formation
Sep 7th 2004, 12:59 am
I'm not sure, but I don't think you'll need an XML feed for this, just reading and writing to the database
See if this is of any use
http://webmonkey.wired.com/webmonkey/programming/php/tutorials/tutorial4.html
(hehe, and you like me obviously stumble straight out of bed and onto the computer :rolleyes: )
Are you saying you want a xml feed to show your holiday properties, which the data is stored in a mysql db?
This can be done using PHP.
DarrenC
Sep 7th 2004, 3:03 pm
Trance thanks - will check out the link!
hehe, and you like me obviously stumble straight out of bed and onto the computer Sad innit! hehe
XML - No, I have the properties in an mysql database which are listed in PHP on the website. What I would like to do is download all of the data on the mysql database and use this data to promote my clients properties on other websites.
I've been told that you can do this via an xml feed?
Darren :)
Trance-formation
Sep 7th 2004, 3:42 pm
XML - No, I have the properties in an mysql database which are listed in PHP on the website. What I would like to do is download all of the data on the mysql database and use this data to promote my clients properties on other websites.
I've been told that you can do this via an xml feed?
Darren :)
Ah... you want to be able to give other sites the option of displaying your content... so if my visitors might find it useful, I could display info about your clients properties on my sites? XML or RSS seem to be the way then, but my limited experiments with RSS simply showed me that I need to spend more time on the learning curve :confused:
Trance-formation
Sep 7th 2004, 10:56 pm
http://www.xml.org/xml/resources_cover.shtml
DarrenC
Sep 8th 2004, 1:30 pm
Thanks Adam.
I don't have time to learn, but I'll do some reading up! Any ideas how much it costs for this type of thing?
So you want to supply the data in your db, via XML feeds? (i suggest RSS).
I'm working on a tutorial atm, i'll link you once i'm done.
PHP Generating XML Documents (http://www.xmltraining.com/php-generating-xml-documents.html) tutorial. Its work in progress.
vBulletin® v3.6.8, Copyright ©2000-2008, Jelsoft Enterprises Ltd.