XML to MySQL PHP Script

ATLien · 02-25-2006, 12:18 PM

Does anyone know of a script that will convert a XML to a MySQL database?? I have tried http://www.navicat.com but it wont let me connect to the SQL I think my host has remote access blocked.

jwalsh · 02-27-2006, 08:17 AM

Most hosts will give you the option to allow access to remote hosts, but you need to turn it on first. Check your mysql settings in your control panel for Remote Access Connections.

[EDIT: Actually called "Access Hosts"]

Add your static IP, or a % wildcard. Of course remove the wildcard when you are done!

I know cpanel and exim both have this capability.

Josh

ATLien · 02-28-2006, 04:53 PM

I got remote access, but it is not working that well. I want to try and write a script, or find one that will take rss tags and convert then to MySQL code. i.e.

Code:

<movie title>40 Year Old Virgin</movie title>

and out put some MySQL code that looks like this:

Code:

INSERT INTO table_name ('movie title', column2,...) VALUES ('40 Year Old Virgin', value2,....)

I could write this script, I am just not sure how to open a file read the contents, and reorganize it.

kwvarga · 02-28-2006, 06:58 PM

I have not really messed around with XML, but check out
http://us3.php.net/domxml/

jwalsh · 02-28-2006, 08:44 PM

Using PHP5 or 4? If 5, SimpleXML (bundled with PHP5) makes it ... well... simple.

http://us2.php.net/manual/en/ref.simplexml.php

Not for advanced use, but should do exactly what you are trying to do.