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
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 & 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 & 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 & 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);
?>