基于CMS实现的QCMS PHP 1.1 正式版 SP1_qcms_php(使用说明+源代码+html+毕业设计).zip

DROP TABLE IF EXISTS admin; CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `admin_name` varchar(50) NOT NULL, `admin_password` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS bq; CREATE TABLE `bq` ( `id` int(11) NOT NULL auto_increment, `bq` text NOT NULL, `names` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS category; CREATE TABLE `category` ( `cid` int(11) NOT NULL auto_increment, `pcid` int(11) NOT NULL default '0', `cname` varchar(50) default NULL, `linkture` int(11) default NULL, `link` varchar(250) default NULL, `keyword` varchar(250) default NULL, `info` varchar(250) default NULL, `types` int(11) default '0', `ons` int(11) default NULL, `px` int(11) default NULL, `ctemp` varchar(250) default NULL, `ntemp` varchar(250) default NULL, PRIMARY KEY (`cid`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS discuss; CREATE TABLE `discuss` ( `did` int(11) NOT NULL auto_increment, `posttime` time NOT NULL, `poster` varchar(50) NOT NULL, `dcontent` text NOT NULL, `newsid` int(11) NOT NULL, PRIMARY KEY (`did`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS diy; CREATE TABLE `diy` ( `id` int(11) NOT NULL auto_increment, `names` varchar(50) NOT NULL, `diy` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS guest; CREATE TABLE `guest` ( `id` int(11) NOT NULL auto_increment, `title` varchar(250) default NULL, `name` varchar(50) default NULL, `tel` varchar(50) default NULL, `email` varchar(50) default NULL, `qq` int(12) default NULL, `ip` varchar(50) default NULL, `hf` text, `content` text, `times` time NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS jss; CREATE TABLE `jss` ( `id` int(11) NOT NULL auto_increment, `js_name` varchar(50) NOT NULL, `js_code` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS news; CREATE TABLE `news` ( `newsid` int(11) NOT NULL auto_increment, `ntitle` varchar(250) NOT NULL, `nkeyword` varchar(250) default NULL, `ninfo` varchar(250) default NULL, `ncontent` text NOT NULL, `posttime` varchar(250) default NULL, `types` int(11) default '0', `cid` int(11) default '0', `attpic` int(11) default '0', `readcount` int(11) default '0', `img` varchar(250) default NULL, `tuijian` int(11) default '0', PRIMARY KEY (`newsid`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS olink; CREATE TABLE `olink` ( `id` int(11) NOT NULL auto_increment, `link_name` varchar(50) NOT NULL, `link_url` varchar(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS system; CREATE TABLE `system` ( `id` int(11) NOT NULL auto_increment, `webname` varchar(50) NOT NULL, `index` varchar(50) NOT NULL, `itemp` varchar(250) NOT NULL, `email` varchar(50) NOT NULL, `keywords` varchar(250) NOT NULL, `info` varchar(250) NOT NULL, `copyright` varchar(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS tags; CREATE TABLE `tags` ( `id` int(11) NOT NULL auto_increment, `tag_name` varchar(50) NOT NULL, `tag_num` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS users; CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(50) NOT NULL, `userpwd` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO admin VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3'); INSERT INTO category VALUES ('1', '0', '新闻', '0', NULL, NULL, NULL, '0', '1', '1', 'templist/newslist.html', 'templist/view.html'); INSERT INTO category VALUES ('2', '0', '产品', '0', NULL, NULL, NULL, '0', '1', '2', 'templist/prolist.html', 'templist/view.html'); INSERT INTO category VALUES ('3', '0', '留言', '1', 'guest.php', NULL, NULL, '0', '1', '3', 'templist/prolist.html', 'templist/view.html'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('1', 'qcms文章测试一', 'qcms文章测试一qcms文章测试一qcms文章测试一qcms文章测试一qcms文章测试一qcms文章测试一', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('2', 'qcms文章测试二', 'qcms文章测试二qcms文章测试二qcms文章测试二qcms文章测试二qcms文章测试二qcms文章测试二', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('3', 'qcms文章测试三', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('4', 'qcms文章测试四', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('5', 'qcms文章测试五', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('6', 'qcms文章测试六', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('7', 'qcms文章测试七', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('8', 'qcms文章测试八', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('9', 'qcms文章测试九', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三', '1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` )VALUES ('10', 'qcms文章测试十', 'qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三qcms文章测试三','1244011261','1'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('11', 'qcms产品测试一', 'qcms产品测试一qcms产品测试一qcms产品测试一qcms产品测试一qcms产品测试一qcms产品测试一', '1244011261','2','images/chanpin.jpg'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid` ,`img`)VALUES ('12', 'qcms产品测试二', 'qcms产品测试二qcms产品测试二qcms产品测试二qcms产品测试二qcms产品测试二qcms产品测试二', '1244011261','2','images/chanpin.jpg'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('13', 'qcms产品测试三', 'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '1244011261','2','images/chanpin.jpg'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('14', 'qcms产品测试四', 'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三', '1244011261','2','images/chanpin.jpg'); INSERT INTO news (`newsid` ,`ntitle` ,`ncontent` ,`posttime`,`cid`,`img` )VALUES ('15', 'qcms产品测试五', 'qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产品测试三qcms产�