[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
[Fri Oct 29 16:17:46.356 2010] 0.500 sec [ext/3/expr 764 (0,20)] [idxmain] 海绵宝宝
另外需要一个将 Fri Oct 29 16:17:46.356 2010 这样的值转化为 UNIX时间戳的函数。
<?php
//你要把那个精确到毫秒的去掉先
echo strtotime("Fri Oct 29 16:17:46 2010");
//输出:1288340266
?>
我觉得还是存入到数据库里面,然后通过SQL语句来取比较好些。
echo '<pre>';
$data=file_get_contents('query.log');$dataarray=explode('[idxmain]',$data);
echo $dataarray;
exit;
$str='';
foreach($dataarray as $key=>$val){
if($key==0){
$str.=substr($val,strpos($val,'[')+1,28).',';
}elseif($key>=1){
$str.=substr($val,0,strpos($val,'[')).',';
$str.=substr($val,strpos($val,'[')+1,28).',';
}
}
$keyword='';
$array=explode(',',$str);
$i=0;
$j=0;
foreach($array as $key=>$val){
if($val!=''){
$keyword.=trim($val);
if($j==$i){
$keyword.=',';
}
$j++;
}
$i++;
}
$wordarray=explode(',',$keyword);
$new_array =array_count_values($wordarray);
print_r($new_array);
echo '</pre>';
?>