php+mysql新闻发布系统

大家说数据库无,我补充一下.data 那个文件夹就是数据库,只是MYSQL文件.有些网友不要乱批评.根据大家的意见，改为4分，网友啊！这个系统可使本人一个一个字敲进去的啊 ！我这个系统可是开源免费的。 带有评论、搜索、后台管理的一新闻图片发布系统，采用php+mysql.并且自动生成热点新闻、最进新闻。 制作人：牛文军 QQ:350203667 -- phpMyAdmin SQL Dump -- version 2.11.2.1 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2010 年 11 月 12 日 13:52 -- 服务器版本: 5.0.45 -- PHP 版本: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `nwjxt` -- -- -------------------------------------------------------- -- -- 表的结构 `gonggao` -- CREATE TABLE `gonggao` ( `id` int(100) NOT NULL auto_increment, `conent` varchar(254) NOT NULL default '', `times` date NOT NULL default '0000-00-00', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- 导出表中的数据 `gonggao` -- INSERT INTO `gonggao` (`id`, `conent`, `times`) VALUES (4, 'ghhg', '2007-11-24'), (5, 'dsfds\r\nsdfsdf', '2007-11-24'), (6, 'fdgsds', '0000-00-00'), (7, 'dsfafsd', '2007-11-24'), (8, 'dsfadf', '2007-11-24'), (9, 'sdfsdf', '2007-11-24'), (10, 'sdafasd', '2007-11-24'), (11, 'sdafsadf', '2007-11-24'), (13, '°¥£¡£¡£¡£¡\r\nÕÒ¹¤×÷Õ¦¾ÍÕâôÄÑÄØ£¿£¿', '2008-04-16'); -- -------------------------------------------------------- -- -- 表的结构 `news` -- CREATE TABLE `news` ( `id` int(100) NOT NULL default '0', `news_id` int(10) NOT NULL default '0', `content` text NOT NULL, `times` date NOT NULL default '0000-00-00', `title` varchar(100) NOT NULL default '', `poster` varchar(10) NOT NULL default '', `hotnumb` int(255) NOT NULL default '0', PRIMARY KEY (`news_id`,`news_id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `id_2` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- 导出表中的数据 `news` -- INSERT INTO `news` (`id`, `news_id`, `content`, `times`, `title`, `poster`, `hotnumb`) VALUES (0, 10, 'ÀÏÆÅÎÒ°®Äã\r\n', '0000-00-00', 'ÀÏÆÅÎÒ°®Äã', 'Å£', 27), (1, 11, 'ÐÂÎÅ·¢²¼ÏµÍ³', '0000-00-00', 'ÐÂÎÅ', 'Å£', 16), (2, 1, 'Ììˮʦ·¶Ñ§Ôº', '0000-00-00', 'Ììˮʦ·¶Ñ§Ôº', 'admin', 30), (3, 14, 'kjsjkljfskld', '0000-00-00', 'sadgsdafg', 'fdg', 21), (4, 2, 'sadfasdfs', '0000-00-00', 'sadgfasd', 'sadgs', 2), (5, 3, 'sdagdfsh', '2008-01-15', 'jkjhl', '11', 6), (6, 4, '¹þ¹þ ˹µÙ·Ò ˹µÙ·Ò´ó¹ø·¹¸Â\r\n·´¶Ô¹û¸¹¶éÂ俼¹Å¶Ófd\r\nkdflkg;ldf  \r\nkfgl;dfk\r\n\r\nfddsf ghdsfhjkhjl\\\r\nghjdgh\r\nfhjkh\r\nfdghjfghk\r\ndfhi\r\n\r\n ', '2008-04-16', 'ÈÈÁÒ×£ºØÐÂÎÅ·¢²¼ÏµÍ³V.01·¢²¼', 'Å£Îľü', 7); -- -------------------------------------------------------- -- -- 表的结构 `pl` -- CREATE TABLE `pl` ( `id` int(10) NOT NULL auto_increment, `news_id` varchar(10) NOT NULL default '', `name` varchar(10) NOT NULL default '', `time` date NOT NULL default '0000-00-00', `file1` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ; -- -- 导出表中的数据 `pl` -- INSERT INTO `pl` (`id`, `news_id`, `name`, `time`, `file1`) VALUES (1, '10', 'sxfsd', '0000-00-00', 'sdafgsadgdafgdf'), (2, '10', 'gfdeg', '2008-04-14', 'dfsgdf'), (3, '1', 'gfdeg', '2008-04-14', 'dfsgdf'), (4, '1', 'gfdeg', '2008-04-14', 'dfsgdf'), (5, '', 'niuwenjun', '2008-04-14', '´ó¼ÒºÃ£¡'), (6, '10', 'º£¹Ø·¨', '2008-04-14', '¸ºµçºÉ'), (12, '11', 'Å£', '2008-04-15', 'ÎҺܰ®´ó¼Ò£¡'), (11, '11', 'sdfs', '2008-04-15', 'sdfasdf'), (10, '10', 'niuwenjun', '2008-04-15', 'ÎÒ°® Äã £¡£¡»ú¹þ¹þ'), (13, '10', '¶¾ËØ·¢µÚÈý', '2008-04-15', '¶¾ËØ·ò¸¾'), (14, '0', '×·Ñ°ÂÌÖÞ', '2008-04-16', 'ÓÖ½â¾öÁËÈȵãÐÂÎÅÏÔʾÎÊÌâ!'), (15, '12', 'ËÕ´ò·öËç´ó', '2008-04-16', 'ËÕ´ò·¢Èöµ©'), (17, '0', 'ËÕ´ò·¢¸Â', '2008-04-16', ' µÄ'), (18, '1', 'f', '2008-04-16', 'f'), (19, '1', '1', '2008-04-16', '1'), (20, '11', '11', '2008-04-16', '11'), (21, '11', '12', '2008-04-16', '12'), (22, '4', 'niuwenjun', '2008-04-16', 'ÎÄ¿âÂÝË¿¶¤½¨·¿¿î'), (23, '4', '˹¶à·òÈö', '2008-04-16', 'ËÕ´ò·¢'), (24, '14', 'Äã', '2008-04-16', '²»'), (25, '4', '·¨¹ú', '2008-04-16', '·Ö¹û¸¹´ó'), (26, '4', '×·Ñ°ÂÌÖÞ', '2008-04-16', '²âÊÔ£¡£¡'), (27, '4', '×·Ñ°ÂÌÖÞ', '2008-04-16', '²âÊÔ£¡£¡'), (28, '4', '10', '2008-04-16', '10'), (29, '10', 'Å£Îľü', '2008-04-17', '´ó¼ÒºÃ°¡'), (30, '3', '³þÏس¤', '2008-04-17', 'ͬ־ÃÇÐÁ¿àÁË£¡'), (32, '1', '123', '2008-04-17', '123'), (33, '4', '123', '2008-04-17', '1233'), (34, '10', 'ÄÏСƼ', '2008-04-22', 'ÄãºÃ¡ò¡ò¡ò'), (36, '14', '×·Ñ°ÂÌÖÞ', '2008-04-23', '²âÊÔ¡ò¡ò¡ò¡ò'), (39, '14', 'µØ·½', '2008-04-23', '˹µÙ·Ò'); -- -------------------------------------------------------- -- -- 表的结构 `user_log` -- CREATE TABLE `user_log` ( `id` int(100) NOT NULL default '0', `name` varchar(10) NOT NULL default '', `password` varchar(10) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- 导出表中的数据 `user_log` -- INSERT INTO `user_log` (`id`, `name`, `password`) VALUES (0, 'niuwenjun', 'niuwenjun');