How to insert xml file into mysql database in php

See more: C. Plz Provide m some code or any idea Copy Code. Posted Aug pm Member Add a Solution. Accept Solution Reject Solution. You can store the xml contents as text. This way, your table data will be nvarchar max and you will read the file as a standard text file: C. Posted Aug pm MCY. Add your solution here.

OK Paste as. As the child nodes are treated as the columns of the database table, I have created the database table columns with the name of these child nodes. While parsing this input XML the data inside these child nodes will be inserted into the database to the appropriate column.

Using this file handle the XML items will be start iterated to read the child nodes. After inserting the data, a message will be shown to the user about how many rows are newly added into the database. How to do that thanks. Friday, 22 September Email This BlogThis! Share to Twitter Share to Facebook. Newer Post Older Post Home. Gautham 8 January at Add a comment. Active Oldest Votes. Improve this answer.

Hi RobMullins, the xml is generated dynamically. You should really structure your XML better. Since you cannot, I will update the answer Please let me know if you have any questions about this. Thanku Rob Mullins. Show 1 more comment.

Assuming you have multiple customers Vladimir Ramik Vladimir Ramik 1, 2 2 gold badges 11 11 silver badges 23 23 bronze badges.