PHP script to parse XML and insert into MYSQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
splashz
Forum Newbie
Posts: 2
Joined: Wed Aug 04, 2010 11:29 am

PHP script to parse XML and insert into MYSQL

Post 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.
katierosy
Forum Commoner
Posts: 27
Joined: Wed Apr 07, 2010 8:39 am

Re: PHP script to parse XML and insert into MYSQL

Post by katierosy »

Please use php simple xml dom. If you will post your code here, this will help us.
Post Reply