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.
PHP script to parse XML and insert into MYSQL
Moderator: General Moderators
Re: PHP script to parse XML and insert into MYSQL
Please use php simple xml dom. If you will post your code here, this will help us.