Newbie need help

[CCCam]

Newbie need help to put a simple xml as this to mysql with php.

 

Can someone show me an example how to do this. I just need a working example, what i found so far,doesnt help much for me.

 

Much appreciated!!!

 

 

<?xml version="1.0" encoding="UTF-8"?>

<database>

<select insert="animal" name="name" cateogry="category">

  <animal id="1">

  <name>snake</name>

  <category>reptile</category>

  </animal>

 

  <animal id="2">

    <name>frog</name>

    <category>amphibian</category>

  </animal>

 

  <animal id="3">

  <name>tuna</name>

  <category>fish</category>

  </animal>

 

  <animal id="4">

  <name>racoon</name>

  <category>mammal</category>

  </animal>

 

</select>

</database>

[wildteen88]

Am I right in guessing you want to parse the XML above and insert each item (<name> and <category>) into the database? You can parse XML easily with simpleXML <- click for examples and documentation on the use of simpleXML

 

If you're familiar with how to use MySQL with PHP you should be able to work out how to insert each item in to a MySQL database, once you have understood the basics of simpleXML.