sale_zima.php
940 Bytes
<?php
set_time_limit(0);
$_SERVER['DOCUMENT_ROOT'] = realpath(dirname(__FILE__)."/..");
require($_SERVER['DOCUMENT_ROOT'] . "/libs/setup.php");
$setup = new setup();
if (($handle = fopen("sale_zima.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
if(strlen($data[0])>0){
//echo $data[0] . "<br />\n";
$product_id = $setup->db->getOne("select product_id from catalogs_modifications where code=?",array(trim($data[0])));
$setup->db->autoExecute("catalogs_products",array('salepc'=>10),DB_AUTOQUERY_UPDATE,"id='".$product_id."'");
print'<br />';
$fields_values = array('sale'=>10);
print_r($fields_values);
print $data[0];print'<br />';
$r = $setup->db->autoExecute("catalogs_modifications",$fields_values,DB_AUTOQUERY_UPDATE,"code='".trim($data[0])."'");
if (PEAR::isError($r)) die($r->getMessage());
}
}
fclose($handle);
}
?>