📄 install.php
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>留言本安装程序-信用卡ABC</title>
<link href="main.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php
include("config.php");
if($con=@mysql_connect($host,$user,$password))
{ echo "<div class=name><ul><li class=title>留言本安装程序V1.0</p></li>\n";
echo "<li>连接MYSQL数据库...<span class='red'>成功</span></li>";
mysql_query("SET NAMES 'gb2312'",$con);
if(mysql_query("CREATE DATABASE `$db`;",$con)){
echo "<li>创建数据库<b>$db</b>...<span class='red'>成功!</span><br></li>\n";
} else {echo "<li>创建数据库<b>$db</b>...<span class='red'>失败</span>,可能数据库已经存在了</li>";}
mysql_select_db($db,$con);
if(mysql_query("CREATE TABLE `gbooktable` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 20 ) NOT NULL ,
`ip` VARCHAR( 40 ) NOT NULL ,
`title` VARCHAR( 40 ) NOT NULL ,
`info` TEXT NOT NULL ,
`time` DATETIME NOT NULL
) CHARACTER SET gb2312",$con)){echo "<li>创建表<b>gbooktable</b>...<span class='red'>成功!</span></li>\n";
} else{echo "<li>创建表<b>gbooktable</b>...<span class='red'>失败</span>,可能表已经存在.</li></ul></div>";}
if(mysql_query("CREATE TABLE `users` (
`id` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`admin_name` VARCHAR( 20 ) NOT NULL ,
`password` VARCHAR( 20 ) NOT NULL
) CHARACTER SET gb2312",$con)){echo "<li>创建表<b>users</b>...<span class='red'>成功!</span></li>\n";
} else{echo "<li>创建表<b>users</b>...<span class='red'>失败</span>,可能表已经存在.</li></ul></div>";}
if(mysql_query("INSERT INTO `users` (admin_name,password) VALUES ('admin', 'admin')",$con))echo "<li>初始管理员...<span class='red'>成功</span></li>\n";
mysql_close();
echo "<li class=title><a href='add.php'>如果提示数据表创建成功，点击进入留言页面</a></li></ul></div>";
}
else{
echo "<div class=name><ul><li class=title>留言本安装程序V1.0</p></li>无法连接MYSQL数据库，请检查include/config.php文件。</li></ul></div>";
}
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -