项目总结
概述
本次实战,主要完成三方面内容:1-页面绘制;2-MVC结构实现;3-PDO数据访问与数据渲染;
实现页面包括:全站首页,图片站,图片详情页,二手商品,商品列表,商品详情,文章列表,文章详情等几个页面。
缺点
1-项目入口文件,未进行合并,缺少类路由的访问方法;
2-数据模型方面,未针对组件进行归类整理,造成在控制器中代码重复调用的问题;
3-项目代码方面,应该还有更好的方式方法,但是未进行试验,因为个人感觉能力以及相关知识方面还欠缺较多,希望能随着课程的推进,不断完善本项目;
感受
整体项目完成过程中,前端页面的绘制完成较为快捷,同时思路也比较清楚。
然而,到了后面的MVC以及数据渲染方面,个人感觉比较吃力,自己又看了几遍课程的视频,做了2-3个小案例才搞明白了一些。
感觉后面还有深入学习和多加练习才行。
页面效果
项目目录
数据表结构
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80012
Source Host : localhost:3306
Source Schema : phpsite
Target Server Type : MySQL
Target Server Version : 80012
File Encoding : 65001
Date: 06/02/2020 20:42:29
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for tf_article_comm
-- ----------------------------
DROP TABLE IF EXISTS `tf_article_comm`;
CREATE TABLE `tf_article_comm` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_ur` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_article_comm
-- ----------------------------
INSERT INTO `tf_article_comm` VALUES (1, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-1', 'resources/images/img1.jpg', '');
INSERT INTO `tf_article_comm` VALUES (2, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-2', 'resources/images/img2.jpg', NULL);
INSERT INTO `tf_article_comm` VALUES (3, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-3', 'resources/images/img3.jpg', NULL);
INSERT INTO `tf_article_comm` VALUES (4, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-4', 'resources/images/img4.jpg', NULL);
INSERT INTO `tf_article_comm` VALUES (5, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-5', 'resources/images/img5.jpg', NULL);
INSERT INTO `tf_article_comm` VALUES (6, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-6', 'resources/images/img6.jpg', NULL);
INSERT INTO `tf_article_comm` VALUES (7, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-7', 'resources/images/img7.jpg', NULL);
INSERT INTO `tf_article_comm` VALUES (8, '惠若琪 |坚持热爱,活成一束光,照亮自己,成就更好的他-8', 'resources/images/img8.jpg', NULL);
-- ----------------------------
-- Table structure for tf_article_detail
-- ----------------------------
DROP TABLE IF EXISTS `tf_article_detail`;
CREATE TABLE `tf_article_detail` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_vicename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_time` datetime(0) NULL DEFAULT NULL,
`f_rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_reading` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_article_detail
-- ----------------------------
INSERT INTO `tf_article_detail` VALUES (1, '印度这一幕这要是发生在中国, 西方会多疯狂干预?', '这究竟是道德的沦丧?还是人性的扭曲?', '环球时报', '2020-02-06 20:31:39', '128', '12545', NULL);
-- ----------------------------
-- Table structure for tf_article_list
-- ----------------------------
DROP TABLE IF EXISTS `tf_article_list`;
CREATE TABLE `tf_article_list` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_vicename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_rate` int(11) NULL DEFAULT NULL,
`f_time` int(255) NULL DEFAULT NULL,
`f_mintype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_article_list
-- ----------------------------
INSERT INTO `tf_article_list` VALUES (1, '新闻', '巨蟹 去中心化交易所的赛道开始拥挤 风口要来了', '巨蟹 去中心化交易所的赛道开始拥挤 风口要来了', 'resources/images/list/list1.jpg', NULL, 2218, 46, '区块链头条');
INSERT INTO `tf_article_list` VALUES (2, '新闻', '河南许昌市公安局副局长彭杰被查 系主动投案', '河南许昌市公安局副局长彭杰被查 系主动投案', 'resources/images/list/list2.jpg', NULL, 1258, 120, '法制头条');
INSERT INTO `tf_article_list` VALUES (3, '新闻', '厦门路面塌陷事故原因:施工过程中立柱承重超负荷', '厦门路面塌陷事故原因:施工过程中立柱承重超负荷', 'resources/images/list/list1.jpg', NULL, 5426, 32, '城市头条');
INSERT INTO `tf_article_list` VALUES (4, '新闻', '瑞雪兆丰年,你的车需要这份攻略\"稳住\"雪天!', '12月16日,北京迎来第二场雪,银装素裹', 'resources/images/list/list3.jpg', NULL, 3257, 78, '今日头条');
INSERT INTO `tf_article_list` VALUES (5, '新闻', '红旗版“劳斯莱斯”实拍,比BBA开着更有面', '新车将搭载一汽最新研发3.0T V6机械增压发动机', 'resources/images/list/list2.jpg', NULL, 9854, 10, '汽车头条');
-- ----------------------------
-- Table structure for tf_article_nav
-- ----------------------------
DROP TABLE IF EXISTS `tf_article_nav`;
CREATE TABLE `tf_article_nav` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_article_nav
-- ----------------------------
INSERT INTO `tf_article_nav` VALUES (1, '头条', NULL);
INSERT INTO `tf_article_nav` VALUES (2, '热文', NULL);
INSERT INTO `tf_article_nav` VALUES (3, '直播', NULL);
INSERT INTO `tf_article_nav` VALUES (4, '新闻', NULL);
INSERT INTO `tf_article_nav` VALUES (5, '政策地图', NULL);
INSERT INTO `tf_article_nav` VALUES (6, '相对伦', NULL);
INSERT INTO `tf_article_nav` VALUES (7, '人物', NULL);
INSERT INTO `tf_article_nav` VALUES (8, '行情', NULL);
INSERT INTO `tf_article_nav` VALUES (9, '投研', NULL);
INSERT INTO `tf_article_nav` VALUES (10, '技术', NULL);
INSERT INTO `tf_article_nav` VALUES (11, '百科', NULL);
-- ----------------------------
-- Table structure for tf_comment
-- ----------------------------
DROP TABLE IF EXISTS `tf_comment`;
CREATE TABLE `tf_comment` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_comment
-- ----------------------------
INSERT INTO `tf_comment` VALUES (1, '4K单反王佳能EOS90D,新一代单反神器', '#');
INSERT INTO `tf_comment` VALUES (2, '尼康Z6/Z7即将迎来新固件', '#');
INSERT INTO `tf_comment` VALUES (3, '逃避都市光污染,震撼的8K延时寻找最美银河', '#');
INSERT INTO `tf_comment` VALUES (4, '自拍榜第一超广角自拍华为nova6 5G热卖中', '#');
INSERT INTO `tf_comment` VALUES (5, '微软公布新XBOX/国行Switch销量火爆', '#');
INSERT INTO `tf_comment` VALUES (6, '爱琴海上的璀璨明珠 丰满迷人的泳装身姿', '#');
INSERT INTO `tf_comment` VALUES (7, '律动的城市乐章2020城市摄影大赛', '#');
INSERT INTO `tf_comment` VALUES (8, '价值百万摄影机,却只是星球大战纪念品', '#');
INSERT INTO `tf_comment` VALUES (9, '有温度的课程,得到的不只是专业!', '#');
-- ----------------------------
-- Table structure for tf_footer
-- ----------------------------
DROP TABLE IF EXISTS `tf_footer`;
CREATE TABLE `tf_footer` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_footer
-- ----------------------------
INSERT INTO `tf_footer` VALUES (1, 'links', '简介', NULL, '#');
INSERT INTO `tf_footer` VALUES (2, 'links', '联系我们', NULL, '#');
INSERT INTO `tf_footer` VALUES (3, 'links', '招聘信息', NULL, '#');
INSERT INTO `tf_footer` VALUES (4, 'links', '友情链接', NULL, '#');
INSERT INTO `tf_footer` VALUES (5, 'links', '用户服务协议', NULL, '#');
INSERT INTO `tf_footer` VALUES (6, 'links', '隐私权声明', NULL, '#');
INSERT INTO `tf_footer` VALUES (7, 'links', '法律投诉声明', NULL, '#');
INSERT INTO `tf_footer` VALUES (8, 'logo', 'LOGO', NULL, NULL);
INSERT INTO `tf_footer` VALUES (9, 'info', 'copyright_info', '2019 fengniao.com. All rights reserved . 安徽闹着玩有限公司(无聊网)版权所有', NULL);
INSERT INTO `tf_footer` VALUES (10, 'info', 'copyright_info', '皖ICP证150110号 京ICP备14323013号-2 皖公网安备110108024357788号', NULL);
INSERT INTO `tf_footer` VALUES (11, 'info', 'copyright_info', '违法和不良信息举报电话: 0551-1234567 举报邮箱: admin@baidu.com', NULL);
INSERT INTO `tf_footer` VALUES (12, 'qr', '关注公众号', '', 'resources/images/Qr_Code.png');
-- ----------------------------
-- Table structure for tf_goods_detail
-- ----------------------------
DROP TABLE IF EXISTS `tf_goods_detail`;
CREATE TABLE `tf_goods_detail` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_price` decimal(10, 2) NULL DEFAULT NULL,
`f_sales` int(11) NULL DEFAULT NULL,
`f_evaluation` int(11) NULL DEFAULT NULL,
`f_rate` int(11) NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_goods_detail
-- ----------------------------
INSERT INTO `tf_goods_detail` VALUES (1, 'pathnav', '首页', NULL, NULL, NULL, NULL, NULL, '#');
INSERT INTO `tf_goods_detail` VALUES (2, 'pathnav', '图片写真', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (3, 'pathnav', '日本', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (4, 'pathnav', '颖宝宝', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (5, 'goods', '2019款美女性感写真海报墙面贴画艺', 'resources/images/goods/shop5.jpg', 26800.00, 23, 759, 97, NULL);
INSERT INTO `tf_goods_detail` VALUES (6, 'ad_goods', '韩国美女最新海报促销美妆写真图集1', 'resources/images/goods/shop1.jpg', 99.00, 980, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (7, 'ad_goods', '韩国美女最新海报促销美妆写真图集2', 'resources/images/goods/shop2.jpg', 79.00, 540, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (8, 'ad_goods', '韩国美女最新海报促销美妆写真图集3', 'resources/images/goods/shop3.jpg', 199.00, 260, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (9, 'ad_goods', '韩国美女最新海报促销美妆写真图集4', 'resources/images/goods/shop4.jpg', 399.00, 108, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (10, 'contenttype', '商品详情', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (11, 'contenttype', '案例演示', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (12, 'contenttype', '常见问题', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (13, 'contenttype', '累计评价', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (14, 'contenttype', '产品咨询', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `tf_goods_detail` VALUES (15, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for tf_headline
-- ----------------------------
DROP TABLE IF EXISTS `tf_headline`;
CREATE TABLE `tf_headline` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_pid` int(11) NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_order` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_headline
-- ----------------------------
INSERT INTO `tf_headline` VALUES (1, 1, '新闻资讯', 1);
INSERT INTO `tf_headline` VALUES (2, 1, '图片专区', 2);
INSERT INTO `tf_headline` VALUES (3, 1, '二手交易', 3);
INSERT INTO `tf_headline` VALUES (4, 1, '合作单位', 4);
INSERT INTO `tf_headline` VALUES (5, 4, '图册推荐', 1);
INSERT INTO `tf_headline` VALUES (6, 4, '写真推荐', 2);
INSERT INTO `tf_headline` VALUES (7, 4, '二手交易', 3);
INSERT INTO `tf_headline` VALUES (8, 5, '商品推荐', 1);
INSERT INTO `tf_headline` VALUES (9, 2, '中国美女', 1);
-- ----------------------------
-- Table structure for tf_imgdetail
-- ----------------------------
DROP TABLE IF EXISTS `tf_imgdetail`;
CREATE TABLE `tf_imgdetail` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_imgdetail
-- ----------------------------
INSERT INTO `tf_imgdetail` VALUES (1, 'APS-C画幅微单旗舰 索尼α6600现售10590元', 'resources/images/1.jpg', '');
INSERT INTO `tf_imgdetail` VALUES (2, 'APS-C画幅微单旗舰 索尼α6600现售10591元', 'resources/images/2.jpg', NULL);
INSERT INTO `tf_imgdetail` VALUES (3, 'APS-C画幅微单旗舰 索尼α6600现售10592元', 'resources/images/3.jpg', NULL);
INSERT INTO `tf_imgdetail` VALUES (4, 'APS-C画幅微单旗舰 索尼α6600现售10593元', 'resources/images/4.jpg', NULL);
INSERT INTO `tf_imgdetail` VALUES (5, 'APS-C画幅微单旗舰 索尼α6600现售10594元', 'resources/images/1.jpg', NULL);
-- ----------------------------
-- Table structure for tf_imglist
-- ----------------------------
DROP TABLE IF EXISTS `tf_imglist`;
CREATE TABLE `tf_imglist` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_typename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_typedes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgdes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_imglist
-- ----------------------------
INSERT INTO `tf_imglist` VALUES (2, '美女', '纵观摄影艺术', 'resources/images/img1.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (3, '美女', NULL, 'resources/images/img2.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (4, '美女', NULL, 'resources/images/img3.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (5, '美女', NULL, 'resources/images/img4.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (7, '健康', '纵观摄影艺术', 'resources/images/img5.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (8, '健康', NULL, 'resources/images/img6.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (9, '健康', NULL, 'resources/images/img7.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (10, '健康', NULL, 'resources/images/img8.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (12, '青春', '纵观摄影艺术', 'resources/images/img1.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (13, '青春', NULL, 'resources/images/img2.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (14, '青春', NULL, 'resources/images/img3.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
INSERT INTO `tf_imglist` VALUES (15, '青春', NULL, 'resources/images/img4.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
-- ----------------------------
-- Table structure for tf_index_friend
-- ----------------------------
DROP TABLE IF EXISTS `tf_index_friend`;
CREATE TABLE `tf_index_friend` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_index_friend
-- ----------------------------
INSERT INTO `tf_index_friend` VALUES (1, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (2, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (3, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (4, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (5, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (6, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (7, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (8, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (9, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (10, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (11, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (12, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (13, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (14, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (15, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (16, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (17, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (18, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (19, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (20, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (21, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (22, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (23, 'html中文网', '#');
INSERT INTO `tf_index_friend` VALUES (24, 'python中文网', '#');
INSERT INTO `tf_index_friend` VALUES (25, 'php中文网', '#');
INSERT INTO `tf_index_friend` VALUES (26, 'html中文网', '#');
-- ----------------------------
-- Table structure for tf_index_header
-- ----------------------------
DROP TABLE IF EXISTS `tf_index_header`;
CREATE TABLE `tf_index_header` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_grouptype` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_index_header
-- ----------------------------
INSERT INTO `tf_index_header` VALUES (1, 'img', 'logo', 'resources/images/logo.png', NULL);
INSERT INTO `tf_index_header` VALUES (2, 'title', '资料学习', NULL, NULL);
INSERT INTO `tf_index_header` VALUES (3, 'links', '器材', '#', 2);
INSERT INTO `tf_index_header` VALUES (4, 'links', '大师', '#', 2);
INSERT INTO `tf_index_header` VALUES (5, 'links', '学院', '#', 2);
INSERT INTO `tf_index_header` VALUES (6, 'links', '实战', '#', 2);
INSERT INTO `tf_index_header` VALUES (7, 'links', '大赛', '#', 2);
INSERT INTO `tf_index_header` VALUES (8, 'links', '裤子', '#', 2);
INSERT INTO `tf_index_header` VALUES (9, 'links', '影视', '#', 2);
INSERT INTO `tf_index_header` VALUES (10, 'links', '其它', '#', 2);
INSERT INTO `tf_index_header` VALUES (11, 'title', '爱好姐妹', NULL, NULL);
INSERT INTO `tf_index_header` VALUES (12, 'links', '有品', '#', 11);
INSERT INTO `tf_index_header` VALUES (13, 'links', '图片', '#', 11);
INSERT INTO `tf_index_header` VALUES (14, 'links', '喝水', '#', 11);
INSERT INTO `tf_index_header` VALUES (15, 'links', '飞机', '#', 11);
INSERT INTO `tf_index_header` VALUES (16, 'links', '坦克', '#', 11);
INSERT INTO `tf_index_header` VALUES (17, 'links', '气球', '#', 11);
INSERT INTO `tf_index_header` VALUES (18, 'links', '毛线', '#', 11);
INSERT INTO `tf_index_header` VALUES (19, 'links', '其它', '#', 11);
INSERT INTO `tf_index_header` VALUES (20, 'title', '软件技能', NULL, NULL);
INSERT INTO `tf_index_header` VALUES (21, NULL, NULL, NULL, 20);
INSERT INTO `tf_index_header` VALUES (22, 'links', '学习', '#', 20);
INSERT INTO `tf_index_header` VALUES (23, 'links', '爱国', '#', 20);
INSERT INTO `tf_index_header` VALUES (24, 'links', '敬业', '#', 20);
INSERT INTO `tf_index_header` VALUES (25, 'links', '友善', '#', 20);
INSERT INTO `tf_index_header` VALUES (26, 'links', '富强', '#', 20);
INSERT INTO `tf_index_header` VALUES (27, 'links', '互助', '#', 20);
INSERT INTO `tf_index_header` VALUES (28, 'links', '仁义', '#', 20);
INSERT INTO `tf_index_header` VALUES (29, 'title', '编程美女', NULL, NULL);
INSERT INTO `tf_index_header` VALUES (30, 'links', '吃饭', '#', 29);
INSERT INTO `tf_index_header` VALUES (31, 'links', '周易', '#', 29);
INSERT INTO `tf_index_header` VALUES (32, 'links', '黄山', '#', 29);
INSERT INTO `tf_index_header` VALUES (33, 'links', '合肥', '#', 29);
INSERT INTO `tf_index_header` VALUES (34, 'links', '上海', '#', 29);
INSERT INTO `tf_index_header` VALUES (35, 'links', '杭州', '#', 29);
INSERT INTO `tf_index_header` VALUES (36, 'links', '北京', '#', 29);
INSERT INTO `tf_index_header` VALUES (37, 'links', '其它', '#', 29);
INSERT INTO `tf_index_header` VALUES (39, 'img', 'banner_left', 'resources/images/2.jpg', NULL);
INSERT INTO `tf_index_header` VALUES (40, 'img', 'banner_right', 'resources/images/banner-right.jpg', NULL);
INSERT INTO `tf_index_header` VALUES (41, 'links', '其它', '#', 20);
-- ----------------------------
-- Table structure for tf_index_news
-- ----------------------------
DROP TABLE IF EXISTS `tf_index_news`;
CREATE TABLE `tf_index_news` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_listcontent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_index_news
-- ----------------------------
INSERT INTO `tf_index_news` VALUES (1, '封推图-1', 'img', '', 'resources/images/news.jpg');
INSERT INTO `tf_index_news` VALUES (2, '三星Note10发布搭载挖孔前摄', 'img', '', 'resources/images/n-2.jpg');
INSERT INTO `tf_index_news` VALUES (3, '小米公布1亿像素手机信息', 'img', '', 'resources/images/n-3.jpg');
INSERT INTO `tf_index_news` VALUES (4, '新闻封推', '标题', '大隐于市的摄影师,薇薇安·迈尔', NULL);
INSERT INTO `tf_index_news` VALUES (5, NULL, '新闻', '佳能注册相机无线充电和眼控对焦专利', NULL);
INSERT INTO `tf_index_news` VALUES (6, NULL, '新闻', 'Entaniya宣布推出Super 35 PL卡口鱼眼镜头', NULL);
INSERT INTO `tf_index_news` VALUES (7, NULL, '新闻', '轻便灵巧可变形 JOBY入门迷你三脚架套装试用', NULL);
INSERT INTO `tf_index_news` VALUES (8, NULL, '新闻', '乐摄宝Photo Active BP 300 AW背包评测', NULL);
INSERT INTO `tf_index_news` VALUES (9, NULL, '新闻', '佳能注册相机无线充电和眼控对焦专利', NULL);
INSERT INTO `tf_index_news` VALUES (10, NULL, '新闻', 'Entaniya宣布推出Super 35 PL卡口鱼眼镜头', NULL);
INSERT INTO `tf_index_news` VALUES (11, NULL, '新闻', '轻便灵巧可变形 JOBY入门迷你三脚架套装试用', NULL);
INSERT INTO `tf_index_news` VALUES (12, NULL, '新闻', '乐摄宝Photo Active BP 300 AW背包评测', NULL);
INSERT INTO `tf_index_news` VALUES (13, NULL, '新闻', '乐摄宝Photo Active BP 300 AW背包评测', NULL);
INSERT INTO `tf_index_news` VALUES (14, '促销封推', '标题', '元旦春节,双节联动,备年货啦!', NULL);
INSERT INTO `tf_index_news` VALUES (15, NULL, '促销', '佳能 EOS RP 12899元起', NULL);
INSERT INTO `tf_index_news` VALUES (16, NULL, '促销', '定焦,变焦, 新人小白如何选择?这三款值得买', NULL);
INSERT INTO `tf_index_news` VALUES (17, NULL, '促销', '新一代入门神器? 佳能EOS 850D将到来', NULL);
INSERT INTO `tf_index_news` VALUES (18, NULL, '促销', '无低通次旗舰 D7500套机6899元', NULL);
INSERT INTO `tf_index_news` VALUES (19, NULL, '促销', '佳能注册相机无线充电和眼控对焦专利', NULL);
INSERT INTO `tf_index_news` VALUES (20, NULL, '促销', '复古全幅单反 尼康Df套机14500元', NULL);
INSERT INTO `tf_index_news` VALUES (21, NULL, '促销', '索尼α7R IV超广套装售42698元', NULL);
INSERT INTO `tf_index_news` VALUES (22, NULL, '促销', 'RF大三元长焦 RF70-200mm售17699', NULL);
INSERT INTO `tf_index_news` VALUES (23, NULL, '促销', '有所保留 佳能EOS-1D X III再曝新功能', NULL);
-- ----------------------------
-- Table structure for tf_pages
-- ----------------------------
DROP TABLE IF EXISTS `tf_pages`;
CREATE TABLE `tf_pages` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`f_type` int(11) NULL DEFAULT NULL,
`f_level` int(11) NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_divname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_pages
-- ----------------------------
INSERT INTO `tf_pages` VALUES (1, '全站首页', 1, 1, 'index.php', 'page-index');
INSERT INTO `tf_pages` VALUES (2, '图片站', 2, 1, 'image_list.php', NULL);
INSERT INTO `tf_pages` VALUES (3, '图片详情', 2, 1, 'image_detail.php', NULL);
INSERT INTO `tf_pages` VALUES (4, '二手商品', 4, 1, 'shop_index.php', NULL);
INSERT INTO `tf_pages` VALUES (5, '商品列表', 4, 1, 'shop_list.php', NULL);
INSERT INTO `tf_pages` VALUES (6, '商品详情', 4, 1, 'shop_detail.php', NULL);
INSERT INTO `tf_pages` VALUES (7, '文章列表', 6, 1, 'article_list.php', NULL);
INSERT INTO `tf_pages` VALUES (8, '文章详情', 6, 1, 'article_detail.php', NULL);
INSERT INTO `tf_pages` VALUES (9, '登录', 8, 1, '#', NULL);
INSERT INTO `tf_pages` VALUES (10, '免费注册', 8, 1, '#', NULL);
-- ----------------------------
-- Table structure for tf_reply
-- ----------------------------
DROP TABLE IF EXISTS `tf_reply`;
CREATE TABLE `tf_reply` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_goodsid` int(11) NULL DEFAULT NULL,
`f_replyid` int(11) NULL DEFAULT NULL,
`f_replyname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_userimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_reply
-- ----------------------------
INSERT INTO `tf_reply` VALUES (1, 5, 103, '南城无贼丶潇子', 'resources/images/user1.jpg', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-03 15:56:41');
INSERT INTO `tf_reply` VALUES (2, 5, 99, '通天圣人二君', 'resources/images/user2.jpg', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-03 15:56:37');
INSERT INTO `tf_reply` VALUES (3, 5, 45, '无忧无虑', 'resources/images/user3.jpg', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-04 15:56:33');
INSERT INTO `tf_reply` VALUES (4, 5, 76, '天道酌勤', 'resources/images/user.png', 'php中文网,是一个有温度,有思想的学习平台', '2020-01-31 15:56:27');
INSERT INTO `tf_reply` VALUES (5, 5, 98, '无相真君·李某人', 'resources/images/user4.JPEG', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-04 15:56:23');
INSERT INTO `tf_reply` VALUES (6, 5, 1054, '萧何萧瑟-伊人憔', 'resources/images/user.png', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-04 15:56:16');
-- ----------------------------
-- Table structure for tf_second_hand
-- ----------------------------
DROP TABLE IF EXISTS `tf_second_hand`;
CREATE TABLE `tf_second_hand` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_typedes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_price` decimal(10, 2) NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_second_hand
-- ----------------------------
INSERT INTO `tf_second_hand` VALUES (1, 'title', '抢好货', ' 0低价,便捷,安全,快速', NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (2, 'nav', '热门分类', NULL, NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (3, 'links', '美女写真', NULL, NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (4, 'links', '日本美女', NULL, NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (5, 'links', '美国美女', NULL, NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (6, 'links', '国内美女', NULL, NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (7, 'links', 'AV美女', NULL, NULL, NULL, NULL);
INSERT INTO `tf_second_hand` VALUES (8, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图1', 'resources/images/goods/shop1.jpg', 345.00);
INSERT INTO `tf_second_hand` VALUES (9, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图2', 'resources/images/goods/shop2.jpg', 128.00);
INSERT INTO `tf_second_hand` VALUES (10, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图3', 'resources/images/goods/shop3.jpg', 789.00);
INSERT INTO `tf_second_hand` VALUES (11, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图4', 'resources/images/goods/shop4.jpg', 542.00);
INSERT INTO `tf_second_hand` VALUES (12, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图5', 'resources/images/goods/shop5.jpg', 368.00);
INSERT INTO `tf_second_hand` VALUES (13, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图6', 'resources/images/goods/shop6.jpg', 188.00);
INSERT INTO `tf_second_hand` VALUES (14, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图7', 'resources/images/goods/shop7.jpg', 299.00);
INSERT INTO `tf_second_hand` VALUES (15, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图8', 'resources/images/goods/shop8.jpg', 99.00);
INSERT INTO `tf_second_hand` VALUES (16, 'entry_top', '二手闲置', NULL, NULL, 'resources/images/entry/1.png', NULL);
INSERT INTO `tf_second_hand` VALUES (17, 'entry_top', '器材维修', NULL, NULL, 'resources/images/entry/2.png', NULL);
INSERT INTO `tf_second_hand` VALUES (18, 'entry_top', '蜂鸟鉴定', NULL, NULL, 'resources/images/entry/3.png', NULL);
INSERT INTO `tf_second_hand` VALUES (19, 'entry_top', '器材租赁', NULL, NULL, 'resources/images/entry/4.png', NULL);
INSERT INTO `tf_second_hand` VALUES (20, 'entry_bottom', '回收流程', NULL, NULL, 'resources/images/entry/ent1.png', NULL);
INSERT INTO `tf_second_hand` VALUES (21, 'entry_bottom', '蜂鸟回收', NULL, NULL, 'resources/images/entry/ent2.jpg', NULL);
INSERT INTO `tf_second_hand` VALUES (22, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图9', 'resources/images/goods/shop3.jpg', 375.00);
INSERT INTO `tf_second_hand` VALUES (23, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图10', 'resources/images/goods/shop6.jpg', 587.00);
INSERT INTO `tf_second_hand` VALUES (24, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图11', 'resources/images/goods/shop8.jpg', 421.00);
INSERT INTO `tf_second_hand` VALUES (25, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图12', 'resources/images/goods/shop7.jpg', 184.00);
INSERT INTO `tf_second_hand` VALUES (26, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图13', 'resources/images/goods/shop6.jpg', 9.90);
-- ----------------------------
-- Table structure for tf_shop_banner
-- ----------------------------
DROP TABLE IF EXISTS `tf_shop_banner`;
CREATE TABLE `tf_shop_banner` (
`f_id` int(11) NOT NULL AUTO_INCREMENT,
`f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_typename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_typedesc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`f_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tf_shop_banner
-- ----------------------------
INSERT INTO `tf_shop_banner` VALUES (1, 'nav', '导航', '顶部导航', '首页', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (2, 'nav', '', '', '数码3C', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (3, 'nav', '', '', '免费素材', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (11, 'navlist', NULL, '数码产品', '微单相机', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (4, 'nav', NULL, NULL, '摄影器材', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (5, 'nav', NULL, NULL, '阳光交易', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (6, 'nav', NULL, NULL, '跨境电商', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (7, 'nav', NULL, NULL, '商业素材', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (8, 'nav', NULL, NULL, '软件授权', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (9, 'nav', NULL, NULL, '商业推广', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (10, 'navlist', '全部商品分类', '数码产品', '单反相机', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (12, 'navlist', NULL, '数码产品', '笔记本电脑', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (13, 'navlist', NULL, '数码产品', '摄影机', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (14, 'navlist', NULL, '数码产品', '稳定器', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (15, 'navlist', NULL, '数码产品', '储存卡', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (16, 'navlist', NULL, '常用软件', '修图软件', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (17, 'navlist', NULL, '常用软件', '后期处理', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (18, 'navlist', NULL, '常用软件', '调色软件', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (19, 'navlist', NULL, '常用软件', 'Final Cut', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (20, 'navlist', NULL, '常用软件', 'Adobe', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (21, 'navlist', NULL, '常用软件', '其它', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (22, 'navlist', NULL, '商业推广', '公众号', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (23, 'navlist', NULL, '商业推广', '小程序', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (24, 'navlist', NULL, '商业推广', '今日头条', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (25, 'navlist', NULL, '商业推广', 'VLOG', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (26, 'navlist', NULL, '商业推广', '抖音', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (27, 'navlist', NULL, '商业推广', '其它平台', NULL, NULL);
INSERT INTO `tf_shop_banner` VALUES (28, 'banner', NULL, NULL, '蜂鸟网', 'resources/images/2.jpg', '');
SET FOREIGN_KEY_CHECKS = 1;
源码下载
链接:https://share.weiyun.com/5myP3zI 密码:s86ad3