📄 advertiser.php
字号:
<?php
session_start();
header("Cache-control: private");
$company_name = $_POST["company_name"];
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());
$advertiserSelect = " SELECT id
FROM ad_companies
WHERE company_name LIKE '".$company_name."'";
$result = mysql_query($advertiserSelect,$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> </p>
<p> </p>
<p class="messagebold">A company with this name already exists!!!</p>
</div>
</body>';
} else {
$companyInsert = " INSERT INTO ad_companies
(company_name, contact_name, address, zip, country, email, phone, fax)
VALUES('".$company_name."', '".$contact_name."', '".$company_address."', '".$company_zip."', '".$company_country."', '".$contact_email."', '".$company_phone."', '".$company_fax."')";
mysql_query($companyInsert,$connection) or die("Couldn't execute query: ". mysql_error());
$advertiserQuery = " SELECT id
FROM ad_companies
WHERE company_name = '".$company_name."'";
$result = mysql_query($advertiserQuery,$connection) or die("Couldn't execute query: ". mysql_error());
if($row = mysql_fetch_array($result)){
$company_id = $row['id'];
}
print ' <head>
<link href="banner_styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center">
<p> </p>
<p> </p>
<p class="bodytext">Advertiser has been added successfully. Click <a href="campaign_new.php">here</a> to add a banner.</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 + -