<?php
$con = mysql_connect("","","");
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_select_db("update", $con);
$xml = simplexml_load_file('XMLProductFeed.xml');
foreach($xml->product as $product){
//<name>
$xmlName = htmlentities(($product->name), ENT_QUOTES, 'UTF-8');
$fieldName = trim(html_entity_decode($xmlName));
//<productEvent>
$fieldEvent = $product->productEvent;
//<priceMinimal>
$fieldpriceMinimal = htmlentities($product->priceMinimal, ENT_QUOTES, 'UTF-8');
mysql_query ("SELECT * FROM ticket WHERE event='$fieldEvent'");
if ($fieldEvent == NULL) {
mysql_query ("INSERT INTO ticket (
name,event,priceMinimal)VALUES (
'$fieldName','$fieldEvent','$fieldpriceMinimal'");
}else{
mysql_query("UPDATE ticket SET
name = '$fieldName',
priceMinimal = '$fieldpriceMinimal'
WHERE event = '$fieldEvent'");
}
}
mysql_close($con);
?>
697 views
knop om je tekst aan te passen.