Automatic Stock Updates from a Feed?

Code: Select all

$xml = file_get_contents("http://domain.com/file-that-you-want-to-get.xml"); // your file is in the string "$xml" now.
file_put_contents("/path_to_file/public_html/stock-today.xml", $xml); // now your xml file is saved.

sleep(200);

$con = mysql_connect("localhost","datebase_username","database_password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database_name", $con);


$url = "/path/to/file/public_html/stock-today.xml";
$xml = simplexml_load_file($url);

foreach($xml->Product as $Product)
{

mysql_query("UPDATE product SET quantity=$Product->Stock WHERE model=$Product->ProductID ");

}

mysql_close($con);

Code: Select all

<?php
 
$xml = file_get_contents("https://www.supplierwebsite.com.au/supplier-feed.xml");
file_put_contents("/home/project_folder/public_html/supplier-feed.xml", $xml);

sleep(10);

$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$db = 'database';

$con = mysql_connect($dbhost, $dbuser, $dbpass);

if (!$con) {
	die('Could not connect: ' . mysql_error());
}

mysql_select_db($db, $con);

$url = "https://www.mywebsite.com.au/supplier-feed.xml";
$xml = simplexml_load_file($url);

foreach($xml->product as $product) {
	mysql_query("UPDATE oc_product SET quantity = $product->PRODUCT_QUANTITY WHERE model=$product->MODEL");
}

mysql_close($con);

?>