$dbserver="localhost";
$dbuser="chenyingjie";
$dbpass="iriscyj";
$database="mntanalytics";
$dbc="";
$dbh="";
function mysqlconnect(){
global $dbserver, $dbuser, $dbpass, $database, $dbc, $dbh;
// connect to database
$dbc = mysql_connect($dbserver, $dbuser, $dbpass);
// or die (mysql_errno().": ".mysql_error()."
");
// select database
if ($dbc){
$dbh = mysql_select_db($database);
return true;
}else{
return false;
}
// or die (mysql_errno().": ".mysql_error()."
");
}
// this function closes the database
// returns nothing
function mysqlclose()
{
global $dbc;
// close the database connection
mysql_close($dbc)
or die (mysql_errno().": ".mysql_error()."
");
}
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Content-type: text/javascript");
mysqlconnect();
$host = addslashes(trim($_REQUEST["host"]));
$page = addslashes(trim($_REQUEST["page"]));
$sql = "select `clicks` from clicks where host='".$host."' and page='".$page."'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$result = (intval($row["clicks"]) + 1);
$sql = "replace into clicks (host, page, clicks) values ('".$host."','".$page."',$result)";
mysql_query($sql);
//$result = ereg_replace("\n", "", $result);
mysqlclose();
?>
document.write("");