for ($i=0;$i<=$count;$i++)
{$lines_in[$i]=~/^\s+\d+\s+(\d+)\s+(\D+\d)\s+(\W\d+\.\d+\.\d+\.\d+\/\d+)(\d+\.\d+\.\d+\.\d+).*$/;
$ac_ip=$4;
$ac_in=$1; #读取IP地址与总流量
......
#将流量记录输入至数据库
$sth = $dbh->do ("INSERT INTO $mysql_table_name
(date,ip,acc_in,acc_out,acc_in_ftp,acc_in_pop3,acc_in_www,acc_out _smtp)
VALUES ('$date','$ac_ip','$ac_in','$ac_out','
$ac_in_ftp','$ac_in_pop3','$ac_in_www','$ac_out_smtp')"); } |