siric Posted June 17, 2017 Share Posted June 17, 2017 Hi, I have an XML file to load into MySQL, but it is generated with a label and a value instead of being fully qualified. So instead of <book> <name>Lord of the Flies</name> <author>William Golding</author> </book> <book> <name>War and Peace</name> <author>Leo Tolstoy</author> </book> It is like <book> <label>name</label> <value>Lord of the Flies</value> <label>author</label> <value>William Golding</value> </book> <book> <label>name</label> <value>War and Peace</value> <label>author</label> <value>Leo Tolstoy</value> </book> What would be the bext way to go about reading these into variables to push into a MySQL table? Thanks Steve Link to comment Share on other sites More sharing options...
Jacques1 Posted June 17, 2017 Share Posted June 17, 2017 Parse the XML, put the data into a more convenient structure (like an associative array), then use that new structure to pass the values to a prepared statement. Really simple. Link to comment Share on other sites More sharing options...
siric Posted June 17, 2017 Author Share Posted June 17, 2017 Was trying to edit the post to add my code so far - if ($books) { foreach ($books->book as $mybooks) { $label=$mybooks->Label; $value=$mybooks->Value; echo "$label - $value</br>"; } } so I get - Lord of the Flies - William GoldingWar and Peace - Leo Tolstoy Will try the array. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.