bannerclick.php

基于actionscript3.0的flashLoading控件

<?php

$bannerID = $_POST["bannerID"];

require '../banner_admin/config.php';

$connection = mysql_connect($DBhost,$DBuser,$DBpass) or die("Couldn't make connection: ". mysql_error());
$db = mysql_select_db("$DBName", $connection) or die("Couldn't select database: ". mysql_error());

$currentMonth = date("m");
$currentYear = date("Y");

$selectCounter = "	SELECT * FROM ad_counters
					WHERE month = ".$currentMonth." AND year = ".$currentYear." AND campaign_id = ".$bannerID;

$result = mysql_query($selectCounter,$connection) or die("Couldn't execute query: ". mysql_error());

$numR = mysql_num_rows($result);
if($numR > 0) {
	$updateCounter = "	UPDATE ad_counters
						SET clicks = clicks+1
						WHERE month = ".$currentMonth." AND year = ".$currentYear." AND campaign_id = ".$bannerID;

	mysql_query($updateCounter,$connection) or die("Couldn't execute query: ". mysql_error());
} else {
	$insertCounter = "	INSERT ad_counters(month, year, campaign_id, clicks)
						VALUES(".$currentMonth.",".$currentYear.",".$bannerID.",1)";

	mysql_query($insertCounter,$connection) or die("Couldn't execute query: ". mysql_error());
}

mysql_close($connection);

?>