XML -> HTML parse // How to -> MySQL?

[Wojtek]

XML Structure:

[...]
  <recipe>
    <recipename>Zucchini Dinner Rolls</recipename>
    <serves>24</serves>
    <keywords>Breads</keywords>
    <ingredients>
      <ingredient>
        <quantity>1</quantity>
        <unit>pkt</unit>
        <name>quick-rise yeast</name>
      </ingredient>
      <ingredient>
        <quantity>1</quantity>
        <unit>cup</unit>
        <name>warm water (120-130 degrees)</name>
      </ingredient>
      <ingredient>
        <quantity>1/4</quantity>
        <unit>cup</unit>
        <name>butter or margarine softened</name>
      </ingredient>
    </ingredients>
    <method>
        Place zucchini in a bowl; sprinkle with 1/2 teaspoon bla bla bla
    </method>
[...]

XML_Parser.php:

<?php
require("XMLConverter.class.php");

ob_start();
include("sample.xml");
$content=ob_get_contents();
ob_end_clean();

//Transform XML
$converter=new XMLConverter("taglib.tpl");
$content=$converter->parse($content);
$converter->destroyParser();

echo $content;

?>

REQUIRE ADDITIONNAL FILES ATTACHED AT BOTTOM OF THIS POST


The output is this: (XML_Parser.php)
http://www.cookingpages.com/cp/sample.php

Now, how would I modify all this so that each tag is seperated?
I want to transfer all those recipes into a MySql databse, but I need to break that down.

The last bit of XML_Parser.php:
echo $content;

I want to do this:

//DB Connect
Insert into DB ( recipename, servings, ingredients, method)

Any ideas how would I go to break this down?

Would I have to edit the function php files and add the database insert stuff there? I think so, however I'll need to make a bunch of IF's for each tag.
if recipename then insert into recipename
if ingredients insert into ingredients blablabla
not really effective no? Help


Thanks :wink2:

 

[nag]

i dont think that you have to put all the IF's for each tag , if your xml file contains the same format for each receipie it is not necessary try to look here

http://www.php.net/manual/en/ref.xml.php

there are some good examples which be useful for you

basically you need to change the code in the function doParse() in the XMLConverter.class.php

 

[Wojtek]

mhale from WHT helped me with PEAR and its working wonderfully now

Case Closed