rendered paste body 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('/<IMG SRC="\/Images\/Flags\/eur.gif" HSPACE="2" HEIGHT="20" WIDTH="30" alt=" ">\s*Euro\s*<\/TH>\s*<TD>\s*EUR\s*<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*(\d\d \d\d\d)<\/TD>\s*<TD [^<>]*>\s*(\d\d \d\d\d)<\/TD>\s*<\/TR>\s*<TR>\s*<TH>\s*<IMG SRC="\/Images\/Flags\/usd.gif" HSPACE="2" HEIGHT="20" WIDTH="30" alt=" ">\s*Dolarul SUA\s*<\/TH>\s*<TD>\s*USD\s*<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*\d\d \d\d\d<\/TD>\s*<TD>\s*(\d\d \d\d\d)<\/TD>\s*<TD [^<>]*>\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); } } } }