Jump to content
Sign in to follow this  
siric

Loading XML into MySQL (Label- Value)

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

 

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

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.