登录  /  注册
博主信息
博文 22
粉丝 1
评论 1
访问量 21356
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
PDO与MVC的初次实战(春节大作业)--PHP十期培训线上班
Miss灬懒虫
原创
891人浏览过

项目总结

概述

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

缺点

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

感受

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

页面效果








项目目录

数据表结构

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

源码下载

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

批改老师:天蓬老师天蓬老师

批改状态:合格

老师批语:作业完成的不错, 但大量的sql语句都是软件生成的, 如果让你自己写, 能否写对呢
本博文版权归博主所有,转载请注明地址!如有侵权、违法,请联系admin@php.cn举报处理!
全部评论 文明上网理性发言,请遵守新闻评论服务协议
0条评论
作者最新博文
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2024 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号

  • 登录PHP中文网,和优秀的人一起学习!
    全站2000+教程免费学