search

博客列表 >PDO与MVC的初次实战（春节大作业）--PHP十期培训线上班

PDO与MVC的初次实战（春节大作业）--PHP十期培训线上班

Miss灬懒虫
Miss灬懒虫原创
2020年02月10日 11:26:38928浏览

项目总结

概述

本次实战，主要完成三方面内容：1-页面绘制；2-MVC结构实现；3-PDO数据访问与数据渲染；
实现页面包括：全站首页，图片站，图片详情页，二手商品，商品列表，商品详情，文章列表，文章详情等几个页面。

缺点

1-项目入口文件，未进行合并，缺少类路由的访问方法;
2-数据模型方面，未针对组件进行归类整理，造成在控制器中代码重复调用的问题；
3-项目代码方面，应该还有更好的方式方法，但是未进行试验，因为个人感觉能力以及相关知识方面还欠缺较多，希望能随着课程的推进，不断完善本项目；

感受

整体项目完成过程中，前端页面的绘制完成较为快捷，同时思路也比较清楚。
然而，到了后面的MVC以及数据渲染方面，个人感觉比较吃力，自己又看了几遍课程的视频，做了2-3个小案例才搞明白了一些。
感觉后面还有深入学习和多加练习才行。

页面效果








项目目录

数据表结构

  1. /*
  2.  Navicat Premium Data Transfer
  4.  Source Server         : localhost_3306
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 80012
  7.  Source Host           : localhost:3306
  8.  Source Schema         : phpsite
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 80012
  12.  File Encoding         : 65001
  14.  Date: 06/02/2020 20:42:29
  15. */
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  20. -- ----------------------------
  21. -- Table structure for tf_article_comm
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `tf_article_comm`;
  24. CREATE TABLE `tf_article_comm`  (
  25.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  26.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  27.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  28.   `f_ur` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  29.   PRIMARY KEY (`f_id`) USING BTREE
  30. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  32. -- ----------------------------
  33. -- Records of tf_article_comm
  34. -- ----------------------------
  35. INSERT INTO `tf_article_comm` VALUES (1, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-1', 'resources/images/img1.jpg', '');
  36. INSERT INTO `tf_article_comm` VALUES (2, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-2', 'resources/images/img2.jpg', NULL);
  37. INSERT INTO `tf_article_comm` VALUES (3, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-3', 'resources/images/img3.jpg', NULL);
  38. INSERT INTO `tf_article_comm` VALUES (4, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-4', 'resources/images/img4.jpg', NULL);
  39. INSERT INTO `tf_article_comm` VALUES (5, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-5', 'resources/images/img5.jpg', NULL);
  40. INSERT INTO `tf_article_comm` VALUES (6, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-6', 'resources/images/img6.jpg', NULL);
  41. INSERT INTO `tf_article_comm` VALUES (7, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-7', 'resources/images/img7.jpg', NULL);
  42. INSERT INTO `tf_article_comm` VALUES (8, '惠若琪 |坚持热爱，活成一束光，照亮自己，成就更好的他-8', 'resources/images/img8.jpg', NULL);
  44. -- ----------------------------
  45. -- Table structure for tf_article_detail
  46. -- ----------------------------
  47. DROP TABLE IF EXISTS `tf_article_detail`;
  48. CREATE TABLE `tf_article_detail`  (
  49.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  50.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  51.   `f_vicename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  52.   `f_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  53.   `f_time` datetime(0) NULL DEFAULT NULL,
  54.   `f_rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  55.   `f_reading` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  56.   `f_author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  57.   PRIMARY KEY (`f_id`) USING BTREE
  58. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  60. -- ----------------------------
  61. -- Records of tf_article_detail
  62. -- ----------------------------
  63. INSERT INTO `tf_article_detail` VALUES (1, '印度这一幕这要是发生在中国, 西方会多疯狂干预?', '这究竟是道德的沦丧？还是人性的扭曲？', '环球时报', '2020-02-06 20:31:39', '128', '12545', NULL);
  65. -- ----------------------------
  66. -- Table structure for tf_article_list
  67. -- ----------------------------
  68. DROP TABLE IF EXISTS `tf_article_list`;
  69. CREATE TABLE `tf_article_list`  (
  70.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  71.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  72.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  73.   `f_vicename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  74.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  75.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  76.   `f_rate` int(11) NULL DEFAULT NULL,
  77.   `f_time` int(255) NULL DEFAULT NULL,
  78.   `f_mintype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  79.   PRIMARY KEY (`f_id`) USING BTREE
  80. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  82. -- ----------------------------
  83. -- Records of tf_article_list
  84. -- ----------------------------
  85. INSERT INTO `tf_article_list` VALUES (1, '新闻', '巨蟹 去中心化交易所的赛道开始拥挤 风口要来了', '巨蟹 去中心化交易所的赛道开始拥挤 风口要来了', 'resources/images/list/list1.jpg', NULL, 2218, 46, '区块链头条');
  86. INSERT INTO `tf_article_list` VALUES (2, '新闻', '河南许昌市公安局副局长彭杰被查 系主动投案', '河南许昌市公安局副局长彭杰被查 系主动投案', 'resources/images/list/list2.jpg', NULL, 1258, 120, '法制头条');
  87. INSERT INTO `tf_article_list` VALUES (3, '新闻', '厦门路面塌陷事故原因:施工过程中立柱承重超负荷', '厦门路面塌陷事故原因:施工过程中立柱承重超负荷', 'resources/images/list/list1.jpg', NULL, 5426, 32, '城市头条');
  88. INSERT INTO `tf_article_list` VALUES (4, '新闻', '瑞雪兆丰年,你的车需要这份攻略\"稳住\"雪天!', '12月16日,北京迎来第二场雪,银装素裹', 'resources/images/list/list3.jpg', NULL, 3257, 78, '今日头条');
  89. INSERT INTO `tf_article_list` VALUES (5, '新闻', '红旗版“劳斯莱斯”实拍,比BBA开着更有面', '新车将搭载一汽最新研发3.0T V6机械增压发动机', 'resources/images/list/list2.jpg', NULL, 9854, 10, '汽车头条');
  91. -- ----------------------------
  92. -- Table structure for tf_article_nav
  93. -- ----------------------------
  94. DROP TABLE IF EXISTS `tf_article_nav`;
  95. CREATE TABLE `tf_article_nav`  (
  96.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  97.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  98.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  99.   PRIMARY KEY (`f_id`) USING BTREE
  100. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  102. -- ----------------------------
  103. -- Records of tf_article_nav
  104. -- ----------------------------
  105. INSERT INTO `tf_article_nav` VALUES (1, '头条', NULL);
  106. INSERT INTO `tf_article_nav` VALUES (2, '热文', NULL);
  107. INSERT INTO `tf_article_nav` VALUES (3, '直播', NULL);
  108. INSERT INTO `tf_article_nav` VALUES (4, '新闻', NULL);
  109. INSERT INTO `tf_article_nav` VALUES (5, '政策地图', NULL);
  110. INSERT INTO `tf_article_nav` VALUES (6, '相对伦', NULL);
  111. INSERT INTO `tf_article_nav` VALUES (7, '人物', NULL);
  112. INSERT INTO `tf_article_nav` VALUES (8, '行情', NULL);
  113. INSERT INTO `tf_article_nav` VALUES (9, '投研', NULL);
  114. INSERT INTO `tf_article_nav` VALUES (10, '技术', NULL);
  115. INSERT INTO `tf_article_nav` VALUES (11, '百科', NULL);
  117. -- ----------------------------
  118. -- Table structure for tf_comment
  119. -- ----------------------------
  120. DROP TABLE IF EXISTS `tf_comment`;
  121. CREATE TABLE `tf_comment`  (
  122.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  123.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  124.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  125.   PRIMARY KEY (`f_id`) USING BTREE
  126. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  128. -- ----------------------------
  129. -- Records of tf_comment
  130. -- ----------------------------
  131. INSERT INTO `tf_comment` VALUES (1, '4K单反王佳能EOS90D,新一代单反神器', '#');
  132. INSERT INTO `tf_comment` VALUES (2, '尼康Z6/Z7即将迎来新固件', '#');
  133. INSERT INTO `tf_comment` VALUES (3, '逃避都市光污染,震撼的8K延时寻找最美银河', '#');
  134. INSERT INTO `tf_comment` VALUES (4, '自拍榜第一超广角自拍华为nova6 5G热卖中', '#');
  135. INSERT INTO `tf_comment` VALUES (5, '微软公布新XBOX/国行Switch销量火爆', '#');
  136. INSERT INTO `tf_comment` VALUES (6, '爱琴海上的璀璨明珠 丰满迷人的泳装身姿', '#');
  137. INSERT INTO `tf_comment` VALUES (7, '律动的城市乐章2020城市摄影大赛', '#');
  138. INSERT INTO `tf_comment` VALUES (8, '价值百万摄影机,却只是星球大战纪念品', '#');
  139. INSERT INTO `tf_comment` VALUES (9, '有温度的课程，得到的不只是专业！', '#');
  141. -- ----------------------------
  142. -- Table structure for tf_footer
  143. -- ----------------------------
  144. DROP TABLE IF EXISTS `tf_footer`;
  145. CREATE TABLE `tf_footer`  (
  146.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  147.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  148.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  149.   `f_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  150.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  151.   PRIMARY KEY (`f_id`) USING BTREE
  152. ) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  154. -- ----------------------------
  155. -- Records of tf_footer
  156. -- ----------------------------
  157. INSERT INTO `tf_footer` VALUES (1, 'links', '简介', NULL, '#');
  158. INSERT INTO `tf_footer` VALUES (2, 'links', '联系我们', NULL, '#');
  159. INSERT INTO `tf_footer` VALUES (3, 'links', '招聘信息', NULL, '#');
  160. INSERT INTO `tf_footer` VALUES (4, 'links', '友情链接', NULL, '#');
  161. INSERT INTO `tf_footer` VALUES (5, 'links', '用户服务协议', NULL, '#');
  162. INSERT INTO `tf_footer` VALUES (6, 'links', '隐私权声明', NULL, '#');
  163. INSERT INTO `tf_footer` VALUES (7, 'links', '法律投诉声明', NULL, '#');
  164. INSERT INTO `tf_footer` VALUES (8, 'logo', 'LOGO', NULL, NULL);
  165. INSERT INTO `tf_footer` VALUES (9, 'info', 'copyright_info', '2019 fengniao.com. All rights reserved . 安徽闹着玩有限公司（无聊网）版权所有', NULL);
  166. INSERT INTO `tf_footer` VALUES (10, 'info', 'copyright_info', '皖ICP证150110号 京ICP备14323013号-2 皖公网安备110108024357788号', NULL);
  167. INSERT INTO `tf_footer` VALUES (11, 'info', 'copyright_info', '违法和不良信息举报电话: 0551-1234567 举报邮箱: admin@baidu.com', NULL);
  168. INSERT INTO `tf_footer` VALUES (12, 'qr', '关注公众号', '', 'resources/images/Qr_Code.png');
  170. -- ----------------------------
  171. -- Table structure for tf_goods_detail
  172. -- ----------------------------
  173. DROP TABLE IF EXISTS `tf_goods_detail`;
  174. CREATE TABLE `tf_goods_detail`  (
  175.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  176.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  177.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  178.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  179.   `f_price` decimal(10, 2) NULL DEFAULT NULL,
  180.   `f_sales` int(11) NULL DEFAULT NULL,
  181.   `f_evaluation` int(11) NULL DEFAULT NULL,
  182.   `f_rate` int(11) NULL DEFAULT NULL,
  183.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  184.   PRIMARY KEY (`f_id`) USING BTREE
  185. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  187. -- ----------------------------
  188. -- Records of tf_goods_detail
  189. -- ----------------------------
  190. INSERT INTO `tf_goods_detail` VALUES (1, 'pathnav', '首页', NULL, NULL, NULL, NULL, NULL, '#');
  191. INSERT INTO `tf_goods_detail` VALUES (2, 'pathnav', '图片写真', NULL, NULL, NULL, NULL, NULL, NULL);
  192. INSERT INTO `tf_goods_detail` VALUES (3, 'pathnav', '日本', NULL, NULL, NULL, NULL, NULL, NULL);
  193. INSERT INTO `tf_goods_detail` VALUES (4, 'pathnav', '颖宝宝', NULL, NULL, NULL, NULL, NULL, NULL);
  194. INSERT INTO `tf_goods_detail` VALUES (5, 'goods', '2019款美女性感写真海报墙面贴画艺', 'resources/images/goods/shop5.jpg', 26800.00, 23, 759, 97, NULL);
  195. INSERT INTO `tf_goods_detail` VALUES (6, 'ad_goods', '韩国美女最新海报促销美妆写真图集1', 'resources/images/goods/shop1.jpg', 99.00, 980, NULL, NULL, NULL);
  196. INSERT INTO `tf_goods_detail` VALUES (7, 'ad_goods', '韩国美女最新海报促销美妆写真图集2', 'resources/images/goods/shop2.jpg', 79.00, 540, NULL, NULL, NULL);
  197. INSERT INTO `tf_goods_detail` VALUES (8, 'ad_goods', '韩国美女最新海报促销美妆写真图集3', 'resources/images/goods/shop3.jpg', 199.00, 260, NULL, NULL, NULL);
  198. INSERT INTO `tf_goods_detail` VALUES (9, 'ad_goods', '韩国美女最新海报促销美妆写真图集4', 'resources/images/goods/shop4.jpg', 399.00, 108, NULL, NULL, NULL);
  199. INSERT INTO `tf_goods_detail` VALUES (10, 'contenttype', '商品详情', NULL, NULL, NULL, NULL, NULL, NULL);
  200. INSERT INTO `tf_goods_detail` VALUES (11, 'contenttype', '案例演示', NULL, NULL, NULL, NULL, NULL, NULL);
  201. INSERT INTO `tf_goods_detail` VALUES (12, 'contenttype', '常见问题', NULL, NULL, NULL, NULL, NULL, NULL);
  202. INSERT INTO `tf_goods_detail` VALUES (13, 'contenttype', '累计评价', NULL, NULL, NULL, NULL, NULL, NULL);
  203. INSERT INTO `tf_goods_detail` VALUES (14, 'contenttype', '产品咨询', NULL, NULL, NULL, NULL, NULL, NULL);
  204. INSERT INTO `tf_goods_detail` VALUES (15, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
  206. -- ----------------------------
  207. -- Table structure for tf_headline
  208. -- ----------------------------
  209. DROP TABLE IF EXISTS `tf_headline`;
  210. CREATE TABLE `tf_headline`  (
  211.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  212.   `f_pid` int(11) NULL DEFAULT NULL,
  213.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  214.   `f_order` int(11) NULL DEFAULT NULL,
  215.   PRIMARY KEY (`f_id`) USING BTREE
  216. ) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  218. -- ----------------------------
  219. -- Records of tf_headline
  220. -- ----------------------------
  221. INSERT INTO `tf_headline` VALUES (1, 1, '新闻资讯', 1);
  222. INSERT INTO `tf_headline` VALUES (2, 1, '图片专区', 2);
  223. INSERT INTO `tf_headline` VALUES (3, 1, '二手交易', 3);
  224. INSERT INTO `tf_headline` VALUES (4, 1, '合作单位', 4);
  225. INSERT INTO `tf_headline` VALUES (5, 4, '图册推荐', 1);
  226. INSERT INTO `tf_headline` VALUES (6, 4, '写真推荐', 2);
  227. INSERT INTO `tf_headline` VALUES (7, 4, '二手交易', 3);
  228. INSERT INTO `tf_headline` VALUES (8, 5, '商品推荐', 1);
  229. INSERT INTO `tf_headline` VALUES (9, 2, '中国美女', 1);
  231. -- ----------------------------
  232. -- Table structure for tf_imgdetail
  233. -- ----------------------------
  234. DROP TABLE IF EXISTS `tf_imgdetail`;
  235. CREATE TABLE `tf_imgdetail`  (
  236.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  237.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  238.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  239.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  240.   PRIMARY KEY (`f_id`) USING BTREE
  241. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  243. -- ----------------------------
  244. -- Records of tf_imgdetail
  245. -- ----------------------------
  246. INSERT INTO `tf_imgdetail` VALUES (1, 'APS-C画幅微单旗舰 索尼α6600现售10590元', 'resources/images/1.jpg', '');
  247. INSERT INTO `tf_imgdetail` VALUES (2, 'APS-C画幅微单旗舰 索尼α6600现售10591元', 'resources/images/2.jpg', NULL);
  248. INSERT INTO `tf_imgdetail` VALUES (3, 'APS-C画幅微单旗舰 索尼α6600现售10592元', 'resources/images/3.jpg', NULL);
  249. INSERT INTO `tf_imgdetail` VALUES (4, 'APS-C画幅微单旗舰 索尼α6600现售10593元', 'resources/images/4.jpg', NULL);
  250. INSERT INTO `tf_imgdetail` VALUES (5, 'APS-C画幅微单旗舰 索尼α6600现售10594元', 'resources/images/1.jpg', NULL);
  252. -- ----------------------------
  253. -- Table structure for tf_imglist
  254. -- ----------------------------
  255. DROP TABLE IF EXISTS `tf_imglist`;
  256. CREATE TABLE `tf_imglist`  (
  257.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  258.   `f_typename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  259.   `f_typedes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  260.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  261.   `f_imgdes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  262.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  263.   PRIMARY KEY (`f_id`) USING BTREE
  264. ) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  266. -- ----------------------------
  267. -- Records of tf_imglist
  268. -- ----------------------------
  269. INSERT INTO `tf_imglist` VALUES (2, '美女', '纵观摄影艺术', 'resources/images/img1.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  270. INSERT INTO `tf_imglist` VALUES (3, '美女', NULL, 'resources/images/img2.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  271. INSERT INTO `tf_imglist` VALUES (4, '美女', NULL, 'resources/images/img3.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  272. INSERT INTO `tf_imglist` VALUES (5, '美女', NULL, 'resources/images/img4.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  273. INSERT INTO `tf_imglist` VALUES (7, '健康', '纵观摄影艺术', 'resources/images/img5.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  274. INSERT INTO `tf_imglist` VALUES (8, '健康', NULL, 'resources/images/img6.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  275. INSERT INTO `tf_imglist` VALUES (9, '健康', NULL, 'resources/images/img7.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  276. INSERT INTO `tf_imglist` VALUES (10, '健康', NULL, 'resources/images/img8.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  277. INSERT INTO `tf_imglist` VALUES (12, '青春', '纵观摄影艺术', 'resources/images/img1.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  278. INSERT INTO `tf_imglist` VALUES (13, '青春', NULL, 'resources/images/img2.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  279. INSERT INTO `tf_imglist` VALUES (14, '青春', NULL, 'resources/images/img3.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  280. INSERT INTO `tf_imglist` VALUES (15, '青春', NULL, 'resources/images/img4.jpg', '阴沉夏日的柔美身姿 复古少女的藕荷色心情', NULL);
  282. -- ----------------------------
  283. -- Table structure for tf_index_friend
  284. -- ----------------------------
  285. DROP TABLE IF EXISTS `tf_index_friend`;
  286. CREATE TABLE `tf_index_friend`  (
  287.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  288.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  289.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  290.   PRIMARY KEY (`f_id`) USING BTREE
  291. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  293. -- ----------------------------
  294. -- Records of tf_index_friend
  295. -- ----------------------------
  296. INSERT INTO `tf_index_friend` VALUES (1, 'php中文网', '#');
  297. INSERT INTO `tf_index_friend` VALUES (2, 'html中文网', '#');
  298. INSERT INTO `tf_index_friend` VALUES (3, 'python中文网', '#');
  299. INSERT INTO `tf_index_friend` VALUES (4, 'php中文网', '#');
  300. INSERT INTO `tf_index_friend` VALUES (5, 'html中文网', '#');
  301. INSERT INTO `tf_index_friend` VALUES (6, 'python中文网', '#');
  302. INSERT INTO `tf_index_friend` VALUES (7, 'php中文网', '#');
  303. INSERT INTO `tf_index_friend` VALUES (8, 'html中文网', '#');
  304. INSERT INTO `tf_index_friend` VALUES (9, 'python中文网', '#');
  305. INSERT INTO `tf_index_friend` VALUES (10, 'php中文网', '#');
  306. INSERT INTO `tf_index_friend` VALUES (11, 'html中文网', '#');
  307. INSERT INTO `tf_index_friend` VALUES (12, 'python中文网', '#');
  308. INSERT INTO `tf_index_friend` VALUES (13, 'php中文网', '#');
  309. INSERT INTO `tf_index_friend` VALUES (14, 'html中文网', '#');
  310. INSERT INTO `tf_index_friend` VALUES (15, 'python中文网', '#');
  311. INSERT INTO `tf_index_friend` VALUES (16, 'php中文网', '#');
  312. INSERT INTO `tf_index_friend` VALUES (17, 'html中文网', '#');
  313. INSERT INTO `tf_index_friend` VALUES (18, 'python中文网', '#');
  314. INSERT INTO `tf_index_friend` VALUES (19, 'php中文网', '#');
  315. INSERT INTO `tf_index_friend` VALUES (20, 'html中文网', '#');
  316. INSERT INTO `tf_index_friend` VALUES (21, 'python中文网', '#');
  317. INSERT INTO `tf_index_friend` VALUES (22, 'php中文网', '#');
  318. INSERT INTO `tf_index_friend` VALUES (23, 'html中文网', '#');
  319. INSERT INTO `tf_index_friend` VALUES (24, 'python中文网', '#');
  320. INSERT INTO `tf_index_friend` VALUES (25, 'php中文网', '#');
  321. INSERT INTO `tf_index_friend` VALUES (26, 'html中文网', '#');
  323. -- ----------------------------
  324. -- Table structure for tf_index_header
  325. -- ----------------------------
  326. DROP TABLE IF EXISTS `tf_index_header`;
  327. CREATE TABLE `tf_index_header`  (
  328.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  329.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  330.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  331.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  332.   `f_grouptype` int(11) NULL DEFAULT NULL,
  333.   PRIMARY KEY (`f_id`) USING BTREE
  334. ) ENGINE = MyISAM AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  336. -- ----------------------------
  337. -- Records of tf_index_header
  338. -- ----------------------------
  339. INSERT INTO `tf_index_header` VALUES (1, 'img', 'logo', 'resources/images/logo.png', NULL);
  340. INSERT INTO `tf_index_header` VALUES (2, 'title', '资料学习', NULL, NULL);
  341. INSERT INTO `tf_index_header` VALUES (3, 'links', '器材', '#', 2);
  342. INSERT INTO `tf_index_header` VALUES (4, 'links', '大师', '#', 2);
  343. INSERT INTO `tf_index_header` VALUES (5, 'links', '学院', '#', 2);
  344. INSERT INTO `tf_index_header` VALUES (6, 'links', '实战', '#', 2);
  345. INSERT INTO `tf_index_header` VALUES (7, 'links', '大赛', '#', 2);
  346. INSERT INTO `tf_index_header` VALUES (8, 'links', '裤子', '#', 2);
  347. INSERT INTO `tf_index_header` VALUES (9, 'links', '影视', '#', 2);
  348. INSERT INTO `tf_index_header` VALUES (10, 'links', '其它', '#', 2);
  349. INSERT INTO `tf_index_header` VALUES (11, 'title', '爱好姐妹', NULL, NULL);
  350. INSERT INTO `tf_index_header` VALUES (12, 'links', '有品', '#', 11);
  351. INSERT INTO `tf_index_header` VALUES (13, 'links', '图片', '#', 11);
  352. INSERT INTO `tf_index_header` VALUES (14, 'links', '喝水', '#', 11);
  353. INSERT INTO `tf_index_header` VALUES (15, 'links', '飞机', '#', 11);
  354. INSERT INTO `tf_index_header` VALUES (16, 'links', '坦克', '#', 11);
  355. INSERT INTO `tf_index_header` VALUES (17, 'links', '气球', '#', 11);
  356. INSERT INTO `tf_index_header` VALUES (18, 'links', '毛线', '#', 11);
  357. INSERT INTO `tf_index_header` VALUES (19, 'links', '其它', '#', 11);
  358. INSERT INTO `tf_index_header` VALUES (20, 'title', '软件技能', NULL, NULL);
  359. INSERT INTO `tf_index_header` VALUES (21, NULL, NULL, NULL, 20);
  360. INSERT INTO `tf_index_header` VALUES (22, 'links', '学习', '#', 20);
  361. INSERT INTO `tf_index_header` VALUES (23, 'links', '爱国', '#', 20);
  362. INSERT INTO `tf_index_header` VALUES (24, 'links', '敬业', '#', 20);
  363. INSERT INTO `tf_index_header` VALUES (25, 'links', '友善', '#', 20);
  364. INSERT INTO `tf_index_header` VALUES (26, 'links', '富强', '#', 20);
  365. INSERT INTO `tf_index_header` VALUES (27, 'links', '互助', '#', 20);
  366. INSERT INTO `tf_index_header` VALUES (28, 'links', '仁义', '#', 20);
  367. INSERT INTO `tf_index_header` VALUES (29, 'title', '编程美女', NULL, NULL);
  368. INSERT INTO `tf_index_header` VALUES (30, 'links', '吃饭', '#', 29);
  369. INSERT INTO `tf_index_header` VALUES (31, 'links', '周易', '#', 29);
  370. INSERT INTO `tf_index_header` VALUES (32, 'links', '黄山', '#', 29);
  371. INSERT INTO `tf_index_header` VALUES (33, 'links', '合肥', '#', 29);
  372. INSERT INTO `tf_index_header` VALUES (34, 'links', '上海', '#', 29);
  373. INSERT INTO `tf_index_header` VALUES (35, 'links', '杭州', '#', 29);
  374. INSERT INTO `tf_index_header` VALUES (36, 'links', '北京', '#', 29);
  375. INSERT INTO `tf_index_header` VALUES (37, 'links', '其它', '#', 29);
  376. INSERT INTO `tf_index_header` VALUES (39, 'img', 'banner_left', 'resources/images/2.jpg', NULL);
  377. INSERT INTO `tf_index_header` VALUES (40, 'img', 'banner_right', 'resources/images/banner-right.jpg', NULL);
  378. INSERT INTO `tf_index_header` VALUES (41, 'links', '其它', '#', 20);
  380. -- ----------------------------
  381. -- Table structure for tf_index_news
  382. -- ----------------------------
  383. DROP TABLE IF EXISTS `tf_index_news`;
  384. CREATE TABLE `tf_index_news`  (
  385.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  386.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  387.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  388.   `f_listcontent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  389.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  390.   PRIMARY KEY (`f_id`) USING BTREE
  391. ) ENGINE = MyISAM AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  393. -- ----------------------------
  394. -- Records of tf_index_news
  395. -- ----------------------------
  396. INSERT INTO `tf_index_news` VALUES (1, '封推图-1', 'img', '', 'resources/images/news.jpg');
  397. INSERT INTO `tf_index_news` VALUES (2, '三星Note10发布搭载挖孔前摄', 'img', '', 'resources/images/n-2.jpg');
  398. INSERT INTO `tf_index_news` VALUES (3, '小米公布1亿像素手机信息', 'img', '', 'resources/images/n-3.jpg');
  399. INSERT INTO `tf_index_news` VALUES (4, '新闻封推', '标题', '大隐于市的摄影师,薇薇安·迈尔', NULL);
  400. INSERT INTO `tf_index_news` VALUES (5, NULL, '新闻', '佳能注册相机无线充电和眼控对焦专利', NULL);
  401. INSERT INTO `tf_index_news` VALUES (6, NULL, '新闻', 'Entaniya宣布推出Super 35 PL卡口鱼眼镜头', NULL);
  402. INSERT INTO `tf_index_news` VALUES (7, NULL, '新闻', '轻便灵巧可变形 JOBY入门迷你三脚架套装试用', NULL);
  403. INSERT INTO `tf_index_news` VALUES (8, NULL, '新闻', '乐摄宝Photo Active BP 300 AW背包评测', NULL);
  404. INSERT INTO `tf_index_news` VALUES (9, NULL, '新闻', '佳能注册相机无线充电和眼控对焦专利', NULL);
  405. INSERT INTO `tf_index_news` VALUES (10, NULL, '新闻', 'Entaniya宣布推出Super 35 PL卡口鱼眼镜头', NULL);
  406. INSERT INTO `tf_index_news` VALUES (11, NULL, '新闻', '轻便灵巧可变形 JOBY入门迷你三脚架套装试用', NULL);
  407. INSERT INTO `tf_index_news` VALUES (12, NULL, '新闻', '乐摄宝Photo Active BP 300 AW背包评测', NULL);
  408. INSERT INTO `tf_index_news` VALUES (13, NULL, '新闻', '乐摄宝Photo Active BP 300 AW背包评测', NULL);
  409. INSERT INTO `tf_index_news` VALUES (14, '促销封推', '标题', '元旦春节,双节联动,备年货啦!', NULL);
  410. INSERT INTO `tf_index_news` VALUES (15, NULL, '促销', '佳能 EOS RP 12899元起', NULL);
  411. INSERT INTO `tf_index_news` VALUES (16, NULL, '促销', '定焦,变焦, 新人小白如何选择?这三款值得买', NULL);
  412. INSERT INTO `tf_index_news` VALUES (17, NULL, '促销', '新一代入门神器？ 佳能EOS 850D将到来', NULL);
  413. INSERT INTO `tf_index_news` VALUES (18, NULL, '促销', '无低通次旗舰 D7500套机6899元', NULL);
  414. INSERT INTO `tf_index_news` VALUES (19, NULL, '促销', '佳能注册相机无线充电和眼控对焦专利', NULL);
  415. INSERT INTO `tf_index_news` VALUES (20, NULL, '促销', '复古全幅单反 尼康Df套机14500元', NULL);
  416. INSERT INTO `tf_index_news` VALUES (21, NULL, '促销', '索尼α7R IV超广套装售42698元', NULL);
  417. INSERT INTO `tf_index_news` VALUES (22, NULL, '促销', 'RF大三元长焦 RF70-200mm售17699', NULL);
  418. INSERT INTO `tf_index_news` VALUES (23, NULL, '促销', '有所保留 佳能EOS-1D X III再曝新功能', NULL);
  420. -- ----------------------------
  421. -- Table structure for tf_pages
  422. -- ----------------------------
  423. DROP TABLE IF EXISTS `tf_pages`;
  424. CREATE TABLE `tf_pages`  (
  425.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  426.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  427.   `f_type` int(11) NULL DEFAULT NULL,
  428.   `f_level` int(11) NULL DEFAULT NULL,
  429.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  430.   `f_divname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  431.   PRIMARY KEY (`f_id`) USING BTREE
  432. ) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  434. -- ----------------------------
  435. -- Records of tf_pages
  436. -- ----------------------------
  437. INSERT INTO `tf_pages` VALUES (1, '全站首页', 1, 1, 'index.php', 'page-index');
  438. INSERT INTO `tf_pages` VALUES (2, '图片站', 2, 1, 'image_list.php', NULL);
  439. INSERT INTO `tf_pages` VALUES (3, '图片详情', 2, 1, 'image_detail.php', NULL);
  440. INSERT INTO `tf_pages` VALUES (4, '二手商品', 4, 1, 'shop_index.php', NULL);
  441. INSERT INTO `tf_pages` VALUES (5, '商品列表', 4, 1, 'shop_list.php', NULL);
  442. INSERT INTO `tf_pages` VALUES (6, '商品详情', 4, 1, 'shop_detail.php', NULL);
  443. INSERT INTO `tf_pages` VALUES (7, '文章列表', 6, 1, 'article_list.php', NULL);
  444. INSERT INTO `tf_pages` VALUES (8, '文章详情', 6, 1, 'article_detail.php', NULL);
  445. INSERT INTO `tf_pages` VALUES (9, '登录', 8, 1, '#', NULL);
  446. INSERT INTO `tf_pages` VALUES (10, '免费注册', 8, 1, '#', NULL);
  448. -- ----------------------------
  449. -- Table structure for tf_reply
  450. -- ----------------------------
  451. DROP TABLE IF EXISTS `tf_reply`;
  452. CREATE TABLE `tf_reply`  (
  453.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  454.   `f_goodsid` int(11) NULL DEFAULT NULL,
  455.   `f_replyid` int(11) NULL DEFAULT NULL,
  456.   `f_replyname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  457.   `f_userimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  458.   `f_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  459.   `f_time` datetime(0) NULL DEFAULT NULL,
  460.   PRIMARY KEY (`f_id`) USING BTREE
  461. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  463. -- ----------------------------
  464. -- Records of tf_reply
  465. -- ----------------------------
  466. INSERT INTO `tf_reply` VALUES (1, 5, 103, '南城无贼丶潇子', 'resources/images/user1.jpg', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-03 15:56:41');
  467. INSERT INTO `tf_reply` VALUES (2, 5, 99, '通天圣人二君', 'resources/images/user2.jpg', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-03 15:56:37');
  468. INSERT INTO `tf_reply` VALUES (3, 5, 45, '无忧无虑', 'resources/images/user3.jpg', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-04 15:56:33');
  469. INSERT INTO `tf_reply` VALUES (4, 5, 76, '天道酌勤', 'resources/images/user.png', 'php中文网,是一个有温度,有思想的学习平台', '2020-01-31 15:56:27');
  470. INSERT INTO `tf_reply` VALUES (5, 5, 98, '无相真君·李某人', 'resources/images/user4.JPEG', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-04 15:56:23');
  471. INSERT INTO `tf_reply` VALUES (6, 5, 1054, '萧何萧瑟-伊人憔', 'resources/images/user.png', 'php中文网,是一个有温度,有思想的学习平台', '2020-02-04 15:56:16');
  473. -- ----------------------------
  474. -- Table structure for tf_second_hand
  475. -- ----------------------------
  476. DROP TABLE IF EXISTS `tf_second_hand`;
  477. CREATE TABLE `tf_second_hand`  (
  478.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  479.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  480.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  481.   `f_typedes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  482.   `f_imgname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  483.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  484.   `f_price` decimal(10, 2) NULL DEFAULT NULL,
  485.   PRIMARY KEY (`f_id`) USING BTREE
  486. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  488. -- ----------------------------
  489. -- Records of tf_second_hand
  490. -- ----------------------------
  491. INSERT INTO `tf_second_hand` VALUES (1, 'title', '抢好货', ' 0低价,便捷,安全,快速', NULL, NULL, NULL);
  492. INSERT INTO `tf_second_hand` VALUES (2, 'nav', '热门分类', NULL, NULL, NULL, NULL);
  493. INSERT INTO `tf_second_hand` VALUES (3, 'links', '美女写真', NULL, NULL, NULL, NULL);
  494. INSERT INTO `tf_second_hand` VALUES (4, 'links', '日本美女', NULL, NULL, NULL, NULL);
  495. INSERT INTO `tf_second_hand` VALUES (5, 'links', '美国美女', NULL, NULL, NULL, NULL);
  496. INSERT INTO `tf_second_hand` VALUES (6, 'links', '国内美女', NULL, NULL, NULL, NULL);
  497. INSERT INTO `tf_second_hand` VALUES (7, 'links', 'AV美女', NULL, NULL, NULL, NULL);
  498. INSERT INTO `tf_second_hand` VALUES (8, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图1', 'resources/images/goods/shop1.jpg', 345.00);
  499. INSERT INTO `tf_second_hand` VALUES (9, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图2', 'resources/images/goods/shop2.jpg', 128.00);
  500. INSERT INTO `tf_second_hand` VALUES (10, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图3', 'resources/images/goods/shop3.jpg', 789.00);
  501. INSERT INTO `tf_second_hand` VALUES (11, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图4', 'resources/images/goods/shop4.jpg', 542.00);
  502. INSERT INTO `tf_second_hand` VALUES (12, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图5', 'resources/images/goods/shop5.jpg', 368.00);
  503. INSERT INTO `tf_second_hand` VALUES (13, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图6', 'resources/images/goods/shop6.jpg', 188.00);
  504. INSERT INTO `tf_second_hand` VALUES (14, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图7', 'resources/images/goods/shop7.jpg', 299.00);
  505. INSERT INTO `tf_second_hand` VALUES (15, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图8', 'resources/images/goods/shop8.jpg', 99.00);
  506. INSERT INTO `tf_second_hand` VALUES (16, 'entry_top', '二手闲置', NULL, NULL, 'resources/images/entry/1.png', NULL);
  507. INSERT INTO `tf_second_hand` VALUES (17, 'entry_top', '器材维修', NULL, NULL, 'resources/images/entry/2.png', NULL);
  508. INSERT INTO `tf_second_hand` VALUES (18, 'entry_top', '蜂鸟鉴定', NULL, NULL, 'resources/images/entry/3.png', NULL);
  509. INSERT INTO `tf_second_hand` VALUES (19, 'entry_top', '器材租赁', NULL, NULL, 'resources/images/entry/4.png', NULL);
  510. INSERT INTO `tf_second_hand` VALUES (20, 'entry_bottom', '回收流程', NULL, NULL, 'resources/images/entry/ent1.png', NULL);
  511. INSERT INTO `tf_second_hand` VALUES (21, 'entry_bottom', '蜂鸟回收', NULL, NULL, 'resources/images/entry/ent2.jpg', NULL);
  512. INSERT INTO `tf_second_hand` VALUES (22, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图9', 'resources/images/goods/shop3.jpg', 375.00);
  513. INSERT INTO `tf_second_hand` VALUES (23, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图10', 'resources/images/goods/shop6.jpg', 587.00);
  514. INSERT INTO `tf_second_hand` VALUES (24, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图11', 'resources/images/goods/shop8.jpg', 421.00);
  515. INSERT INTO `tf_second_hand` VALUES (25, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图12', 'resources/images/goods/shop7.jpg', 184.00);
  516. INSERT INTO `tf_second_hand` VALUES (26, 'goods', '美女', NULL, '美女性感写真海报墙艺术装饰画贴画图13', 'resources/images/goods/shop6.jpg', 9.90);
  518. -- ----------------------------
  519. -- Table structure for tf_shop_banner
  520. -- ----------------------------
  521. DROP TABLE IF EXISTS `tf_shop_banner`;
  522. CREATE TABLE `tf_shop_banner`  (
  523.   `f_id` int(11) NOT NULL AUTO_INCREMENT,
  524.   `f_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  525.   `f_typename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  526.   `f_typedesc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  527.   `f_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  528.   `f_imgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  529.   `f_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  530.   PRIMARY KEY (`f_id`) USING BTREE
  531. ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  533. -- ----------------------------
  534. -- Records of tf_shop_banner
  535. -- ----------------------------
  536. INSERT INTO `tf_shop_banner` VALUES (1, 'nav', '导航', '顶部导航', '首页', NULL, NULL);
  537. INSERT INTO `tf_shop_banner` VALUES (2, 'nav', '', '', '数码3C', NULL, NULL);
  538. INSERT INTO `tf_shop_banner` VALUES (3, 'nav', '', '', '免费素材', NULL, NULL);
  539. INSERT INTO `tf_shop_banner` VALUES (11, 'navlist', NULL, '数码产品', '微单相机', NULL, NULL);
  540. INSERT INTO `tf_shop_banner` VALUES (4, 'nav', NULL, NULL, '摄影器材', NULL, NULL);
  541. INSERT INTO `tf_shop_banner` VALUES (5, 'nav', NULL, NULL, '阳光交易', NULL, NULL);
  542. INSERT INTO `tf_shop_banner` VALUES (6, 'nav', NULL, NULL, '跨境电商', NULL, NULL);
  543. INSERT INTO `tf_shop_banner` VALUES (7, 'nav', NULL, NULL, '商业素材', NULL, NULL);
  544. INSERT INTO `tf_shop_banner` VALUES (8, 'nav', NULL, NULL, '软件授权', NULL, NULL);
  545. INSERT INTO `tf_shop_banner` VALUES (9, 'nav', NULL, NULL, '商业推广', NULL, NULL);
  546. INSERT INTO `tf_shop_banner` VALUES (10, 'navlist', '全部商品分类', '数码产品', '单反相机', NULL, NULL);
  547. INSERT INTO `tf_shop_banner` VALUES (12, 'navlist', NULL, '数码产品', '笔记本电脑', NULL, NULL);
  548. INSERT INTO `tf_shop_banner` VALUES (13, 'navlist', NULL, '数码产品', '摄影机', NULL, NULL);
  549. INSERT INTO `tf_shop_banner` VALUES (14, 'navlist', NULL, '数码产品', '稳定器', NULL, NULL);
  550. INSERT INTO `tf_shop_banner` VALUES (15, 'navlist', NULL, '数码产品', '储存卡', NULL, NULL);
  551. INSERT INTO `tf_shop_banner` VALUES (16, 'navlist', NULL, '常用软件', '修图软件', NULL, NULL);
  552. INSERT INTO `tf_shop_banner` VALUES (17, 'navlist', NULL, '常用软件', '后期处理', NULL, NULL);
  553. INSERT INTO `tf_shop_banner` VALUES (18, 'navlist', NULL, '常用软件', '调色软件', NULL, NULL);
  554. INSERT INTO `tf_shop_banner` VALUES (19, 'navlist', NULL, '常用软件', 'Final Cut', NULL, NULL);
  555. INSERT INTO `tf_shop_banner` VALUES (20, 'navlist', NULL, '常用软件', 'Adobe', NULL, NULL);
  556. INSERT INTO `tf_shop_banner` VALUES (21, 'navlist', NULL, '常用软件', '其它', NULL, NULL);
  557. INSERT INTO `tf_shop_banner` VALUES (22, 'navlist', NULL, '商业推广', '公众号', NULL, NULL);
  558. INSERT INTO `tf_shop_banner` VALUES (23, 'navlist', NULL, '商业推广', '小程序', NULL, NULL);
  559. INSERT INTO `tf_shop_banner` VALUES (24, 'navlist', NULL, '商业推广', '今日头条', NULL, NULL);
  560. INSERT INTO `tf_shop_banner` VALUES (25, 'navlist', NULL, '商业推广', 'VLOG', NULL, NULL);
  561. INSERT INTO `tf_shop_banner` VALUES (26, 'navlist', NULL, '商业推广', '抖音', NULL, NULL);
  562. INSERT INTO `tf_shop_banner` VALUES (27, 'navlist', NULL, '商业推广', '其它平台', NULL, NULL);
  563. INSERT INTO `tf_shop_banner` VALUES (28, 'banner', NULL, NULL, '蜂鸟网', 'resources/images/2.jpg', '');
  565. SET FOREIGN_KEY_CHECKS = 1;

源码下载

链接：https://share.weiyun.com/5myP3zI 密码：s86ad3

上一条：linux 用yum 在CentOS 7 中搭建LAMP环境下一条：PDO和PDOStatement的预习笔记
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多