Page 1 of 1

PHP script to parse XML and insert into MYSQL

Posted: Wed Aug 04, 2010 11:47 am
by splashz
Hello, I am very new to both PHP and MYSQL but I am eager to learn.

What I want to do is write a PHP script that will parse an XML file and insert the results into a MYSQL database. I've read a bunch of guides online and I think I have the parser structure down. I created a parser using xml_parser_create(). As I understand it, I need to create functions to handle each of the three events, startTag, endTag, and contents. This is where I am not sure what to do. What do I need to tell these functions to do when these events are triggered? I know I need to connect to the MYSQL database at some point but I do not know when.

If anyone could point me in the right direction, I'd appreciate it.

Re: PHP script to parse XML and insert into MYSQL

Posted: Thu Aug 05, 2010 11:33 am
by katierosy
Please use php simple xml dom. If you will post your code here, this will help us.