mysql数据库的php安装文件

下载: install.php
$dbhost="localhost";// 数据库服务器
 
$dbuser="root";// 数据库用户名
$dbpass="root";// 数据库密码
$dbname="cgcms";// 数据库名
@mysql_pconnect($dbhost,$dbuser,$dbpass) or die("
<div>不能连接服务器!</div>
");
echo "连接数据服务器成功！
";
@mysql_query('set names "utf8"');
$result = @mysql_query("Drop DATABASE IF EXISTS $dbname");
if(!@mysql_select_db($dbname)){
echo "创建数据库.......
";
$query = "Create DATABASE $dbname";
if(!mysql_query($query)){
echo "数据库创建失败，返回!
";
exit;
}
}
echo"创建数据库成功！
";
@mysql_select_db($dbname) or die("
<div>不能选择数据库!</div>
");
echo"选择数据库".$dbname."
";
//创建表：cgcms_article
$result = @mysql_query("Drop TABLE IF EXISTS `cgcms_article`");
//下面这种创建表的写法比较好
$setup_query="
Create TABLE `cgcms_article` (
`aid` int(10) unsigned NOT NULL auto_increment,
`atitle` varchar(255) NOT NULL,
`cid` smallint(6) unsigned NOT NULL,
`isshow` tinyint(1) NOT NULL default '1',
`isdigest` tinyint(1) unsigned NOT NULL default '0',
`istop` tinyint(1) unsigned NOT NULL default '0',
`content` text NOT NULL,
`descriptions` text NOT NULL,
`author` varchar(255) NOT NULL,
`fromurl` varchar(255) NOT NULL,
`tags` varchar(255) NOT NULL,
`metadesc` varchar(255) NOT NULL,
`addtime` int(10) unsigned NOT NULL,
`uid` smallint(5) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`aid`)
) ENGINE=MyISAM AUTO_INCREMENT=212 DEFAULT CHARSET=utf8";
$result = mysql_query($setup_query);
//创建表：cgcms_attachs
$result = @mysql_query("Drop TABLE IF EXISTS `cgcms_attachs`");
$setup_query="
Create TABLE `cgcms_attachs` (
`attachid` mediumint(6) unsigned NOT NULL auto_increment,
`aid` int(8) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL,
`filetype` char(20) NOT NULL,
`filesize` int(11) unsigned NOT NULL,
`filepath` varchar(255) NOT NULL,
`isimg` tinyint(1) unsigned NOT NULL default '0',
`uploaddate` int(10) NOT NULL,
PRIMARY KEY  (`attachid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8";
$result = mysql_query($setup_query);
//创建表：cgcms_categories
$result = @mysql_query("Drop TABLE IF EXISTS `cgcms_categories`");
$setup_query="
Create TABLE `cgcms_categories` (
`cid` smallint(6) unsigned NOT NULL auto_increment,
`cup` smallint(6) unsigned NOT NULL default '0',
`cname` char(50) NOT NULL,
`depth` tinyint(1) unsigned NOT NULL default '1',
`sons` smallint(4) unsigned NOT NULL default '0',
`descriptions` text NOT NULL,
`metakeywords` varchar(255) NOT NULL default ' ',
`metadescription` varchar(255) NOT NULL default ' ',
`listorder` tinyint(2) unsigned NOT NULL default '0',
`curl` varchar(150) NOT NULL default ' ',
`type` tinyint(1) unsigned NOT NULL default '0',
`allowcomment` tinyint(1) unsigned NOT NULL default '1',
`showindex` tinyint(1) unsigned NOT NULL default '0',
`showindexmenu` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY  (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8";
$result = mysql_query($setup_query);
//创建表：cgcms_links
$result = @mysql_query("Drop TABLE IF EXISTS `cgcms_links`");
$setup_query="
Create TABLE `cgcms_links` (
`lid` smallint(3) unsigned NOT NULL auto_increment,
`lname` varchar(255) NOT NULL,
`lurl` varchar(255) NOT NULL,
`limg` varchar(255) NOT NULL default ' ',
`descriptions` text NOT NULL,
PRIMARY KEY  (`lid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8";
$result = mysql_query($setup_query);
//创建表：cgcms_settings
$result = @mysql_query("Drop TABLE IF EXISTS `cgcms_settings`");
$setup_query="
Create TABLE `cgcms_settings` (
`titles` varchar(255) NOT NULL,
`values` text NOT NULL,
PRIMARY KEY  (`titles`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8";
$result = mysql_query($setup_query);
//创建表：cgcms_settings
$result = @mysql_query("Drop TABLE IF EXISTS `cgcms_users`");
$setup_query="
Create TABLE `cgcms_users` (
`uid` smallint(6) unsigned NOT NULL auto_increment,
`uname` varchar(50) NOT NULL,
`upwd` varchar(32) NOT NULL,
`nickname` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`uurl` varchar(150) NOT NULL,
`ugroup` tinyint(1) unsigned NOT NULL default '2',
PRIMARY KEY  (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8";
$result = mysql_query($setup_query);
 
//inserdb.sql是完成插入数据的sql文件，通过一行一行的读取这个文件（每个insert 操作都是在一行完成，没有换行）然后提取每条命令执行
$filename="insertdb.sql";
$fp=file($filename);
foreach($fp as $value){
//echo $value."
";
if(substr($value,0,11)=="Insert INTO"){
$query=substr($value,0,-2);
$result=mysql_query($query);
}
}
?&gt;
?>