Jump to content

Loading XML into MySQL (Label- Value)


siric

Recommended Posts

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

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 Golding
War and Peace - Leo Tolstoy
 
Will try the array.
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.