bannershow_w.php

来自「基于actionscript3.0的flashLoading控件」· PHP 代码 · 共 41 行

<?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 impressions  = impressions+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, impressions)
						VALUES(".$currentMonth.",".$currentYear.",".$bannerID.",1)";

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

$updateWeight	= "	UPDATE ad_weight
					SET counter  = counter+1
					WHERE banner_id = ".$bannerGroupID;

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

mysql_close($connection);

?>