[bukatin]

Hi,

I bet you guys can help me on this. I don't know how to handle xml files. Here's the scenario, I have XML file, i want that each data from my xml file will be inserted into my database. How can I do that?

[marinus]

Solution.

When you get the data that you want in XML send it to SQL Server

VIA your requirement , i would put an insertcommand in a loop .

With each iteration through the XML File I would send it to specific field

in the database

Not so hard is it.

This post has been edited by marinus: 03 March 2011 - 02:34 AM

[keakTheGEEK]

Most modern DBMSs have built in features to handle xml data. Depending on what database you are using, you should look into that. I know MS Sql Server 2005 and up has an xml data type. You could pass the contents of the xml file to a stored procedure and insert the data that way...

[bukatin]

thanks... I'm using PHP and My Sql. Anyone can give me sample functions or class on this?

[JackOfAllTrades]

I'm going to move this to PHP, because that's probably the best place for it.

Have you mapped your XML schema to a database table? If you provide some example data and code, we can help.

[VolcomMky]

I would suggest using

htmlentities($xmlData,ENT_QUOTES)

And then html_entity_decode when you retrieve it from the database.