edit_campaign.php

基于actionscript3.0的flashLoading控件

<?php

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

$campaign_name = $_POST["campaign_name"];
$start_date = $_POST["start_date"];
$end_date = $_POST["end_date"];
$campaign_active = $_POST["campaign_active"];
$impressions = $_POST["impressions"];
$clicks = $_POST["clicks"];
$monthly = $_POST["monthly"];
$campaign_id = $_POST["campaign_id"];

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";
}

$campaignUpdate = "	UPDATE ad_campaigns
					SET name = '".$campaign_name."',
					startdate = '".$start_date."',
					enddate = '".$end_date."',
					active = '".$campaign_active."',
					impressions = ".$impressions.",
					clicks = ".$clicks.",
					monthly = '".$monthly."'
					WHERE id = ".$campaign_id;

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

print 'Campaign has been successfully updated.';

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

?>