📄 banner.php

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

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

$banner_name = $_POST["banner_name"];
$banner_description = $_POST["banner_description"];
$seconds = $_POST["seconds"];
$target_window = $_POST["target_window"];
$uimpressions = $_POST["uimpressions"];
$uclicks = $_POST["uclicks"];

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

$banner_name = strtolower($banner_name);

$bannerSelect = "	SELECT banner_name
					FROM ad_banners
					WHERE banner_name = '".$banner_name."'";


$result = mysql_query($bannerSelect,$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!!!</p>
		</div>		
		</body>';
} else {
	$bannerInsert = "	INSERT INTO ad_banners
						(banner_name, banner_description, banner_timer, banner_target, banner_uimpressions, banner_uclicks)
						VALUES('".$banner_name."', '".$banner_description."', ".$seconds.", '".$target_window."', '".$uimpressions."', '".$uclicks."')";	
	
	mysql_query($bannerInsert,$connection) or die("Couldn't execute query: ". mysql_error());

	
	$selectBanner = "	SELECT id FROM ad_banners
						WHERE banner_name = '".$banner_name."'";

	$result = mysql_query($selectBanner,$connection) or die("Couldn't execute query: ". mysql_error());
	
	if($row = mysql_fetch_array($result)) {
		$banner_id = $row['id'];

		$weightInsert = "	INSERT INTO ad_weight
							(banner_id, counter)
							VALUES(".$banner_id.", 0)";	
	
		mysql_query($weightInsert,$connection) or die("Couldn't execute query: ". mysql_error());
	}


	
	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="bodytext">Banner ad group has been added successfully</p>
			  <p class="bodytext">Click <a href="banner_new.php">here</a> to add another banner ad group</p>
			</div>		
			</body>';
}

mysql_close($connection);

} else {
	print "Session has expired. Please log in again";
}
?>
⌨️ 快捷键说明

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