Parse XML nodes into mysql

slasher

slasher

slasher

Associate
Joined
18 Oct 2002
Posts
100
I'm trying to insert nodes into mysql

Trying to loop through each node & I think the foreach section is wrong

getting the info repeated

Thanks in advance

Code: 
<?xml version="1.0" encoding="UTF-8"?>
<GetCategorySpecificsResponse xmlns="urn:ebay:apis:eBLBaseComponents">
  <Timestamp>2012-09-18T02:06:29.309Z</Timestamp>
  <Ack>Success</Ack>
  <Version>791</Version>
  <Build>E791_INTL_BUNDLED_15330380_R1</Build>
  <Recommendations>
    <CategoryID>169291</CategoryID>
    <NameRecommendation>
      <Name>Material</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Artificial Leather</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Canvas</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Leather</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Brand</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MinValues>1</MinValues>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
      <ValueRecommendation>
        <Value>All Saints</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Ameko</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Bench</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Betty Boop</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Billabong</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Burberry</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Chanel</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Christian Dior</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Coach</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Coccinelle</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Dolce &amp; Gabbana</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>DU</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Dune</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>East</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Ed Hardy</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Faith</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>FCUK/French Conn.</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Fossil</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Francesco Biasia</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Gola</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Golunski</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Gucci</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Hello Kitty</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Hunter</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Irregular Choice</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Style</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>SelectionOnly</SelectionMode>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Backpacks</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Baguettes</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Belt, Hip Bags</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Briefcases</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Canvas Tote, Shopper</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Clutch Bags</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Evening Bags</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Handbag Accessories</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Messenger &amp; Cross Body</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Purses</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Satchels</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Shoulder Bags</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Totes</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Weekend Bags</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Type</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
        <Relationship>
          <ParentName>Style</ParentName>
        </Relationship>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Cartoon</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Canvas Tote, Shopper</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Charms</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Handbag Accessories</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Drawstring, Duffle</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Backpacks</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Handbag Hooks</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Handbag Accessories</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Handbag Organizers</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Handbag Accessories</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Key Finders</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Handbag Accessories</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Not Applicable</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Satchels</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Evening Bags</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Weekend Bags</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Baguettes</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Totes</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Messenger &amp; Cross Body</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Briefcases</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Shoulder Bags</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Purses</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Belt, Hip Bags</ParentValue>
          </Relationship>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Clutch Bags</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Novelty</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Backpacks</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Patterned</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Canvas Tote, Shopper</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Personalized</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Canvas Tote, Shopper</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Plain</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Canvas Tote, Shopper</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Single Strap</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Backpacks</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Two Strap</Value>
        <ValidationRules>
          <Relationship>
            <ParentName>Style</ParentName>
            <ParentValue>Backpacks</ParentValue>
          </Relationship>
        </ValidationRules>
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Handbag Size</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Very Small</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Small</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Medium</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Large</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Extra Large</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Main Colour</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>SelectionOnly</SelectionMode>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Beiges</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Blacks</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Blues</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Browns</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Greens</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Greys</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Ivories</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Metallics</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Multis</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Oranges</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Pinks</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Purples</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Reds</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Whites</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Yellows</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Exact Colour</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Anthracite</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Apricot</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Aubergine</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Azure</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Banana Yellow</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Bronze</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Caramel</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Caviar</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Chili</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Chocolate</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Claret-Red</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Cloud Blue</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Cobalt</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Coral</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Cream</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Cyan</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Ecru/Natural-Coloured</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Espresso</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Granite</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Green-Brown</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Grey Blue</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Indigo</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Khaki</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Lavender</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Light Blue</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Outer Material</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Beaded</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Canvas</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Cotton</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Crocodile Skin</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Denim</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Faux Leather</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Faux Suede</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Leather</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Metallic</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>PVC</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Patent Leather</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Satin</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Silk</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Suede</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Synthetic</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Exact Dimensions</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Closure</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Buckle</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Clasp</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Drawstring</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Flap</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Magnetic Snap</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Open Top, No Closure</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Zip</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Feature</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>30</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Adjustable Strap</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Detachable Strap</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Inner Dividers</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Inner Pockets</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Mobile Phone Pocket</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Outer Pockets</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
    <NameRecommendation>
      <Name>Pattern</Name>
      <ValidationRules>
        <ValueType>Text</ValueType>
        <MaxValues>1</MaxValues>
        <SelectionMode>FreeText</SelectionMode>
        <VariationSpecifics>Disabled</VariationSpecifics>
      </ValidationRules>
      <ValueRecommendation>
        <Value>Animal Print</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Checked</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Croc Print</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Floral</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>No Pattern</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Ostrich Print</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Quilted</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Sequined</Value>
        <ValidationRules />
      </ValueRecommendation>
      <ValueRecommendation>
        <Value>Snakeskin</Value>
        <ValidationRules />
      </ValueRecommendation>
    </NameRecommendation>
  </Recommendations>
</GetCategorySpecificsResponse>

PHP: 
<?php
		$responseDoc = new DomDocument();
		$responseDoc->loadXML($responseXml);
	
		
$Recommendations = $responseDoc->getElementsByTagName('Recommendations');
			$NameRecommendation = $responseDoc->getElementsByTagName('NameRecommendation');
			$ValueRecommendation = $responseDoc->getElementsByTagName('ValueRecommendation');
		
						
						foreach($Recommendations as $rec)
			{
					foreach($NameRecommendation as $cat)
			{
				foreach($ValueRecommendation as $val)
			{

				$CategoryID = $rec->getElementsByTagName('CategoryID');
					$Name = $cat->getElementsByTagName('Name');
				$Value = $val->getElementsByTagName('Value');
			 
		 
			 
			 $conn1 = mysql_connect("localhost", "user", "password");

if (!$conn1)  {
  die('Could not connect to update database at localhost: ' . mysql_error());
  }
mysql_select_db("test", $conn1);

foreach($CategoryID as $CategoryID) {
   $sqlz = sprintf(
        "INSERT INTO Specs (CategoryID, Name, Value) VALUES ('%s', '%s', '%s')",
				mysql_real_escape_string($rec->getElementsByTagName('CategoryID')->item(0)->nodeValue),
        mysql_real_escape_string($cat->getElementsByTagName('Name')->item(0)->nodeValue),
        mysql_real_escape_string($val->getElementsByTagName('Value')->item(0)->nodeValue)
				
		
    );
		echo  $sqlz;
		
			
		if (!mysql_query($sqlz,$conn1))
  {
  die('MYSQL Error' . mysql_error());
  }
	 
				
		}}}
					}
		}
	
		mysql_close($conn1);
	
?>
 
You must log in or register to reply here.
Back
Top Bottom