Solved

Importing XML Feed to a Mysql Database/table

Posted on 2011-03-08
1
603 Views
Last Modified: 2012-05-11
Hello Folks,

I am looking for some information to would educate me on how one would go about downloading and inserting .xml data feeds into a mysql database.
Currently I know nothing about the method and would like to learn. the way in which the feeds are available to me is via a url.

e.g: http:mysite.com/mycategory/feedname.xml


Thanks in advance
0
Comment
Question by:greeneel
1 Comment
 
LVL 4

Accepted Solution

by:
gizmola earned 500 total points
ID: 35073809
This is a great summary article of the subject.  http://rpbouman.blogspot.com/2006/03/importing-xml-data-into-mysql-using.html

A more flexible solution is to use some sort of scripting language (PHP is a popular one) that comes with xml parsing routines, to read in the xml file, parse it and insert the data into one or more tables that match the implied structure of the xml.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question