42868d70
 andryeyev
Создал GIT
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
<?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);
}
?>
|
