-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql_creat.php
33 lines (27 loc) · 980 Bytes
/
mysql_creat.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?php
/*
建立数据库文件
*/
// 导入配置文件
include_once 'config.php';
include_once 'conn.php';
//建立数据库linkurl
$create = "CREATE TABLE `linkurl` (`url` varchar(150) NOT NULL,`keywords` varchar(150) NOT NULL,`time` varchar(13) NOT NULL,`click` varchar(7) NOT NULL,PRIMARY KEY (`url`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
if ($return = $pdo->query($create) != false) {
print "Create DateBase === link is OK!!!\n";
print "plese waite 5 second!!\n";
}else{
$arr = $return->errorInfo();
print_r($arr);
}
sleep(5);
//建立数据库 amazon_linkurl
$create = "CREATE TABLE `amazon_linkurl` (`id` INT (32) NOT NULL AUTO_INCREMENT,`url` VARCHAR (100) NOT NULL,`keywords` VARCHAR (100) NOT NULL,PRIMARY KEY (`id`)) ENGINE = MyISAM DEFAULT CHARSET = utf8;";
if ($return = $pdo->query($create) != false) {
print "Create DateBase === amazon_linkurl is OK!!!\n";
print "plese waite 5 second!!\n";
}else{
$arr = $return->errorInfo();
print_r($arr);
}
?>