MySQL Forums
Forum List  »  Other Migration

importing xml file to mysql
Posted by: Laura Schneiderman
Date: July 16, 2009 10:34AM

I have an xml file that takes the following format:

<markers>

<marker lat="" lng="" label="" age="" street="" neighborhood="" date="" race="" gender="" cause="" image="" height="" alt="" />

...

</markers>

I'd like to import this data into a mysql database, but I haven't seen an example of how to do that with a file structured in this way. Can you open the file, read in its contents, and load each value into a database with PHP? Is there a better way?

Options: ReplyQuote


Subject
Views
Written By
Posted
importing xml file to mysql
5871
July 16, 2009 10:34AM
3848
October 07, 2009 05:59AM
3178
December 11, 2009 03:09AM
5154
January 12, 2010 03:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.