pagelink.php

ajax打造的动态计数器

<?php
	require_once('conn.php');
	if($_POST)
	{
		$url = $_POST['url'];
		$visited = $_POST['visited'];
		$cookie = $_POST['cookie'];
	}
	else
	{
		$url = $_GET['url'];
		$visited = $_GET['visited'];
		$cookie = $_POST['cookie'];
	}
	
	$ip = $_SERVER['REMOTE_ADDR'] ; //get the client ip address
	$info= $_SERVER['HTTP_USER_AGENT'];//get browser as os infomation
	//$info ='Mozilla/4.0 (compatible; MSIE 4.0; MSIECrawler; WinNT)';
	
	$oslang = substr($info,strpos($info,'(')+1,strpos($info,')')-strpos($info,'(')-1); //get the os and lang string chunk
	
	$other = explode(" ",$info);
	
	$browsers = array();
	
	for($i=0;$i<count($other);$i++)
	{
		if(strpos($other[$i],'/')>0) // push key/version to other array for mozilla browser infomation
		{ 
			$tmp = explode("/",$other[$i]);
			$browsers[$tmp[0]] = $tmp[1];
		}
	}
	unset($other);
	foreach($browsers as $i=>$value) //enum the browser info ,$b the browser name, $ver the version of client brwoser
	{
		switch($i)
		{
			case 'Firefox':
				$b = 'Firefox';
				$ver = $browsers[$i];
				break;
			case 'Opera':
				$b = 'Opera';
				$ver = $browsers[$i] ;
				break;
			case 'SeaMonkey':
				$b = 'SeaMonkey';
				$ver = $browsers[$i];
				break;
			default:
				$b = 'unknown';
				$ver = 'unknown';
				break;
		}
		if($i=='Gecko')  
		{
			$gecko = true;
			$gecver = $browsers[$i];
		}
		else
		{
			if(strpos($info,'MSIE')>0 || strpos($info,'MSPIE')>0)
			{
				$b = 'Internet Explorer';
				$sta = strpos($info,'IE')+2;
				$ver= floatval(substr($info,$sta));
			}
		}
	}
	unset($browsers);
	
	$oss = array('linux','unix','windows','mac','winnt');

	for($i=0;$i<count($oss);$i++) //get system infomation from the os and lang string , maybe not exactly
	{
		if(strpos(strtolower($oslang),$oss[$i])>0) 
		{
			$os = strtoupper($oss[$i]); //get the OS 
			break;
		}
	}
	
	if($gecko)
	{
		$gecko = 'true'; //for addtional use
	}
	
	if(strlen($url)>4)
	{
		
		if($visited != 1)
		{	
			$num = 0;
			if($cookie!=1)
			{
				$sql = 'select count(`file`) as tim from '.PAGETBL.' where `file`=\''.$url.'\' and  DAYOFMONTH(`visit_time`)='.intval(date('d')).' and ip=\''.$ip.'\'';
				//echo $sql;
				//exit;
				$rs = @mysql_query($sql);
				if($times = @mysql_fetch_assoc($rs))
				{
					$num = $times['tim'];
				}
			}
			//echo $num;
			//echo '.....'.($num ==0);
			//exit;
			if($num == 0 )
			{
				$sql = 'insert into '.PAGETBL.'(`file`,`os`,`browser`,`browVer`,`ip`) values(\''.$url.'\',\''.$os.'\',\''.$b.'\',\''.$ver.'\',\''.$ip.'\')';
				//echo '>>>>>>'.$visited.'<<<<';
				@mysql_query($sql,$dbs);
			}
		}
		
		$sql = 'select count(file) from '.PAGETBL.' where `file`=\''.$url.'\'';

		$rs = @mysql_query($sql,$dbs) or die('Error No.:'.mysql_errno());
		if($tim = mysql_fetch_array($rs))
		{
			echo $tim[0];
		}
		@mysql_close($dbs);
	}
	else
	{
		echo 'Platform:'.$os;
		echo '<br />';
		echo 'Your Ip Address:'.$ip;
		echo '<br />';
		echo 'Your Browser:'.$b;
		echo ' (Version:';
		echo $ver;
		echo ')';
	}

?>