function update_cv(){
$time = date("Y-m-d ",time());
$time .= "00:00:00";
$time = mysql_real_escape_string($time);
$sql = "select id from curs where date='$time'";
$query = mysql_query($sql);
if(!mysql_num_rows($query)){
$adress = 'http://www.bnro.ro/Ro/Info/';
$fstr = @file($adress);
if($fstr){
$cvpage_code = implode('', $fstr);
if(preg_match('/
\s*Euro\s*<\/TH>\s*
\s*EUR\s*<\/TD>\s* | \s*\d\d \d\d\d<\/TD>\s* | \s*\d\d \d\d\d<\/TD>\s* | \s*\d\d \d\d\d<\/TD>\s* | \s*(\d\d \d\d\d)<\/TD>\s* | ]*>\s*(\d\d \d\d\d)<\/TD>\s*<\/TR>\s* | \s*\s* \s*Dolarul SUA\s*<\/TH>\s* | \s*USD\s*<\/TD>\s* | \s*\d\d \d\d\d<\/TD>\s* | \s*\d\d \d\d\d<\/TD>\s* | \s*\d\d \d\d\d<\/TD>\s* | \s*(\d\d \d\d\d)<\/TD>\s* | ]*>\s*(\d\d \d\d\d)<\/TD>\s*<\/TR>/', $cvpage_code, $cvmatches)){
$euro = str_replace(' ', '', $cvmatches[2]);
$usd = str_replace(' ', '', $cvmatches[4]);
$euro = mysql_real_escape_string($euro);
$usd = mysql_real_escape_string($usd);
$sql = "insert into curs(`date`,euro,usd) values('$time','$euro','$usd')";
$query = mysql_query($sql);
}
}
}
} |