📄 installdb.php

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

$run = $_POST["run"];

require 'config.php';

print '<head>
		<title>Install Database Tables</title>
		<link href="banner_styles.css" rel="stylesheet" type="text/css">
		</head><body>';


$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($run != "true") {
	print	'<span class="bodytext">You are about to create the following tables in your database:<br><br>
			ad_banners<br>ad_campaigns<br>ad_companies<br>ad_counters<br>ad_images<br>ad_weight<br></span>';

	print	'<p class="bodytext">Press <strong>RUN SCRIPT</strong> to proceed</p>
			<form method="post" action="installdb.php">
				<input type="hidden" name="run" value="true">
				<input type="submit" name="Submit" value="RUN SCRIPT" class="buttontext">
			</form>';
} else {
	// Table structure for table `ad_banners`
	
	$createTable = "	CREATE TABLE ad_banners (
						id smallint(5) NOT NULL auto_increment,
						banner_name varchar(20) NOT NULL default '',
						banner_description varchar(200) default NULL,
						banner_width smallint(5) default NULL,
						banner_height smallint(5) default NULL,
						banner_timer smallint(5) default NULL,
						banner_target varchar(20) default '_blank',
						banner_uimpressions char(1) default NULL,
						banner_uclicks char(1) default NULL,
						banner_order char(1) default NULL,
						PRIMARY KEY  (id)
						) TYPE=MyISAM";
	
	
	mysql_query($createTable,$connection) or die("Couldn't execute query: ". mysql_error());
	
	print '<p class="bodytext">ad_banners table ...... created successfully</p>';
	
	
	
	// Table structure for table `ad_campaigns`
	
	
	$createTable = "	CREATE TABLE ad_campaigns (
						  id smallint(5) NOT NULL auto_increment,
						  banner_id smallint(5) default NULL,
						  name varchar(30) NOT NULL default '',
						  company_id smallint(5) default NULL,
						  startdate date default NULL,
						  enddate date default NULL,
						  impressions int(7) default NULL,
						  clicks int(7) default NULL,
						  monthly char(1) default NULL,
						  weight tinyint(2) default NULL,
						  priority smallint(2) default NULL,
						  active char(1) NOT NULL default '',
						  PRIMARY KEY  (id)
						) TYPE=MyISAM";
	
	
	mysql_query($createTable,$connection) or die("Couldn't execute query: ". mysql_error());
	
	print '<p class="bodytext">ad_campaigns table ...... created successfully</p>';
	
	
	
	
	
	// Table structure for table `ad_companies`
	
	
	$createTable = "	CREATE TABLE ad_companies (
						  id smallint(5) NOT NULL auto_increment,
						  company_name varchar(100) NOT NULL default '',
						  contact_name varchar(50) default NULL,
						  address varchar(150) default NULL,
						  zip varchar(10) NOT NULL default '',
						  country varchar(15) NOT NULL default '',
						  email varchar(50) default NULL,
						  phone varchar(20) default NULL,
						  fax varchar(20) default NULL,
						  PRIMARY KEY  (id)
						) TYPE=MyISAM";
	
	
	mysql_query($createTable,$connection) or die("Couldn't execute query: ". mysql_error());
	
	print '<p class="bodytext">ad_companies table ...... created successfully</p>';
	
	
	
	
	// Table structure for table `ad_counters`
	
	
	$createTable = "	CREATE TABLE ad_counters (
						  campaign_id smallint(5) NOT NULL default '0',
						  month smallint(2) NOT NULL default '0',
						  year smallint(4) NOT NULL default '0',
						  impressions int(7) default '0',
						  clicks int(7) default '0'
						) TYPE=MyISAM";
	
	
	mysql_query($createTable,$connection) or die("Couldn't execute query: ". mysql_error());
	
	print '<p class="bodytext">ad_counters table ...... created successfully</p>';
	
	
	// Table structure for table `ad_images`
	
	
	$createTable = "	CREATE TABLE ad_images (
						  id smallint(5) NOT NULL auto_increment,
						  filename varchar(30) NOT NULL default '',
						  link varchar(255) default NULL,
						  campaign_id smallint(5) default NULL,
						  active char(1) default NULL,
						  PRIMARY KEY  (id),
						  UNIQUE KEY campaign_id (campaign_id)
						) TYPE=MyISAM";
	
	
	mysql_query($createTable,$connection) or die("Couldn't execute query: ". mysql_error());
	
	print '<p class="bodytext">ad_images table ...... created successfully</p>';


	// Table structure for table `ad_weight`
	
	
	$createTable = "	CREATE TABLE ad_weight (
						  banner_id smallint(5) NOT NULL default '0',
						  counter smallint(5) default '0',
						  PRIMARY KEY  (banner_id)
						) TYPE=MyISAM;";
	
	
	mysql_query($createTable,$connection) or die("Couldn't execute query: ". mysql_error());
	
	print '<p class="bodytext">ad_weight table ...... created successfully</p>';
		
	mysql_close($connection);

	print '<br><p class="bodytext">All tables have been created successfully.';
	print 'You should now <font color="#FF0000"><strong>DELETE</strong></font> the <strong>installdb.php</strong> file from your webserver.</p>';
	
}
print '</body>';
?>
⌨️ 快捷键说明

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