function db_connect($server = DB_SERVER, $username = DB_USER, $password = DB_PASS, $database = DB_NAME, $link = 'db_link') {
global $$link;
if (USE_PCONNECT == 'true') {
$$link = mysql_pconnect($server, $username, $password);
} else {
$$link = mysql_connect($server, $username, $password);
}
if ($$link) mysql_select_db($database);
return $$link;
}
function db_array_to_mysql($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {
global $$link;
reset($data);
if ($action == 'insert') {
$query = 'insert into ' . $table . ' (';
while (list($columns, ) = each($data)) {
$query .= $columns . ', ';
}
$query = substr($query, 0, -2) . ') values (';
reset($data);
while (list(, $value) = each($data)) {
switch ((string)$value) {
case 'now()':
$query .= 'now(), ';
break;
case 'null':
$query .= 'null, ';
break;
default:
$query .= '\'' . addslashes($value) . '\', ';
break;
}
}
$query = substr($query, 0, -2) . ')';
} elseif ($action == 'update') {
$query = 'update ' . $table . ' set ';
while (list($columns, $value) = each($data)) {
switch ((string)$value) {
case 'now()':
$query .= $columns . ' = now(), ';
break;
case 'null':
$query .= $columns .= ' = null, ';
break;
default:
$query .= $columns . ' = \'' . addslashes($value) . '\', ';
break;
}
}
$query = substr($query, 0, -2) . ' where ' . $parameters;
}
return mysql_query($query, $$link);
}
/////////http://www.savechange.ru/index.php/////////
$_url = 'http://www.savechange.ru/savechange_c.php';
$ch = curl_init();
curl_setopt($ch, CURLOPT_POST,1);
curl_setopt($ch, CURLOPT_URL,$_url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
$content = curl_exec ($ch);
curl_close ($ch);
/////
unset ($cur_arr);
unset ($curs_arr);
////
$pattern="#(WM[A-Z] -> WM[A-Z]): rate=([\.0-9]*)#" ;
preg_match_all($pattern, $content, $cur_arr);
for($i=0;$i<count($cur_arr[0]);$i++)
{$wm=str_replace(" -> ","_",$cur_arr[1][$i]);
$sql_data_array[$wm]=$cur_arr[2][$i];
}
db_connect();
//добавляем данные
$sql_data_array['exchanger'] = 'savechange';
db_array_to_mysql('exchange', $sql_data_array);
//изменяем данные
db_array_to_mysql('exchange', $sql_data_array, 'update', "exchanger = 'savechange'");
