📄 advertiser_edit.php
字号:
<?php
session_start();
header("Cache-control: private");
$company_id = $_POST["company_id"];
$company_name = $_POST["company_name"];
$contact_name = $_POST["contact_name"];
$address = $_POST["address"];
$zip = $_POST["zip"];
$country = $_POST["country"];
$email = $_POST["email"];
$phone = $_POST["phone"];
$fax = $_POST["fax"];
$action = $_POST["action"];
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") {
$advertiserSelect = " SELECT id
FROM ad_companies
WHERE company_name LIKE '".$company_name."'
AND id <> ".$company_id;
$result = mysql_query($advertiserSelect,$connection) or die("Couldn't execute query: ". mysql_error());
$numR = mysql_num_rows($result);
if($numR>0) {
$message = '<span class="messagebold">A company with this name already exists!!!</span>';
} else {
$updateAdvertiser = " UPDATE ad_companies
SET company_name = '".$company_name."',
contact_name = '".$contact_name."',
address = '".$address."',
zip = '".$zip."',
country = '".$country."',
email = '".$email."',
phone = '".$phone."',
fax = '".$fax."'
WHERE id=".$company_id;
mysql_query($updateAdvertiser,$connection) or die("Couldn't execute query: ". mysql_error());
$message = '<span class="messagebold">Changes have been saved successfully</span>';
}
}
if($company_id != null && $company_id != "") {
$query = " SELECT company_name, contact_name, address, zip, country, email, phone, fax
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)){
$company_name = $row['company_name'];
$contact_name = $row['contact_name'];
$address = $row['address'];
$zip = $row['zip'];
$country = $row['country'];
$email = $row['email'];
$phone = $row['phone'];
$fax = $row['fax'];
}
}
print ' <head>
<title>Edit Advertiser</title>
<link href="banner_styles.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2">
function confirmDelete() {
if(document.advertiser_formA.company_id.value=="") {
alert("An advertiser has not been selected");
return false;
} else if(document.delete_advertiser.company_id.value == "") {
alert("Please press GO before deleting this advertiser");
return false;
} else {
var agree=confirm("Are you sure you want to delete this advertiser?");
if (agree)
return true ;
else
return false ;
}
}
function validate() {
if(document.advertiser_formA.company_id.value=="") {
alert("An advertiser has not been selected");
return false;
} else if (document.advertiser_form.company_name.value=="") {
alert("Company Name must be completed");
return false;
}
else {
document.forms["advertiser_form"].action.value="update";
return true;
}
}
function saveForm() {
if(validate()) {
document.forms["advertiser_form"].submit();
}
}
function deleteForm() {
if(confirmDelete()) {
document.forms["delete_advertiser"].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 bgcolor="#ACC366"><table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#ACC366">
<tr>
<td><span class="heading">Edit Advertiser</span></td>
</tr>
</table> </td>
</tr>
<tr valign="top">
<td><table width="100%" border="1" cellpadding="10" cellspacing="0" bordercolor="#ACC366">
<tr>
<td colspan="4">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr><form name="advertiser_formA" action="advertiser_edit.php" method="post">
<td width="150"><span class="bodytext">Select advertiser to edit </span></td>
<td><span class="bodytext">';
if($company_id != null && $company_id != "") {
print '<select size="1" name="company_id" class="formtext" onChange="submit();">
<option value="'.$company_id.'">'.$company_name.'</option>';
} else {
print '<select size="1" name="company_id" class="formtext" onChange="submit();">
<option value="">Select Advertiser</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 '</span></td></form>
</tr>
</table>
</td>
</tr>';
if($company_id != null && $company_id != "") {
if($message != "") {
print '<tr><td width="100%" colspan="4">'.$message.'</td></tr>';
}
print '<form action="advertiser_edit.php" method="post" name="advertiser_form">
<input type="hidden" name="company_id" value="'.$company_id.'">
<input type="hidden" name="action">
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Company Name</span></td>
<td width="200"><span class="bodytext"><input name="company_name" type="text" id="company_name" value="'.$company_name.'" class="formtext">
</span></td>
<td width="130"><span class="bodytext">Contact Name</span></td>
<td><span class="bodytext"><input name="contact_name" type="text" id="contact_name" value="'.$contact_name.'" class="formtext"></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Address</span></td>
<td colspan="3"><span class="bodytext">
<input name="address" type="text" id="banner_description" class="formtext" size="85" value="'.$address.'">
</span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Zip</span></td>
<td><span class="bodytext"><input name="zip" type="text" id="company_zip" value="'.$zip.'" class="formtext">
</span></td>
<td><span class="bodytext">Country</span></td>
<td><span class="bodytext"><input name="country" type="text" id="company_country" value="'.$country.'" class="formtext"></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Phone</span></td>
<td><span class="bodytext"><input name="phone" type="text" id="company_phone" value="'.$phone.'" class="formtext">
</span></td>
<td><span class="bodytext">Email</span></td>
<td><span class="bodytext"><input name="email" type="text" id="contact_email" value="'.$email.'" class="formtext"></span></td>
</tr>
<tr bgcolor="#2C78C5">
<td width="130"><span class="bodytext">Fax</span></td>
<td colspan="3"><span class="bodytext"><input name="fax" type="text" id="company_fax" value="'.$fax.'" class="formtext">
</span></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<p align="center">
<input type="button" value="Save changes" onClick="javascript:saveForm();" class="buttontext">
<input type="button" value="Delete advertiser" onClick="javascript:deleteForm();" class="buttontext">
</p>
<form action="delete_advertiser.php" method="post" name="delete_advertiser">
<input type="hidden" name="company_id" value="'.$company_id.'">
</form>';
} else {
print '</table></td>
</tr>
</table>';
}
print '<p> </p>
</body>';
} else {
print "Session has expired. Please log in again";
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -