上传者: xtchenwei
|
上传时间: 2021-10-31 21:25:30
|
文件大小: 38KB
|
文件类型: -
带数据库 自己已经测试好 可搭建好环境 就能使用 PHP+Mysql
数据库名称 newsdb
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50553
Source Host : localhost:3306
Source Database : newsdb
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2018-06-03 10:35:20
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`keywords` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`author` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`addtime` int(10) unsigned NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '标题', '关键字', '作者', '20180602', '内容已经修改');
INSERT INTO `news` VALUES ('2', '测试2', '测试', '陈为', '1527937766', '陈为自己来测试');
INSERT INTO `news` VALUES ('3', '测试3', '测试3', '陈为3', '1527938044', '陈为自己来测试3');
INSERT INTO `news` VALUES ('5', '点点滴滴', '222221', '11121231231', '1527938239', '12啊撒大苏打大苏打大大');