Page 1 of 1

XML to MySQL

Posted: Wed Sep 13, 2006 2:20 pm
by ionalia
Hiya guys,

I get data from my client in xml format (every day) and I need to store it to mysql ?
any hint or idea how to do this ?

I also need to build graph from this data

thanks




:D

Posted: Wed Sep 13, 2006 2:22 pm
by Luke
SimpleXML might help

Posted: Wed Sep 13, 2006 2:22 pm
by wtf
use mysql admin to upload data or any other mysql admin software. What sorts of graphs do you need?

Download odbc driver for mysql, fire up excel, connect to db, pull data in excel and make charts

Posted: Wed Sep 13, 2006 2:23 pm
by feyd
jpgraph.. and the manual has several systems for XML.. SimpleXML being one, http://php.net/ref.xml being another... and so forth...