Xml file into mysql database

Add a comment. Active Oldest Votes. Improve this answer. Jayanth Jayanth 4 4 silver badges 15 15 bronze badges. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta.

New post summary designs on greatest hits now, everywhere else eventually. Linked 2. The XML nodes are considered as the columns of the database table and so the data of each node are the values to be inserted into the table. In this example, I have an input. This input file is loaded to get the file handle object to parse the XML data. Then, the PHP code will iterate each of the parsed item to get its child node and its data.

This file contains 3 item XML elements with the child nodes title , link , description and keywords tags. 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. Archived Forums. Sign in to vote. User posted Hi All I want to insert data contained in a. Many thanks all Accelerator. Tuesday, August 7, PM. MapPath "test Write nodes[i]. InnerText ; Response.

Sunday, August 12, PM. User posted I don't think there are any standard products that lets you do this. Thursday, August 9, AM. Rgds Accelerator.