📄 campaign_stats.php
字号:
<?php
session_start();
header("Cache-control: private");
$banner_id = $_POST["banner_id"];
$company_id = $_POST["company_id"];
$campaign_id = $_POST["campaign_id"];
$from_month = $_POST["from_month"];
$from_year = $_POST["from_year"];
$to_month = $_POST["to_month"];
$to_year = $_POST["to_year"];
require 'config.php';
if($_SESSION['username'] == $admin_username && $_SESSION['password'] == $admin_password) {
$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());
$monthArray = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
if(strlen($from_month)<=0) {
$from_month = date("n");
$from_year = date("Y");
}
print '<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Banner Statistics</title>
<link href="banner_styles.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2">
function submitSearch() {
document.forms["stats_form"].submit();
}
</script>
</head>
<body marginheight="30" topmargin="30">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#ACC366" bgcolor="#2C78C5">
<tr bgcolor="#ACC366">
<td width="872" bgcolor="#ACC366"><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#ACC366">
<tr>
<td><span class="heading">Banner Statistics</span></td>
</tr>
</table> </td>
</tr>
<tr valign="top">
<td><table width="100%" border="1" cellpadding="10" cellspacing="0" bordercolor="#ACC366">
<form name="stats_form" action="campaign_stats.php" method="POST">
<tr bgcolor="#2C78C5">
<td colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing = "0"><tr>
<td width="120"><span class="bodytext">Banner Group</span></td>
<td width="150"><span class="style1"><span class="bodytext">';
if($banner_id != "") {
$query = " SELECT banner_name
FROM ad_banners
WHERE id = ".$banner_id;
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
if($row = mysql_fetch_array($result)){
$bannerName = $row['banner_name'];
print '<select size="1" name="banner_id" class="formtext">
<option value="'.$banner_id.'">'.$bannerName.'</option>
<option value="">ALL</option>';
}
} else {
print '<select size="1" name="banner_id" class="formtext">
<option value="">ALL</option>';
}
$query = " SELECT id, banner_name
FROM ad_banners
ORDER BY banner_name";
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
while($row = mysql_fetch_array($result)){
$bannerID = $row['id'];
$bannerName = $row['banner_name'];
print '<option value="'.$bannerID.'">'.$bannerName.'</option>';
}
print '</select></span></span></td></tr></table></td>
<td colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing = "0"><tr>
<td width="100"><span class="bodytext">Advertiser</span></td>
<td width="150"><span class="bodytext">';
if($company_id != "") {
$query = " SELECT company_name
FROM ad_companies
WHERE id = ".$company_id;
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
if($row = mysql_fetch_array($result)){
$companyName = $row['company_name'];
print '<select size="1" name="company_id" class="formtext">
<option value="'.$company_id.'">'.$companyName.'</option>
<option value="">ALL</option>';
}
} else {
print '<select size="1" name="company_id" class="formtext">
<option value="">ALL</option>';
}
$query = " SELECT id, company_name
FROM ad_companies
ORDER BY company_name";
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
while($row = mysql_fetch_array($result)){
$companyID = $row['id'];
$companyName = $row['company_name'];
print '<option value="'.$companyID.'">'.$companyName.'</option>';
}
print '</select></span></td></tr></table></td>
<td colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing = "0"><tr>
<td width="100"><span class="bodytext">Banner</span></td>
<td><span class="style1"><span class="bodytext">';
if($campaign_id != "") {
$query = " SELECT name
FROM ad_campaigns
WHERE id = ".$campaign_id;
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
if($row = mysql_fetch_array($result)){
$campaignName = $row['name'];
print '<select size="1" name="campaign_id" class="formtext">
<option value="'.$campaign_id.'">'.$campaignName.'</option>
<option value="">ALL</option>';
}
} else {
print '<select size="1" name="campaign_id" class="formtext">
<option value="">ALL</option>';
}
$query = " SELECT id, name
FROM ad_campaigns
ORDER BY name";
$result = mysql_query($query,$connection) or die("Couldn't execute query: ". mysql_error());
while($row = mysql_fetch_array($result)){
$campaignID = $row['id'];
$campaignName = $row['name'];
print '<option value="'.$campaignID.'">'.$campaignName.'</option>';
}
print '</select></span></span></td></tr></table></td>
</tr>
<tr bgcolor="#2C78C5">
<td colspan="3"><table width="100%" border="0" cellpadding="0" cellspacing = "0"><tr>
<td width="100"><span class="bodytext">From</span></td>
<td align="left"><span class="style1"><span class="bodytext">';
if($from_month <= 0) {
$month = date("M");
$m = date("n");
$yearC = date("Y");
$year = $yearC;
} else {
$month = $monthArray[$from_month-1];
$m = $from_month;
$year = $from_year;
$yearC = date("Y");
}
print '<span class="style1">
<select size="1" name="from_month" class="formtext">
<option selected value="'.$m.'">'.$month.'</option>
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>
<select size="1" name="from_year" class="formtext">
<option selected value="'.$year.'">'.$year.'</option>';
for($i=2004; $i<=$yearC; $i++) {
print '<option value="'.$i.'">'.$i.'</option>';
}
print '</select></span></td></tr></table></td>
<td colspan="3"><table width="100%" border="0" cellpadding="0" cellspacing = "0"><tr>
<td width="100"><span class="bodytext">To</span></td>
<td width="150"><span class="bodytext">';
if(strlen($to_month)<=0) {
$to_month = date("n");
$to_year = date("Y");
$month = date("M");
$m = date("n");
$yearC = date("Y");
$year = $yearC;
} else {
$month = $monthArray[$to_month-1];
$m = $to_month;
$year = $to_year;
$yearC = date("Y");
}
print '<font size="1"> </font><select size="1" name="to_month" class="formtext">
<option selected value="'.$m.'">'.$month.'</option>
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
<option value="6">Jun</option>
<option value="7">Jul</option>
<option value="8">Aug</option>
<option value="9">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>
<font size="1"> </font><select size="1" name="to_year" class="formtext">
<option selected value="'.$year.'">'.$year.'</option>';
for($i=2004; $i<=$yearC; $i++) {
print '<option value="'.$i.'">'.$i.'</option>';
}
print '</select></select></span></td><td> </td></tr></table></td>
</tr>
<tr>
<td colspan="6"><table width="100%" border="0" cellpadding="0" cellspacing = "0"><tr>
<td width="100"><span class="bodytext">Order</span></td>
<td width="150"><span class="style1">
<select name="orderBy" class="formtext">';
if($orderBy == "ad_banners.banner_name")
print '<option value="ad_banners.banner_name">Banner Ad Group</option>';
else if($orderBy == "ad_companies.company_name")
print '<option value="ad_companies.company_name">Advertiser</option>';
else if($orderBy == "ad_campaigns.name")
print ' <option value="ad_campaigns.name">Banner</option>';
else if($orderBy == "ad_counters.impressions")
print '<option value="ad_counters.impressions">Impressions</option>';
else if($orderBy == "ad_counters.clicks")
print '<option value="ad_counters.clicks">Clicks</option>';
print ' <option value="ad_banners.banner_name">Banner Ad Group</option>
<option value="ad_companies.company_name">Advertiser</option>
<option value="ad_campaigns.name">Banner</option>
<option value="ad_counters.impressions">Impressions</option>
<option value="ad_counters.clicks">Clicks</option>
</select>';
print '</span></span></td>
<td colspan="4"><span class="bodytext">';
if($radioOrder == "desc") {
print '<input name="radioOrder" type="radio" value="asc">
<span class="bodytext">Ascending</span><span class="style8">
<input name="radioOrder" type="radio" value="desc" checked>
<span class="bodytext">Descending</span>';
} else {
print '<input name="radioOrder" type="radio" value="asc" checked>
<span class="bodytext">Ascending</span><input name="radioOrder" type="radio" value="desc"><span class="bodytext">Descending</span>';
}
print '</td></tr></table></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<p align="center">
<input type="button" value="Search" onClick="javascript:submitSearch();" class="buttontext">
</p>';
$companyCondition = "";
$bannerCondition = "";
if($banner_id != "") {
$bannerCondition = "AND ad_campaigns.banner_id = ".$banner_id;
}
if($company_id != "") {
$companyCondition = "AND ad_companies.id = ".$company_id;
}
if($campaign_id != "") {
$campaignCondition = "AND ad_campaigns.id = ".$campaign_id;
}
if($orderBy == "") {
$orderBy = "ad_banners.banner_name";
}
$selectStats = "SELECT SUM(ad_counters.impressions) as totalImp, SUM(ad_counters.clicks) as totalClicks,
ad_companies.company_name, ad_campaigns.name, ad_banners.banner_name
FROM ad_campaigns, ad_companies, ad_counters, ad_banners
WHERE ad_counters.campaign_id = ad_campaigns.id
AND ad_campaigns.company_id = ad_companies.id
AND ad_campaigns.banner_id = ad_banners.id ".$bannerCondition." ".$companyCondition." ".$campaignCondition."
AND ad_counters.month >= ".$from_month."
AND ad_counters.month <= ".$to_month."
AND ad_counters.year >= ".$from_year."
AND ad_counters.year <= ".$to_year."
GROUP BY ad_companies.company_name, ad_campaigns.name, ad_banners.banner_name
ORDER BY ".$orderBy." ".$radioOrder;
$result = mysql_query($selectStats,$connection) or die("Couldn't execute query: ". mysql_error());
$numR = mysql_num_rows($result);
if($numR>0) {
print '<br><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#ACC366" bgcolor="#2C78C5">
<tr bgcolor="#ACC366">
<td width="872" bgcolor="#2C78C5">
<table width="100%" border="1" cellpadding="10" cellspacing="0" bordercolor="#ACC366">
<tr>
<td class="heading2" bgcolor="#ACC366">Banner Group</td>
<td class="heading2" bgcolor="#ACC366">Advertiser</td>
<td class="heading2" bgcolor="#ACC366">Banner Name</td>
<td class="heading2" bgcolor="#ACC366">Impressions</td>
<td class="heading2" bgcolor="#ACC366">Clicks</td>
<td class="heading2" bgcolor="#ACC366">CTR</td>
</tr>';
} else {
print '<br><table width="90%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#ACC366" bgcolor="#2C78C5">
<tr bgcolor="#ACC366">
<td width="100%" bgcolor="#2C78C5" class="bodytext">
NO RESULTS FOUND
</td>
</tr>
</table>';
}
while($row = mysql_fetch_array($result)){
$banner = $row['banner_name'];
$company = $row['company_name'];
$campaign = $row['name'];
$impressions = $row['totalImp'];
$clicks = $row['totalClicks'];
$ctr = ($clicks/$impressions * 100);
$ctr = number_format($ctr, 2)."%";
print '<tr bgcolor="#2C78C5" class="bodytext">
<td>'.$banner.'</td>
<td>'.$company.'</td>
<td>'.$campaign.'</td>
<td>'.$impressions.'</td>
<td>'.$clicks.'</td>
<td>'.$ctr.'</td>
</tr>';
}
print '</table></td></tr></table>
</body>
</html>';
} else {
print "Session has expired. Please log in again";
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -