All pastes #75770 Raw Edit

Mine

public php v1 · immutable
#75770 ·published 2006-06-30 15:25 UTC
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);												}			}		}	}