📄 banner_edit.php

📁 基于actionscript3.0的flashLoading控件
💻 PHP
字号:
<?php
	session_start(); 
	header("Cache-control: private");

$banner_id = $_POST["banner_id"];
$action = $_POST["action"];
$target_window = $_POST["target_window"];
$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());

	$message = "";

if($action == "update") {	
	$banner_name = strtolower($banner_name);

	$bannerSelect = "	SELECT banner_name
						FROM ad_banners
						WHERE banner_name = '".$banner_name."'
						AND id <> ".$banner_id;

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

	if($numR>0) {
		$message = '<span class="messagebold">A banner with this name already exists!!!</span>';
	} else {
		$bannerUpdate = "	UPDATE ad_banners
							SET banner_name = '".$banner_name."',
							banner_description = '".$banner_description."',
							banner_timer = ".$seconds.",
							banner_target = '".$target_window."',
							banner_uimpressions = '".$uimpressions."',
							banner_uclicks = '".$uclicks."'
							WHERE id = ".$banner_id;		
	
		mysql_query($bannerUpdate,$connection) or die("Couldn't execute queryB: ". mysql_error());
		$message = '<span class="messagebold">Changes have been saved successfully</span>';
		
	}
}

if($banner_id != null && $banner_id != "") {
	$query =	"	SELECT banner_name, banner_description, banner_timer, banner_target, banner_uimpressions, banner_uclicks
					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)){		
		$banner_name = $row['banner_name'];
		$banner_description = $row['banner_description'];
		$seconds = $row['banner_timer'];
		$target_window = $row['banner_target'];
		$uimpressions = $row['banner_uimpressions'];
		$uclicks = $row['banner_uclicks'];
	}	
}

print '<head>
	<title>Edit Banner</title>
	<link href="banner_styles.css" rel="stylesheet" type="text/css">

<script language="JavaScript1.2">

function confirmDelete() {
	if(document.banner_groupform.banner_id.value=="") {
		alert("A banner group has not been selected");
		return false;
	} else if(document.delete_banner.banner_id.value == "") {
		alert("Please press GO before deleting this banner ad group");
		return false;
	} else {
		var agree=confirm("Are you sure you want to delete this banner ad group?");
		if (agree)
			return true ;
		else
			return false ;
	}
}

function validate() {
	if(document.banner_groupform.banner_id.value=="") {
		alert("A banner group has not been selected");
		return false;
	} else if(document.banner_form.banner_name.value=="" || document.banner_form.banner_description.value=="" ||
		document.banner_form.seconds.value=="") {
		alert("All fields must be completed");
		return false;
	}
	else {		
		return true;
	}

}

function saveForm() {
	if(validate()) {
		document.forms["banner_form"].submit();
	}
}

function deleteForm() {
	if(confirmDelete()) {
		document.forms["delete_banner"].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">Edit Banner Ad Group</span></td>
        </tr>
      </table>        </td>
    </tr>
    <tr valign="top">
      <td><table width="100%"  border="1" cellpadding="10" cellspacing="0" bordercolor="#ACC366">
        <tr>
          <td width="100%" colspan="2">			
          	<table width="100%"  border="0" cellspacing="0" cellpadding="3">			
              <tr><form name="banner_groupform" action="banner_edit.php" method="post">
                <td width="200"><span class="bodytext">Select banner ad group to edit</span></td>
                <td><span class="bodytext">';
					if($banner_id != null && $banner_id != "") {
						print '<select size="1" name="banner_id" class="formtext" onChange="submit();">
						<option value="'.$banner_id.'">'.$banner_name.'</option>';
					} else {
						print '<select size="1" name="banner_id" class="formtext" onChange="submit();">
							<option value="">Select Banner</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 '</span></td></form>
              </tr>
            </table>			
            </td>
          	</tr>';
if($banner_id != null && $banner_id != "") {
	if($message != "") {
		print '<tr><td width="100%" colspan="2">'.$message.'</td></tr>';
	}
print '	<form name="banner_form" method="post" action="banner_edit.php">
		<input type="hidden" name="banner_id" value="'.$banner_id.'">
		<input type="hidden" name="action" value="update">
        <tr bgcolor="#2C78C5">
         <td width="130"><span class="bodytext">Group Name</span></td>
          <td><span class="style1"><span class="bodytext">';

	if($banner_name != null) {
		print '<input name="banner_name" type="text" id="banner_name" value="'.$banner_name.'" class="formtext">';
	} else {
		print '<input name="banner_name" type="text" id="banner_name" class="formtext">';
	}

print '	</span></span></td>
        </tr>
        <tr bgcolor="#2C78C5">
          <td width="130"><span class="bodytext">Group Description</span></td>
          <td><p class="style1"><span class="bodytext">';

		if($banner_description != null) {
			print '<input name="banner_description" type="text" id="banner_description" class="formtext" size="85" value="'.$banner_description.'">';
		} else {			
			print '<input name="banner_description" type="text" id="banner_description" class="formtext" size="85">';
		}

print '	</span></p></td>
        </tr>
        <tr bgcolor="#2C78C5">
          <td width="130"><span class="bodytext">Seconds Per Ad </span></td>
          <td><span class="bodytext">';

		if($seconds != null) {
			print '<input name="seconds" type="text" id="seconds" size="15" value="'.$seconds.'" class="formtext">';
		} else {
			print '<input name="seconds" type="text" id="seconds" size="15" class="formtext">';
		}

print '	</span></td>
        </tr>
        <tr bgcolor="#2C78C5">
          <td width="130"><span class="bodytext">URL Target Window</span></td>
          <td><span class="bodytext">';

		if($target_window != null) {
			print '<input name="target_window" type="text" id="target_window" size="15" value="'.$target_window.'" class="formtext">';
		} else {
			print '<input name="target_window" type="text" id="target_window" size="15" class="formtext">';
		}

print '	</span></td>
        </tr>
        <tr bgcolor="#2C78C5">
          <td width="130"><span class="bodytext">Unique Impressions</span></td>
          <td><span class="bodytext">';

		if($uimpressions == 'Y') {
			print '<select name="uimpressions" id="uimpressions" class="formtext">
        			<option value="Y" selected>Yes</option>
        			<option value="N">No</option></select>';
		} else {
			print '<select name="uimpressions" id="uimpressions" class="formtext">
        			<option value="Y">Yes</option>
        			<option value="N" selected>No</option></select>';
		}

print '	</span></td>
        </tr>
        <tr bgcolor="#2C78C5">
          <td width="130"><span class="bodytext">Unique Clicks </span></td>
          <td><span class="bodytext">';

		if($uclicks == 'Y') {
			print '<select name="uclicks" id="uclicks" class="formtext">
        			<option value="Y" selected>Yes</option>
        			<option value="N">No</option></select>';
		} else {
			print '<select name="uclicks" id="uclicks" class="formtext">
        			<option value="Y">Yes</option>
        			<option value="N" selected>No</option></select>';
		}

print '	</span></td>
        </tr>
		</form>        	
      </table>        
      </td>
    </tr>
  </table>
<p align="center">
	<input type="button" value="Save changes" onClick="javascript:saveForm();" class="buttontext">&nbsp;
	<input type="button" value="Delete group" onClick="javascript:deleteForm();" class="buttontext">
</p>
	<form name="delete_banner" action="delete_banner.php" method="post" onsubmit="return confirmDelete();">		
		<input type="hidden" name="banner_id" value="'.$banner_id.'">
	</form>';
} else {
	print '</table></td>
		</tr>
		</table>';

}
print '<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>';

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

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