📄 campaign.php

📁 基于actionscript3.0的flashLoading控件
💻 PHP
字号:
<?php

session_start(); 
header("Cache-control: private");

$campaign_name = $_POST["campaign_name"];
$limit = $_POST["limit"];
$company_id = $_POST["company_id"];
$banner_id = $_POST["banner_id"];
$start_date = $_POST["start_date"];
$end_date = $_POST["end_date"];
$campaign_active = $_POST["campaign_active"];
$impressions = $_POST["impressions"];
$impressions_clicks = $_POST["impressions_clicks"];
$clicks = $_POST["clicks"];
$monthly = $_POST["monthly"];
$weight = $_POST["weight"];


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());

if($campaign_active == "true") {
	$campaign_active = "Y";
} else {
	$campaign_active = "N";
}
if($monthly == "true") {
	$monthly = "Y";
} else {
	$monthly = "N";
}


$impressions = 0;
$clicks = 0;

if($limit == "impressions") {
	$impressions = $impressions_clicks;	
} else if($limit == "clicks") {
	$clicks = $impressions_clicks;
}


$campaignSelect = "	SELECT id
					FROM ad_campaigns
					WHERE name LIKE '".$campaign_name."'";

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

if($numR>0) {
	print '	<head>
		<link href="banner_styles.css" rel="stylesheet" type="text/css">
		</head>
		<body>
		<div align="center">
		  <p>&nbsp;</p>
		  <p>&nbsp;</p>
		  <p class="messagebold">A banner with this name already exists. Please go back and enter a different name.</p>		  
		</div>		
		</body>';
} else {
	$campaignInsert = "	INSERT INTO ad_campaigns
						(name, company_id, banner_id, startdate, enddate, active, impressions, clicks, monthly, weight)	VALUES('".$campaign_name."',".$company_id.",".$banner_id.",'".$start_date."','".$end_date."',
						'".$campaign_active."',".$impressions.",".$clicks.",'".$monthly."', ".$weight.")";
	
	mysql_query($campaignInsert,$connection) or die("Couldn't execute query: ". mysql_error());
	
	$campaignQuery = "	SELECT id
						FROM ad_campaigns
						WHERE name = '".$campaign_name."'";
	
	$result = mysql_query($campaignQuery,$connection) or die("Couldn't execute query: ". mysql_error());
	
	if($row = mysql_fetch_array($result)){
		$campaign_id = $row['id'];
	}
	
	print '<script>window.location="campaign_edit2.php?campaign_id='.$campaign_id.'"</script>';

}
mysql_close($connection);

} else {
	print "Session has expired. Please log in again";
}


?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -