/** * 更新给定日当天的访问数量 * @author bobbing * @version 0.1.0 * 2008-5-16 * $riqi 格式应如下20080516 * date('Ymd',time()-86400) * 取前一天的ymd格式 */ public static function jilucishu($riqi) { $file_name = "../log/" . 'processTime' . $riqi . ".log"; $fp = fopen($file_name, 'r'); $fwriqi = strtotime($riqi); $fwtongji = array(); while (!feof($fp)) { $buffer = fgets($fp, 4096); //echo $buffer."<br>"; $linshi = explode('|', $buffer); $userid = trim(str_replace('uid:', '', $linshi[7])); if ($userid == '') { } else { if (array_key_exists($userid, $fwtongji)) { $fwtongji[$userid] = $fwtongji[$userid] + 1; } else { $fwtongji[$userid] = 1; } } } foreach ($fwtongji as $key => $val) { $sql = "select count(id) from tpm_fwcishu where yh_id = '" . $key . "' and fw_riqi = " . $fwriqi; if (Watt_Db::getDb()->getOne($sql) <= 0) { $sql = "insert into tpm_fwcishu (yh_id,fw_cishu,fw_riqi,yh_zhanghu) values ('" . $key . "','" . $val . "'," . $fwriqi . ",'" . TpmYonghuPeer::getYhZhanghuByYhId($key) . "')"; Watt_Db::getDb()->execute($sql); } else { $sql = "update tpm_fwcishu set fw_cishu = '" . $val . "' where yh_id = '" . $key . "' and fw_riqi = " . $fwriqi; Watt_Db::getDb()->execute($sql); } } fclose($fp); }