Updating Stock from an XML feed

Code: Select all

	
	// get xml file contents
	$xml = simplexml_load_file($url);
	
	//update product db
	foreach ($xml->products->product as $product) {
				
	$query = "
	UPDATE product 
	SET `quantity` = '$product->stock'
	WHERE `product`.`sku` = '$product->code';
		";
	$result = mysql_unbuffered_query($query) or die ("Error in query: $query. ".mysql_error());
		}

Code: Select all

set_time_limit(0);

Code: Select all

<?php
	//error reporting 
	error_reporting(E_ALL);
	  
//connect to db
	$host = 'localhost';
	$user = 'root';
	$pass = '';
	$db = 'opencarttest';
	
	$connection = mysql_connect ($host, $user, $pass) or die
	        ("Error - Unable to Connect");
	
	mysql_select_db($db) or die ("Error- Unable to find database");
	
					
	// specify url of xml file
	$url = "http://example.com/example.xml";
		
	// get xml file contents
	$xml = simplexml_load_file($url);
	
	//clean temp table
	$query = "TRUNCATE stocktake;";
	$result = mysql_query($query) or die ("Error in truncate query: $query. ".mysql_error());
	
	//update product db
	foreach ($xml->products->product as $product) {
	$query = "
	INSERT INTO stocktake (sku, quantity)
	VALUES ('$product->code', '$product->stock')
			";
	$result = mysql_unbuffered_query($query) or die ("Error in query: $query. ".mysql_error());
		}
	//update product table
	$query = "
	UPDATE stocktake st, product p
	SET p.quantity = st.quantity
	WHERE p.sku = st.sku " 
	;
	$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
	
	//update options table
	$query = "
	UPDATE stocktake st, product_option_value p
	SET p.quantity = st.quantity
	WHERE p.sku = st.sku " 
	;
	$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

		//close connection
	mysql_close($connection);	
	
  ?>