<?
$date="031121";
$filename="W3";
$filename.=$date;
$filename.=".log";
$con=mysql_connect('localhost','root','');
$db=mysql_select_db('proxy',$con);
$fp = fopen ($filename, "r" );
while (!feof ($fp)) {
$buffer = fgets($fp, 4096);
$info=explode(",",$buffer);
$user=ereg_replace("INTRASMAC","",$info[1]);
$moout=round(($info[13]/1024/1024),3);
$moin=round(($info[14]/1024/1024),3);
$sql="insert into proxy values ('','$date','$info[0]','$user','$info[5]','$moout','$moin','$info[15]','$info[18]')";
mysql_query($sql) or die(mysql_error());
if($a%100 ==0) echo " * ";
}
fclose ($fp);
echo'FIN'
?>
|