update_code.php
844 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("update_code.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
if(strlen($data[0])>0){
//echo $data[0] . "<br />\n";
$mod_id = $setup->db->getOne("select id from catalogs_modifications where code=?",array(trim($data[0])));
if($mod_id>0){
print'<br />';
$fields_values = array('code'=>trim($data[1]));
print_r($fields_values);
print $data[0];print'<br />';
$r = $setup->db->autoExecute("catalogs_modifications",$fields_values,DB_AUTOQUERY_UPDATE,"id='".$mod_id."'");
if (PEAR::isError($r)) die($r->getMessage());
}
}
}
fclose($handle);
}
?>