创建TP 6项目的笔记

guigui_hello

已于 2024-02-17 16:51:03 修改

阅读量1.1k

点赞数 21

文章标签：笔记 php

于 2024-02-16 21:44:15 首次发布

本文链接：https://blog.csdn.net/qq_33667332/article/details/136132807

版权

看云 thinkphp6.0 开发手册：https://www.kancloud.cn/manual/thinkphp6_0/

thinkphp 8.0 开发手册：https://doc.thinkphp.cn/v8_0/mubanyinqing.html

小皮面板下载： https://www.xp.cn/download.html

thinkphp : http://www.ouyangke.com/back/thinkphp/1安装.html

thinkphp的数据库： http://www.ouyangke.com/back/thinkphp/5数据库.html

小皮面板创建php6的网站的时候把 “根目录” 指向pubic文件夹。

config/app.php

 // 显示错误信息
    'show_error_msg'   => false,  这个在开发中可以设置成true ， 会明确的显示出错误信息

config/database.php 这个用来配置数据库的参数

CREATE TABLE `shop_admin` (
    `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `account` varchar(50) NOT NULL COMMENT '账户',
    `password` char(32) NOT NULL COMMENT '密码',
    `name` varchar(50) NOT NULL COMMENT '姓名',
    `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 2关闭',
    `add_time` int(10) unsigned NOT NULL COMMENT '添加时间',
    PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='后台管理员';

INSERT INTO `shop_admin` VALUES (1, 'ouyangke', 'e10adc3949ba59abbe56e057f20f883e', '欧阳克', 1, 1576080000);


商品分类表

DROP TABLE IF EXISTS `shop_cat`;
CREATE TABLE `shop_cat` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `name` varchar(50) NOT NULL COMMENT '分类名',
    `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 2关闭',
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='分类表';

INSERT INTO `shop_cat` VALUES (1, '女装', 1);
INSERT INTO `shop_cat` VALUES (2, '男装', 1);
INSERT INTO `shop_cat` VALUES (3, '孕产', 1);
INSERT INTO `shop_cat` VALUES (4, '童装', 1);
INSERT INTO `shop_cat` VALUES (5, '电视', 1);
INSERT INTO `shop_cat` VALUES (6, '手机', 1);
INSERT INTO `shop_cat` VALUES (7, '电脑', 1);

商品表
CREATE TABLE `shop_goods` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' 商品ID',
    `cat` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '分类ID',
    `title` varchar(200) NOT NULL COMMENT '商品标题',
    `price` double(10,2) unsigned NOT NULL COMMENT '价格',
    `discount` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '折扣',
    `stock` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '库存',
    `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 2关闭 3删除',
    `add_time` int(10) unsigned NOT NULL COMMENT '添加时间',
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COMMENT='商品表';

INSERT INTO `shop_goods` VALUES (1, 1, '云朵般轻盈的仙女裙 高级钉珠收腰长裙 气质无袖连衣裙', 279.99, 0, 1100, 1, 1576080000);
INSERT INTO `shop_goods` VALUES (2, 1, '高冷御姐风灯芯绒a字连衣裙女秋冬2019年新款收腰显瘦复古裙子', 255.90, 0, 100, 1, 1576080000);


菜单表
CREATE TABLE `shop_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `title` varchar(50) NOT NULL COMMENT '菜单名',
  `fid` int(10) NOT NULL COMMENT '父ID',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 2关闭',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='左侧菜单表';

INSERT INTO `shop_menu` VALUES (1, '商品管理', 0, 1);
INSERT INTO `shop_menu` VALUES (2, '商品列表', 1, 1);
INSERT INTO `shop_menu` VALUES (3, '商品分类', 1, 1);
INSERT INTO `shop_menu` VALUES (4, '用户管理', 0, 1);
INSERT INTO `shop_menu` VALUES (5, '用户列表', 4, 1);
INSERT INTO `shop_menu` VALUES (6, '购物车', 4, 1);
INSERT INTO `shop_menu` VALUES (7, '用户地址', 4, 1);
INSERT INTO `shop_menu` VALUES (8, '订单管理', 4, 1);
INSERT INTO `shop_menu` VALUES (9, '后台管理', 0, 1);
INSERT INTO `shop_menu` VALUES (10, '管理员列表', 9, 1);
INSERT INTO `shop_menu` VALUES (11, '个人中心', 9, 1);
INSERT INTO `shop_menu` VALUES (12, '左侧菜单', 9, 1);

商城项目的sql

/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : ouyangke

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 16/05/2022 22:05:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oyk_adver
-- ----------------------------
DROP TABLE IF EXISTS `oyk_adver`;
CREATE TABLE `oyk_adver`  (
  `aid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '广告ID',
  `pic` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跳转链接',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序 值越大越靠前',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0关闭',
  PRIMARY KEY (`aid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '广告表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_adver
-- ----------------------------
INSERT INTO `oyk_adver` VALUES (1, 'https://t7.baidu.com/it/u=1595072465,3644073269&fm=193&f=GIF', 'Web大前端开发直播班', 'https://www.php.cn/q.html?t=1', 1, 1);
INSERT INTO `oyk_adver` VALUES (2, 'https://t7.baidu.com/it/u=1956604245,3662848045&fm=193&f=GIF', '2022讲师招募、课程合作计划（php中文网）', 'https://www.php.cn/blog/detail/33314.html', 2, 1);
INSERT INTO `oyk_adver` VALUES (3, 'https://t7.baidu.com/it/u=727460147,2222092211&fm=193&f=GIF', 'php培训', 'https://www.php.cn/k.html', 3, 1);

-- ----------------------------
-- Table structure for oyk_cart
-- ----------------------------
DROP TABLE IF EXISTS `oyk_cart`;
CREATE TABLE `oyk_cart`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '购物车ID',
  `sid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID',
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `num` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '数量',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0删除',
  `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '购物车表' ROW_FORMAT = FIXED;

-- ----------------------------
-- Records of oyk_cart
-- ----------------------------
INSERT INTO `oyk_cart` VALUES (5, 1, 1, 2, 1, 1651335637);

-- ----------------------------
-- Table structure for oyk_shop_cat
-- ----------------------------
DROP TABLE IF EXISTS `oyk_shop_cat`;
CREATE TABLE `oyk_shop_cat`  (
  `cid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `pid` int(11) UNSIGNED NOT NULL COMMENT '分类父id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名',
  `pic` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序数字越大越靠前',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0关闭',
  PRIMARY KEY (`cid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程分类表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_shop_cat
-- ----------------------------
INSERT INTO `oyk_shop_cat` VALUES (1, 0, '手机数码', NULL, 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (2, 1, '小米', 'https://img30.360buyimg.com/focus/s140x140_jfs/t13411/188/926813276/3945/a4f47292/5a1692eeN105a64b4.png', 0, 0);
INSERT INTO `oyk_shop_cat` VALUES (3, 1, '华为', 'https://img14.360buyimg.com/focus/s140x140_jfs/t11929/135/2372293765/1396/e103ec31/5a1692e2Nbea6e136.jpg', 0, 0);
INSERT INTO `oyk_shop_cat` VALUES (4, 1, '荣耀', 'https://img10.360buyimg.com/focus/s140x140_jfs/t12178/348/911080073/4732/db0ad9c7/5a1692e2N6df7c609.jpg', 0, 0);
INSERT INTO `oyk_shop_cat` VALUES (5, 1, 'iPhone', 'https://img20.360buyimg.com/focus/s140x140_jfs/t13759/194/897734755/2493/1305d4c4/5a1692ebN8ae73077.jpg', 0, 2);
INSERT INTO `oyk_shop_cat` VALUES (6, 1, 'vivo', 'https://img11.360buyimg.com/focus/s140x140_jfs/t11014/359/2341377211/2777/1755c29c/5a169244Nff0179e0.png', 0, 2);
INSERT INTO `oyk_shop_cat` VALUES (7, 1, 'OPPO', 'https://img13.360buyimg.com/focus/s140x140_jfs/t13036/273/932026474/2570/a3517c7d/5a169254N4bbbd9fb.png', 0, 2);
INSERT INTO `oyk_shop_cat` VALUES (8, 1, '魅族', 'https://img20.360buyimg.com/focus/s140x140_jfs/t12820/326/909017718/7138/68cde747/5a169243N40eca33c.jpg', 0, 2);
INSERT INTO `oyk_shop_cat` VALUES (9, 1, '三星', 'https://img13.360buyimg.com/focus/s140x140_jfs/t11509/131/2348573811/3425/4f20fe6/5a16925aN8a6dfd03.png', 0, 2);
INSERT INTO `oyk_shop_cat` VALUES (10, 1, '一加', 'https://img13.360buyimg.com/focus/s140x140_jfs/t11209/71/2351231464/4158/fc0c415c/5a16923fNfc14307e.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (11, 1, '努比亚', 'https://img11.360buyimg.com/focus/s140x140_jfs/t1/108301/34/7712/3254/5e5f0de9E4ca2f4b5/c664966ee1d36d47.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (13, 0, '京东超市', NULL, 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (14, 13, '休闲零食', 'https://img30.360buyimg.com/focus/s140x140_jfs/t11431/77/1274462175/4200/a52ec5cc/59ffd6e2N287c043d.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (15, 13, '坚果炒货', 'https://img20.360buyimg.com/focus/s140x140_jfs/t11461/336/1331406760/15773/60c49ab7/59ffd6d0Ncb29412d.png', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (16, 13, '糖巧', 'https://img12.360buyimg.com/focus/s140x140_jfs/t11890/195/1248876103/12648/403ce46a/59ffd6b9Nc88344b5.png', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (17, 13, '饼干蛋糕', 'https://img14.360buyimg.com/focus/s140x140_jfs/t11500/115/1293305736/3233/7bb2056a/59ffd6ccNb9875d1d.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (18, 13, '肉干肉铺', 'https://img11.360buyimg.com/focus/s140x140_jfs/t11749/28/952474396/2583/64b85652/59fc31b6N4feb7d84.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (19, 13, '蜜饯果干', 'https://img11.360buyimg.com/focus/s140x140_jfs/t11275/128/1281544342/3341/64f437e/59ffd6fbN047718c7.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (20, 13, '无糖食品', 'https://img14.360buyimg.com/focus/s140x140_jfs/t7570/153/3996735769/2714/a58d5793/59ffd6ffN95ab2f9b.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (21, 0, '家用电器', NULL, 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (22, 21, '电压力锅', 'https://img13.360buyimg.com/focus/s140x140_jfs/t13069/193/944900508/2525/d7c9efc/5a17f21dN905aaf4c.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (23, 21, '电水壶/热水瓶', 'https://img30.360buyimg.com/focus/s140x140_jfs/t12559/262/969294499/3436/8c0ce9c9/5a17f1d2N8078d5e6.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (24, 21, '电饭煲', 'https://img11.360buyimg.com/focus/s140x140_jfs/t14185/134/950962305/3800/eb1bafb8/5a17f224Nea1d3f59.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (25, 21, '电磁炉', 'https://img13.360buyimg.com/focus/s140x140_jfs/t11209/197/2422417970/2811/d167e855/5a17f1edN56abbe6e.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (26, 21, '微波炉', 'https://img11.360buyimg.com/focus/s140x140_jfs/t13267/86/981023661/1871/6fae5f11/5a17f203N50016f64.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (27, 21, '电饼档', 'https://img11.360buyimg.com/focus/s140x140_jfs/t11503/25/2307123595/2987/a79ac767/5a17f1e3Nf7957b34.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (28, 21, '豆浆机', 'https://img11.360buyimg.com/focus/s140x140_jfs/t14065/132/988058896/1688/99cd0a3d/5a17f229Nc4c681fb.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (29, 21, '多用途锅', 'https://img11.360buyimg.com/focus/s140x140_jfs/t13192/9/990491166/2453/36169f1b/5a17f1ccN019c7fda.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (30, 21, '料理机', 'https://img13.360buyimg.com/focus/s140x140_jfs/t11284/298/2465125571/2619/ffe2cde5/5a17f237Nb9978251.jpg', 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (31, 21, '打印机', NULL, 0, 1);
INSERT INTO `oyk_shop_cat` VALUES (32, 21, 'php打印机', 'https://img13.360buyimg.com/focus/s140x140_jfs/t11284/298/2465125571/2619/ffe2cde5/5a17f237Nb9978251.jpg', 0, 1);

-- ----------------------------
-- Table structure for oyk_shop_lists
-- ----------------------------
DROP TABLE IF EXISTS `oyk_shop_lists`;
CREATE TABLE `oyk_shop_lists`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(10) UNSIGNED NOT NULL COMMENT '一级分类',
  `cid` int(10) UNSIGNED NOT NULL COMMENT '二级分类',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片',
  `price` int(10) NOT NULL COMMENT '价格',
  `num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量',
  `info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '介绍',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0关闭',
  `add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_shop_lists
-- ----------------------------
INSERT INTO `oyk_shop_lists` VALUES (1, 1, 2, '小米 Civi 1S 5G手机', 'https://m.360buyimg.com/mobilecms/s750x750_jfs/t1/142405/30/15860/47809/5fbe0736E3284d091/0b92f82917a9c400.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/126316/32/19783/26910/5fbe0736E2c417acf/629d800b12bd04d3.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/132462/34/17287/31764/5fbe0736Ec65a366b/1ef8bfba5bf299c0.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/123347/7/19725/23191/5fbe0736E35bcd471/8ce758754a88a223.jpg', 5800, 0, 'https://img30.360buyimg.com/sku/jfs/t1/203133/17/12039/87421/616eb703E1ccb169f/373fda34d9137fc0.jpg;https://img30.360buyimg.com/sku/jfs/t1/128665/2/19985/404196/5fbf73c5Eace0669e/7c4e40d06b44f68d.jpg;https://img30.360buyimg.com/sku/jfs/t1/140149/24/16020/403325/5fbf73c5Edb42e7cb/cd49e9ac3020c4bb.jpg;https://img30.360buyimg.com/sku/jfs/t1/150923/9/8053/405461/5fbf73c5E78e57ef0/ddb2925d1d8873fb.jpg;https://img30.360buyimg.com/sku/jfs/t1/148471/15/15973/404378/5fbf73c5Eebfe1fce/c767e7a4cff746c3.jpg;https://img30.360buyimg.com/sku/jfs/t1/144576/18/16011/383634/5fbf73c4E1fa63347/dd07f5f6b31e46b8.jpg;https://img30.360buyimg.com/sku/jfs/t1/150525/40/8089/407870/5fbf73c5Ef09b89d3/0de84c058a53f64c.jpg;https://img30.360buyimg.com/sku/jfs/t1/133289/18/17407/408910/5fbf73c5Ec140acd7/f1378b14861cfb43.jpg;https://img30.360buyimg.com/sku/jfs/t1/136263/6/17493/387095/5fbf73c5Ee2c5f5ef/611824c021ae9179.jpg;https://img30.360buyimg.com/sku/jfs/t1/133764/37/17245/324279/5fbf73c4E6dc89d74/7c9f6aa95cb1046c.jpg;https://img30.360buyimg.com/sku/jfs/t1/137000/40/17283/287228/5fbf73c4E23173583/e434ce73f70760a2.jpg;https://img30.360buyimg.com/sku/jfs/t1/152780/24/7392/365225/5fbf73c4Ef7912175/617048af79b17c6b.jpg;https://img30.360buyimg.com/sku/jfs/t1/140311/2/16710/118067/5fc74a30E0fc69bcf/1bb713a4abb6cc25.jpg;https://img30.360buyimg.com/sku/jfs/t1/140889/35/16754/188086/5fc74a30Edbbdfd69/73c000b2162d61f3.jpg', 2, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (2, 1, 2, 'Redmi 9A 5000mAh大电量 1300万AI相机 八核处理器 人脸解锁 4GB+64GB 砂石黑 智能手机 小米 红米', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/118064/27/12885/59959/5f17b7efE453f688d/5b33ac76b2aaea9b.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/139925/9/3487/36638/5f17b7eeE2d7fb367/5b7f5a8d57bf804a.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/121032/11/7794/38820/5f17b7eeE306dc16a/8344c7bbf49cd8a9.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/137344/40/5026/29866/5f17b7eeEc9da3d4a/cd293063f60c8609.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/125573/21/7718/17826/5f17b7efEa27913e0/3e8b37ff4e21492f.jpg', 599, 0, 'https://img30.360buyimg.com/sku/jfs/t1/132966/34/5993/132073/5f278614E18e848ac/afd0e7d45d5603ab.jpg;https://img30.360buyimg.com/sku/jfs/t1/136348/35/5560/180094/5f1f8725E9ec94a1e/744faaffbb1a588d.jpg;https://img30.360buyimg.com/sku/jfs/t1/112639/20/13440/166735/5f1f8725Ed8738f36/040e025008c81707.jpg;https://img30.360buyimg.com/sku/jfs/t1/125453/11/8209/134128/5f1f8725Ea94158a8/22e123d6b53390dd.jpg;https://img30.360buyimg.com/sku/jfs/t1/118841/17/13381/188779/5f1f8725E9fa95515/f94f01afef3c07ef.jpg;https://img30.360buyimg.com/sku/jfs/t1/120163/3/8161/65753/5f1f8725E3faf3410/e872a28fd061c2ff.jpg;https://img30.360buyimg.com/sku/jfs/t1/133384/36/5535/356614/5f1f8725E5a51873b/8283401da4c1850c.jpg;https://img30.360buyimg.com/sku/jfs/t1/121638/32/8080/215375/5f1f8725Ea1fc5455/6a8ff69d0bd03673.jpg;https://img30.360buyimg.com/sku/jfs/t1/139552/36/3928/133677/5f1f8725Ebe309f51/9e73b52e04f294f9.jpg;https://img30.360buyimg.com/sku/jfs/t1/119555/2/12092/354382/5f1f8725Eebd3996c/014101e7acaeb7d1.jpg;https://img30.360buyimg.com/sku/jfs/t1/130322/14/5561/141743/5f1f8725E4459539b/42c0bc3acf813631.jpg;https://img30.360buyimg.com/sku/jfs/t1/120794/1/8144/189782/5f1f8725Efb2f408d/f392358d31860cd3.jpg;https://img30.360buyimg.com/sku/jfs/t1/117210/27/13477/139717/5f1f8725Ef360ffec/6ad348518b0a4092.jpg;https://img30.360buyimg.com/sku/jfs/t1/120348/17/8732/171045/5f27823cE9454f5f7/5ae8ccf94da35353.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (3, 1, 2, 'Redmi Note 11 5G 天玑810 33W Pro快充 5000mAh大电池 6GB +128GB 神秘黑境 智能手机 小米 红米', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/219387/1/2219/59402/617a5e1eE2e382a01/458b5005484c3e00.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/203267/34/13175/23540/617a5e1dE3465a95a/44a4b6794985ef85.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/156119/29/23584/254600/6188c4bbE50e5e130/f467731f0db5ed99.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/198592/31/16388/280108/6188c4bbEede6c822/9713cf74eeabc241.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/216906/26/3611/395518/6188c4bbE1d5465a6/0cbe3ab884df3337.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/142518/4/20975/45345/617a5e1dE4d06b674/f761b6bd347d8895.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/209738/35/7030/20931/617a5e1dE9ac5f36b/409c4ffceb824201.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/205724/23/13031/15471/617a5e1eE4c816b10/7f8021a170b35094.jpg', 1299, 0, 'https://img30.360buyimg.com/sku/jfs/t1/222656/16/374/159984/617a4c70E081df94a/0adf4de4b71c2281.jpg;https://img30.360buyimg.com/sku/jfs/t1/214444/38/2204/157390/617a4c70E4c728339/8bb79a83516dde64.jpg;https://img30.360buyimg.com/sku/jfs/t1/211233/37/6960/139106/617a4c70Ed7ee1eb9/c3080a7cc48b3cf9.jpg;https://img30.360buyimg.com/sku/jfs/t1/204026/3/13105/97859/617a4c70E85e12a2e/e07e8b9c76c7dee6.jpg;https://img30.360buyimg.com/sku/jfs/t1/137561/9/24810/128154/617a4c70E69ef45af/261cba0b8ac3d544.jpg;https://img30.360buyimg.com/sku/jfs/t1/205430/23/13044/98439/617a4c70Eb709b9cc/d4ff4079c883473b.jpg;https://img30.360buyimg.com/sku/jfs/t1/198061/32/15081/67013/617a4c70E7acc233a/3c921d15db00f32a.jpg;https://img30.360buyimg.com/sku/jfs/t1/196996/14/15176/83602/617a4c70E834dafb5/bec61df1154abca7.jpg;https://img30.360buyimg.com/sku/jfs/t1/169099/39/21972/150925/617a4c70E5756d403/15977233776592b8.jpg;https://img30.360buyimg.com/sku/jfs/t1/221816/5/357/141912/617a4c70Ecd5c9f76/c150df371f79ab20.jpg;https://img30.360buyimg.com/sku/jfs/t1/171229/38/21162/162727/617a4c70E5c96a0fd/2a6b8faa3a34dbda.jpg;https://img30.360buyimg.com/sku/jfs/t1/201439/6/13247/168034/617a4c70Ee486c597/c15056a65bc7b28d.jpg;https://img30.360buyimg.com/sku/jfs/t1/201840/12/13177/108512/617a4c70E7c8b4f99/c1cb05ea53a9d6ba.jpg;https://img30.360buyimg.com/sku/jfs/t1/218562/12/2230/84040/617a4c70Ea66c5196/8b80e15fbfb63869.jpg;https://img30.360buyimg.com/sku/jfs/t1/155673/9/22301/75870/617a4c70Ef833d629/c86a8e66ca9bf811.jpg;https://img30.360buyimg.com/sku/jfs/t1/214860/4/2189/113331/617a4c70Ea73e11f6/fe073e3e926a59e5.jpg;https://img30.360buyimg.com/sku/jfs/t1/202121/35/13116/48757/617a4c70E80ea8816/ab41e1de092e37a8.jpg;https://img30.360buyimg.com/sku/jfs/t1/136818/6/21405/99061/617a4c70Ed4bdc68d/3e9eade6b2e5dcf3.jpg;', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (4, 1, 2, 'Redmi K50 天玑8100 2K柔性直屏 OIS光学防抖 67W快充 5500mAh大电量 墨羽 8GB+128GB 5G智能手机 小米红米', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/115577/10/21995/286954/62331946Eb57bc4c6/4bb4473b4dff3cba.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/90501/37/24502/144368/62331946E616ae725/2f04b4e22bd0570f.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/198325/32/20640/145120/62331946E31f531f3/dfc1c5969e4ca4b5.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/128411/26/25796/115061/62331946Ef61220ba/108f0be20c0043b5.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/129256/13/25679/38556/62331946E368865eb/bbd4317c56b3b837.jpg', 2399, 0, 'https://img30.360buyimg.com/sku/jfs/t1/219151/20/15066/215160/62331980E84bad091/6e2c0a1fa012f009.jpg;https://img30.360buyimg.com/sku/jfs/t1/86181/39/22556/233158/62331980Eb2b73503/ccb0de162521a60a.jpg;https://img30.360buyimg.com/sku/jfs/t1/116489/7/22678/197566/62331980E2e397502/f12f7a2b34cce02e.jpg;https://img30.360buyimg.com/sku/jfs/t1/126774/16/22581/242468/62331980E32ca5223/55a65a8a4244423e.jpg;https://img30.360buyimg.com/sku/jfs/t1/117436/2/21571/210196/62331980E63152806/86da06857bd941a0.jpg;https://img30.360buyimg.com/sku/jfs/t1/213173/5/14991/105272/62331980Eb1e34009/21e514957140b8ed.jpg;https://img30.360buyimg.com/sku/jfs/t1/102195/8/25800/125036/62331980Ee25d766b/d5217b686cf24063.jpg;https://img30.360buyimg.com/sku/jfs/t1/191928/25/21570/81977/62331980Ee58d3486/bc380ff04f62b18f.jpg;https://img30.360buyimg.com/sku/jfs/t1/115555/31/21890/283461/62331980Eab5294c9/3ed64550c231fd49.jpg;https://img30.360buyimg.com/sku/jfs/t1/110338/36/24866/40538/62331980E78555416/5cefd8fc19cc0b57.jpg;https://img30.360buyimg.com/sku/jfs/t1/145404/4/25201/108158/62331980Eeb0ff926/8e13dfb746e0308e.jpg;https://img30.360buyimg.com/sku/jfs/t1/109832/5/26077/179494/62331980E1b5aefaf/b7ebc96d9adcdd3c.jpg;https://img30.360buyimg.com/sku/jfs/t1/102534/5/26071/131879/62331980E921cb07c/c9a9f9d0cf70c7c6.jpg;https://img30.360buyimg.com/sku/jfs/t1/109060/28/27344/187444/6250f057E88892a72/bbcc94ad68837671.jpg;https://img30.360buyimg.com/sku/jfs/t1/117832/38/22039/106595/62331980E80a9b463/ac93ceaf1dd9fd9e.jpg;https://img30.360buyimg.com/sku/jfs/t1/89434/32/24919/85871/62331980Eb593d2f0/186c3df457d26746.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (5, 1, 2, '小米11 Ultra 至尊 5G 骁龙888 2K AMOLED四曲面柔性屏 陶瓷工艺 8GB+256GB 黑色 游戏手机', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/157841/35/16049/98076/606180eeEc1c07c41/9db39f15c063ad8d.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/156665/28/18396/79399/606180eeEbff92fee/bd4acf2256a2668a.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/167509/9/15157/38032/606180edE1b3e2e6b/0af0de9d76b95566.jpg;', 5499, 10, 'https://img30.360buyimg.com/sku/jfs/t1/170588/15/21156/169625/6086b587E2adab1ca/725887efe020727c.jpg;https://img30.360buyimg.com/sku/jfs/t1/183328/38/1242/314460/6088cf0aE9a455f4e/177b09c4b3100b81.jpg;https://img30.360buyimg.com/sku/jfs/t1/171677/22/1018/58313/6061983fE15af0541/acc80d88e2fa329d.jpg;https://img30.360buyimg.com/sku/jfs/t1/167700/5/14986/69146/6061983fE0a8455b6/09d2fc7be5919381.jpg;https://img30.360buyimg.com/sku/jfs/t1/162299/5/15535/66875/6061983fE1e623118/6c7b949cdd79179a.jpg;https://img30.360buyimg.com/sku/jfs/t1/162523/5/15353/66468/6061983fE1e891e08/badd6e3f3ebdb0cc.jpg;https://img30.360buyimg.com/sku/jfs/t1/176071/40/966/65512/6061983fE85659a8b/7fc0cae68c682fe8.jpg;https://img30.360buyimg.com/sku/jfs/t1/159449/34/15967/74898/6061983fEd9df80be/a9e02b08d6468f80.jpg;https://img30.360buyimg.com/sku/jfs/t1/165397/27/15181/87312/6061983fE3d75d6d5/0d7420f08507e27d.jpg;https://img30.360buyimg.com/sku/jfs/t1/173121/24/1024/64286/6061983fE4430fcc8/a96b822bde7e9774.jpg;https://img30.360buyimg.com/sku/jfs/t1/185841/4/851/144562/6084ed12E267c6220/c63f2e0484b8c575.jpg;https://img30.360buyimg.com/sku/jfs/t1/168580/1/15051/148152/6061983fEbbbf47bf/1f23b1ac93cb1a7f.jpg;https://img30.360buyimg.com/sku/jfs/t1/173694/35/951/243087/60619840E87bfc60c/98296de4d8b4e671.jpg;https://img30.360buyimg.com/sku/jfs/t1/162489/16/15500/50005/6061983fE367e0099/eb0595c3ce82ae80.jpg;https://img30.360buyimg.com/sku/jfs/t1/156883/17/18719/112091/6061983fE62435200/3181f66b92d8ab73.jpg;https://img30.360buyimg.com/sku/jfs/t1/173322/33/928/179048/60619840E17b6746e/545838592fd8cb89.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (6, 1, 2, 'Redmi Note 11 Pro 5G 三星AMOLED高刷屏 1亿像素 67W快充 VC液冷散热 6GB+128GB 迷雾森林 手机 小米 红米', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/143843/25/21094/107919/617a971eE340d3150/b93330bcae736ceb.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/212051/20/2153/95668/617a971eE43fcc360/49ce2eecb7de1ba9.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/212452/30/2213/59927/617a971eE9c01aa6a/fbd5602fb9285b77.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/221923/6/402/51008/617a971eE3c33c448/7c5e1c461f70474b.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/216979/38/2182/31997/617a971eEb347f8c4/082f3ebb20dd5d35.jpg', 1599, 0, 'https://img30.360buyimg.com/sku/jfs/t1/211276/40/7055/259539/617a9582Efa19722d/405fdf88a9045fe1.jpg;https://img30.360buyimg.com/sku/jfs/t1/156179/16/22351/114026/617a9581E8fd02af5/d0afef2db11859b4.jpg;https://img30.360buyimg.com/sku/jfs/t1/201163/21/13111/212985/617a9582Ea35bea54/c83ebc8b785b852e.jpg;https://img30.360buyimg.com/sku/jfs/t1/208504/26/7250/71602/617a957fE8d6fe1d9/99de8a9a67bed048.jpg;https://img30.360buyimg.com/sku/jfs/t1/206391/38/13176/112886/617a9581E5ff42b04/da6b1d8a2dee6db7.jpg;https://img30.360buyimg.com/sku/jfs/t1/199296/28/14837/91756/617a957fE3e739c38/ebb41193561b5f1e.jpg;https://img30.360buyimg.com/sku/jfs/t1/222888/35/373/161781/617a9582E24bd5b62/c24b446a8d3470ba.jpg;https://img30.360buyimg.com/sku/jfs/t1/222202/40/386/169696/617a9582E0120e8c9/d04abfa3d863fe98.jpg;https://img30.360buyimg.com/sku/jfs/t1/208212/19/7176/200075/617a9582Ecf012ccf/86b114f8281c9e51.jpg;https://img30.360buyimg.com/sku/jfs/t1/213633/15/2211/136023/617a9582Ea906a72b/7c8e39e3d18b8f2f.jpg;https://img30.360buyimg.com/sku/jfs/t1/206754/26/7229/140295/617a9582E638e3e7d/6bb70c58bd7d3de1.jpg;https://img30.360buyimg.com/sku/jfs/t1/215007/37/2291/127495/617a9581E7163b757/4879b20b3f216e0d.jpg;https://img30.360buyimg.com/sku/jfs/t1/206998/17/7209/61027/617a957fE07e32f81/d3545b278441cefe.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (7, 1, 2, 'Redmi K50 Pro 天玑9000 AMOLED 2K柔性直屏 OIS光学防抖 120W快充 墨羽 8GB+128GB 5G智能手机 小米红米', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/92842/11/24119/290267/62331daeEa04e16bf/74ddc795ac8ceaeb.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/223338/14/13323/144368/62331daeEa80e360e/a2e11c29a67b4717.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/164341/26/27086/145022/62331daeEddefdcc4/c211b9930eebfd08.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/121068/37/25372/115116/62331daeE2c35570d/a4c425f9380135c0.jpg', 2999, 0, 'https://img30.360buyimg.com/sku/jfs/t1/183453/26/21741/47719/62343179Ecc0725bf/6a916c7aca2f4d17.jpg;https://img30.360buyimg.com/sku/jfs/t1/182798/5/21713/145726/6234317aE0e388150/0ec60fdb868cb5a8.jpg;https://img30.360buyimg.com/sku/jfs/t1/105112/34/25618/199559/6234317aE93fb6e14/aa9186c53c253f1f.jpg;https://img30.360buyimg.com/sku/jfs/t1/121404/16/23839/213150/6234317bEeb24e2c2/613b94ef3671ca71.jpg;https://img30.360buyimg.com/sku/jfs/t1/128682/28/25227/186117/6234317bE28dac036/4c9d95de7834334d.jpg;https://img30.360buyimg.com/sku/jfs/t1/130687/22/22472/131091/6234317aE3c8bfddd/9c79bbde0cb58110.jpg;https://img30.360buyimg.com/sku/jfs/t1/216014/19/15268/123257/6234317aE0698ce1a/0de945a5c84df4f3.jpg;https://img30.360buyimg.com/sku/jfs/t1/101042/3/24614/160834/6234317bE486675b7/8a8cc8260ee41629.jpg;https://img30.360buyimg.com/sku/jfs/t1/114239/21/22004/164366/6234317bEfc5e20df/9a46ae59b9adcbe1.jpg;https://img30.360buyimg.com/sku/jfs/t1/104040/33/24936/108753/6234317aE0a4e7a9d/2f9ba54eebd6acb2.jpg;https://img30.360buyimg.com/sku/jfs/t1/220980/12/15047/182816/6234317bEa3c501fc/c7ad442920df2aaf.jpg;https://img30.360buyimg.com/sku/jfs/t1/119852/25/24533/311184/6234317bE42bb79d7/4d8aee6cfb3bffbe.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (8, 1, 2, '小米12 Pro 骁龙8 Gen1 2K AMOLED 120Hz高刷 5000万疾速影像 120W小米澎湃秒充 12GB+256GB 黑色 5G手机', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/159602/34/24275/43042/61cb02beEd9516343/92a6b536bac8139a.jpg', 5399, 0, 'https://img30.360buyimg.com/sku/jfs/t1/103906/30/20842/400403/61cd7854E844fe15e/946c1e277c9643b6.jpg;https://img30.360buyimg.com/sku/jfs/t1/160711/3/28202/217033/61cd7854E25da8d17/c5bc430f3c3a9a6d.jpg;https://img30.360buyimg.com/sku/jfs/t1/222940/6/7699/182131/61cd7854Ea1ea0625/681dd05f2228339a.jpg;https://img30.360buyimg.com/sku/jfs/t1/213396/12/9662/252784/61cd7854E6f3ab617/03c188bf19a0bd2a.jpg;https://img30.360buyimg.com/sku/jfs/t1/207545/24/14768/112191/61d2ce90Edb7abf21/4e2687524c31579a.jpg;https://img30.360buyimg.com/sku/jfs/t1/207139/16/14521/244534/61cd7854E3ca36393/14c40e7780b1c2b6.jpg;https://img30.360buyimg.com/sku/jfs/t1/133327/11/20961/165665/61cd7854E6dc2d3da/2bb076a20fb16c79.jpg;https://img30.360buyimg.com/sku/jfs/t1/215443/6/9704/490397/61cd7854E314642c9/5005384cc151eaae.jpg;https://img30.360buyimg.com/sku/jfs/t1/173637/4/25896/48133/61e92b9eEa03a2213/d11bd4e9e783e49d.jpg;https://img30.360buyimg.com/sku/jfs/t1/105319/20/22439/500422/61e92bc5Ef9aae47c/8c6e73d1ed1379ab.gif;https://img30.360buyimg.com/sku/jfs/t1/207110/20/14543/70819/61cd7854E3d2e24d9/e808cae2669e41dc.jpg;https://img30.360buyimg.com/sku/jfs/t1/175837/29/26503/795601/61e92befE18cb3c8d/8f583c075eae2124.gif;https://img30.360buyimg.com/sku/jfs/t1/92556/21/20296/70796/61e92c00E49f44975/4c1fef5cc62c864a.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (9, 1, 2, '小米12 骁龙8 Gen1 黄金手感 6.28英寸视感屏 120Hz高刷 5000万疾速影像 67W快充 8GB+256GB 黑色 5G手机', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/173597/6/25135/121952/61caf7beE5897eb74/6d7930db2487d44b.jpg', 3969, 60, 'https://img30.360buyimg.com/sku/jfs/t1/210038/19/14552/366986/61ced528Ef2b078b9/24ed283672c72c71.jpg;https://img30.360buyimg.com/sku/jfs/t1/214872/16/9631/275893/61ced528Ed0b46b07/77e614c6e60a4c0a.jpg;https://img30.360buyimg.com/sku/jfs/t1/210273/20/14557/177121/61ced528E932a77dd/4f75e411545e37e7.jpg;https://img30.360buyimg.com/sku/jfs/t1/208559/32/14430/137308/61ced528E055115a4/d6f6c7907e267a93.jpg;https://img30.360buyimg.com/sku/jfs/t1/143261/1/26542/334575/61ced528E9511fefe/d6a18016b6cd7f96.jpg;https://img30.360buyimg.com/sku/jfs/t1/98533/23/20024/386576/61d2d2a2E6f8cdf10/76f09b4140fec1f8.jpg;https://img30.360buyimg.com/sku/jfs/t1/128871/3/21017/280962/61d7e486E7f3609b3/23d0fc148b93db6b.jpg;https://img30.360buyimg.com/sku/jfs/t1/138975/20/26754/185606/61ced528E912cb505/53e225a8dcc5edee.jpg;https://img30.360buyimg.com/sku/jfs/t1/150103/26/21333/200341/61ee7d95Eaed97bf2/ed7b9b5264fb3a06.jpg;https://img30.360buyimg.com/sku/jfs/t1/137616/8/23219/105696/61ced528E8cdd565d/2ec7a48a720bf6d7.jpg;https://img30.360buyimg.com/sku/jfs/t1/98365/3/19625/347396/61ced528E8462c11a/e8bfb841d3a0836a.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (10, 1, 2, 'Redmi 10A 5000mAh大电量 1300万AI相机 八核处理器 指纹解锁 4GB+64GB 暗影黑 智能手机 小米 红米', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/118570/6/22901/140568/62405481Ec821ec27/696b4f956afb80af.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/92920/15/24549/84763/62405482Ed55c6133/9b8f620878792b5d.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/146867/29/25214/102519/62405482E5f772012/b925f384669aed83.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/184067/26/21511/111284/62405481E553c2465/ab0e4e538beed373.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/120596/31/23577/78660/62405482Efd2c8ab3/7c52eecfc0f11b9c.jpg', 699, 0, 'https://img30.360buyimg.com/sku/jfs/t1/198014/8/21900/139645/624054c9Ea815ecd3/2e9760a78ffd6341.jpg;https://img30.360buyimg.com/sku/jfs/t1/191304/34/22397/385899/62466830E8f64af43/5eb8c22ad19d9319.jpg;https://img30.360buyimg.com/sku/jfs/t1/105257/27/24813/136528/624054c9E71716d67/ed5700d1814b6e5a.jpg;https://img30.360buyimg.com/sku/jfs/t1/136105/38/25523/293160/624054c9E40e6b9c9/f8317e42ded726c8.jpg;https://img30.360buyimg.com/sku/jfs/t1/88122/20/25842/273406/624054c9Ec9f728cf/0c3fed4fb5d629fd.jpg;https://img30.360buyimg.com/sku/jfs/t1/223224/7/13494/173577/624054c9Eb7207fad/cf6f18aba432abe1.jpg;https://img30.360buyimg.com/sku/jfs/t1/218669/7/15932/270310/624054c9E742e4a48/9d478729e2e98adf.jpg;https://img30.360buyimg.com/sku/jfs/t1/99583/5/26833/155476/624054c9E3cc79e5f/d667b70c30cf6693.jpg;https://img30.360buyimg.com/sku/jfs/t1/113348/26/22039/135975/624054c9E17ce26a2/0f191c707426b00f.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (11, 1, 2, '小米 MIX4 骁龙888+ 一体化陶瓷机身 全面屏 一亿像素三摄 哈曼卡顿双扬声器 12GB+256GB 陶瓷黑 5G旗舰手机', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/196670/23/17589/134158/61126898E1c685632/42d1352c3b419ab4.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/199403/20/2395/82102/61126898E30689f4f/a00d0986df2e7565.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/178892/36/18541/65823/61126898E219b0c77/ec8bd1e56a8da41c.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/198103/20/2491/32986/61126898Ee751ef61/236fab6b2a1fe81f.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/188346/5/17741/28005/61126898E5e818fe6/e57d6ccc386be8dc.jpg', 4399, 99, 'https://img30.360buyimg.com/sku/jfs/t1/203133/17/12039/87421/616eb703E1ccb169f/373fda34d9137fc0.jpg;https://img30.360buyimg.com/sku/jfs/t1/203062/9/11995/412872/616eb2a2Ed1f548a0/95187c295e63886b.jpg;https://img30.360buyimg.com/sku/jfs/t1/213634/19/1328/172432/61711bcbEa20bca4e/515901b132d2be7d.jpg;https://img30.360buyimg.com/sku/jfs/t1/191922/24/19674/162585/61235b31Ea68dce31/ecb530898ff5e7f0.jpg;https://img30.360buyimg.com/sku/jfs/t1/197871/40/2564/21767/61126219Ec1617b14/9b351e14d7cfa24e.jpg;https://img30.360buyimg.com/sku/jfs/t1/183321/11/18737/65473/6112621aE54d492a5/f546112658565dc9.jpg;https://img30.360buyimg.com/sku/jfs/t1/190993/17/17835/114117/6112621aEbe6709b3/e79102cc51d28d36.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (12, 1, 2, '小米（MI）米家扫地机器人1T扫拖一体机家用扫地拖地擦地机家用视觉导航3D避障米家APP互联扫地机 米家扫拖机器人1T', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/152150/19/4646/224943/5fa268e8Ee53b4f8e/2c3e5b1dc6d7a888.png;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/149436/4/13197/63036/5fa268e8Ef5accbfd/c46de020c46f937a.jpg', 1289, 0, 'https://img14.360buyimg.com/imgzone/jfs/t1/130740/3/14980/347305/5fa268f3E5ae6cb36/443b484cb4b4a57f.jpg;https://img14.360buyimg.com/imgzone/jfs/t1/126797/14/17327/279185/5fa268f3E47caeeca/449f332dd5d07a04.jpg;https://img13.360buyimg.com/imgzone/jfs/t1/134348/9/14760/319790/5fa268f3E140741a3/8a1f281286a453e5.jpg;https://img12.360buyimg.com/imgzone/jfs/t1/122591/17/17509/354880/5fa268f3Eff5b0074/12a8ca8812ad9082.jpg;https://img13.360buyimg.com/imgzone/jfs/t1/144663/13/13270/445900/5fa268f3E18f25b4c/3216294967899eb0.jpg;https://img12.360buyimg.com/imgzone/jfs/t1/133176/30/14737/340602/5fa268f3E5901379e/aab2469e3ba5d985.jpg;https://img10.360buyimg.com/imgzone/jfs/t1/138775/11/13191/245852/5fa268f4E8b0926e6/a1c9c2455416ead2.jpg;https://img13.360buyimg.com/imgzone/jfs/t1/144663/13/13270/445900/5fa268f3E18f25b4c/3216294967899eb0.jpg;https://img14.360buyimg.com/imgzone/jfs/t1/133139/30/14749/206878/5fa268f4E5aa9cc00/e20052bf88f9482e.jpg;https://img10.360buyimg.com/imgzone/jfs/t1/119959/25/17306/313808/5fa268f4E043d263f/599cfa02a39a661f.jpg;https://img10.360buyimg.com/imgzone/jfs/t1/119959/25/17306/313808/5fa268f4E043d263f/599cfa02a39a661f.jpg;https://img10.360buyimg.com/imgzone/jfs/t1/140813/35/13216/471413/5fa268f5E55b66398/29525d9c15d0095a.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (13, 1, 2, '小米Redmi AirDots 3 Pro 入耳式真无线蓝牙耳机 主动降噪 蓝牙5.2 无线充电 小米耳机 苹果华为手机通用', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/182853/37/5755/115257/60ab4a67E48cc30a1/d2200394e4bc48ae.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/173941/16/11570/95236/60adc511Eb28302d4/560b1b1077771794.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/134026/18/16119/115647/60adc511E0d0de09b/b9888a3954ab52f2.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/174608/14/11589/82135/60adc4eeE43bcd3df/a47f825da487e69a.jpg', 299, 0, 'https://img30.360buyimg.com/sku/jfs/t1/193223/2/18900/633040/611c8309Ec5defdf8/2555daad696fbb5e.jpg;https://img30.360buyimg.com/sku/jfs/t1/200328/29/7354/447608/613829bbE82c0d664/70239383ba313bf2.jpg;https://img30.360buyimg.com/sku/jfs/t1/188784/26/18868/870652/611c8309Eda2d6a4c/d723e7e0034dfd8e.jpg;https://img30.360buyimg.com/sku/jfs/t1/196318/36/18883/544824/611c8309E00466c13/d3df11c2d4e1d28f.jpg;https://img30.360buyimg.com/sku/jfs/t1/201211/14/2225/592875/611c8309E130080a1/1940ab22c0ffe4ed.jpg;https://img30.360buyimg.com/sku/jfs/t1/184054/12/19990/189442/611df7e5Ec4cc505f/5936452834e122e1.jpg;https://img30.360buyimg.com/sku/jfs/t1/182567/11/19985/161219/611c8309E99af7ee8/5aec0998fdad3b44.jpg;https://img30.360buyimg.com/sku/jfs/t1/202188/35/1937/457260/611c8309Ecf66ddd5/e45f1bc81e0da79c.jpg;https://img30.360buyimg.com/sku/jfs/t1/188821/18/18974/413520/611c8309Ee1a0aaae/59d836d0843d35fc.jpg;https://img30.360buyimg.com/sku/jfs/t1/188305/9/18958/591140/611c8309E841bc73a/b8ab914a064bcd7a.jpg;https://img30.360buyimg.com/sku/jfs/t1/190716/39/18348/408582/611c8309Ed59e4f34/88fa0b5a3af11c98.jpg;https://img30.360buyimg.com/sku/jfs/t1/109559/19/27394/102378/62491f83E2a28d6e6/bc8b4070eec91ee1.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (14, 1, 2, '小米摄像头 云台2K版 家用监控器 红外夜视 2K超高清 智能摄像机 300W像素升级版', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/200930/36/19555/151053/61bc31eaE10d6d3f9/2c37a02e84ba38b7.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/89141/24/17326/75918/5e855914Eed046bc0/4e40dd241f736a67.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/213717/40/8124/40121/61bc322aEe9710dd0/f48cc9cacb771942.jpg', 189, 55, 'https://img30.360buyimg.com/sku/jfs/t1/184803/6/512/109292/608277d5E868c6175/f62bb7efdcdfa61d.jpg;https://img30.360buyimg.com/sku/jfs/t1/176985/3/602/222606/608277d5E088d33ed/1b28ff0e5d117ccf.jpg;https://img30.360buyimg.com/sku/jfs/t1/169867/26/20469/170164/608277d5E1f1455e1/05d7f5161430bdd2.jpg;https://img30.360buyimg.com/sku/jfs/t1/171962/37/6059/176226/608277d5E0f393e73/bacce79316f11606.jpg;https://img30.360buyimg.com/sku/jfs/t1/184113/8/540/162514/608277d5E8597a05c/ef86d013e6ea8f53.jpg;https://img30.360buyimg.com/sku/jfs/t1/185099/6/564/103215/608277d5E2c741f24/a6d9b001c95a311f.jpg;https://img30.360buyimg.com/sku/jfs/t1/165775/39/21180/166117/608277d5E059b1954/901a38bd24fc89eb.jpg', 1, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (15, 1, 2, '小米摄像头 云台2K版 家用监控器 红外夜视 2K超高清 智能摄像机 300W像素升级版', 'https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/200930/36/19555/151053/61bc31eaE10d6d3f9/2c37a02e84ba38b7.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/89141/24/17326/75918/5e855914Eed046bc0/4e40dd241f736a67.jpg;https://m.360buyimg.com/mobilecms/s1265x1265_jfs/t1/213717/40/8124/40121/61bc322aEe9710dd0/f48cc9cacb771942.jpg', 189, 0, 'https://img30.360buyimg.com/sku/jfs/t1/184803/6/512/109292/608277d5E868c6175/f62bb7efdcdfa61d.jpg;https://img30.360buyimg.com/sku/jfs/t1/176985/3/602/222606/608277d5E088d33ed/1b28ff0e5d117ccf.jpg;https://img30.360buyimg.com/sku/jfs/t1/169867/26/20469/170164/608277d5E1f1455e1/05d7f5161430bdd2.jpg;https://img30.360buyimg.com/sku/jfs/t1/171962/37/6059/176226/608277d5E0f393e73/bacce79316f11606.jpg;https://img30.360buyimg.com/sku/jfs/t1/184113/8/540/162514/608277d5E8597a05c/ef86d013e6ea8f53.jpg;https://img30.360buyimg.com/sku/jfs/t1/185099/6/564/103215/608277d5E2c741f24/a6d9b001c95a311f.jpg;https://img30.360buyimg.com/sku/jfs/t1/165775/39/21180/166117/608277d5E059b1954/901a38bd24fc89eb.jpg', 0, 1651334400);
INSERT INTO `oyk_shop_lists` VALUES (16, 1, 2, '欧阳克直播课', '', 588, 44, '', 1, 0);
INSERT INTO `oyk_shop_lists` VALUES (17, 1, 2, '欧阳克直播课', '', 588, 33, '', 2, 0);
INSERT INTO `oyk_shop_lists` VALUES (18, 1, 2, '直播课', '', 588, 22, '', 2, 0);
INSERT INTO `oyk_shop_lists` VALUES (20, 1, 2, '朱老师直播课', '', 588, 11, '', 2, 0);

-- ----------------------------
-- Table structure for oyk_user
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user`;
CREATE TABLE `oyk_user`  (
  `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '昵称',
  `avatar` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像允许为空 为空使用默认头像',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1正常 0关闭 2违规禁用',
  `log_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录次数',
  `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册时间',
  `add_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册IP',
  `last_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后登录时间',
  `last_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后登录IP',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_user
-- ----------------------------
INSERT INTO `oyk_user` VALUES (1, '欧阳克', 'https://img.php.cn/upload/avatar/000/000/038/608672e86e92c486.jpg', '18811112222', 'e10adc3949ba59abbe56e057f20f883e', 1, 15, 1644321600, '127.0.0.1', 1651279572, '127.0.0.1');
INSERT INTO `oyk_user` VALUES (2, '朱天蓬', 'https://img.php.cn/upload/avatar/000/001/120/5f2a5b6053764987.jpg', '18811113333', 'e10adc3949ba59abbe56e057f20f883e', 1, 0, 1644321600, '127.0.0.1', 1644321600, '127.0.0.1');
INSERT INTO `oyk_user` VALUES (3, '灭绝师太', 'https://img.php.cn/upload/avatar/000/126/153/5f6aeb2589823833.png', '18811114444', 'e10adc3949ba59abbe56e057f20f883e', 1, 0, 1644321600, '127.0.0.1', 1644321600, '127.0.0.1');
INSERT INTO `oyk_user` VALUES (4, '西门大官人', 'https://img.php.cn/upload/avatar/000/069/489/5a60660646231943.png', '18811115555', 'e10adc3949ba59abbe56e057f20f883e', 1, 0, 1644321600, '127.0.0.1', 1644321600, '127.0.0.1');
INSERT INTO `oyk_user` VALUES (5, '来无影', NULL, '18811116666', 'e10adc3949ba59abbe56e057f20f883e', 1, 0, 1644321600, '127.0.0.1', 1644321600, NULL);
INSERT INTO `oyk_user` VALUES (6, '188****7777', NULL, '18811117777', 'e10adc3949ba59abbe56e057f20f883e', 1, 0, 1651029810, '127.0.0.1', 1651029810, '127.0.0.1');

-- ----------------------------
-- Table structure for oyk_user_code
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user_code`;
CREATE TABLE `oyk_user_code`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号',
  `code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '验证码',
  `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发送时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_user_code
-- ----------------------------

-- ----------------------------
-- Table structure for oyk_user_order
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user_order`;
CREATE TABLE `oyk_user_order`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键：ID',
  `oid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单ID，自动生成',
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `shop_id` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品ID',
  `money` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '金额',
  `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '下单时间',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1未支付 2已支付 0已取消',
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `pay_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '支付类型 1微信 2支付宝',
  `pay_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付时间',
  `cancel_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '取消时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_user_order
-- ----------------------------
INSERT INTO `oyk_user_order` VALUES (9, 'SHOP202204301908549418', 1, '2;1;', 6399, 1651316934, 0, NULL, 1, 0, 1651887549);
INSERT INTO `oyk_user_order` VALUES (10, 'SHOP202204301908549418', 1, '2;1;', 6399, 1651316934, 1, NULL, 1, 0, 0);

-- ----------------------------
-- Table structure for oyk_user_order_details
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user_order_details`;
CREATE TABLE `oyk_user_order_details`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键：ID',
  `oid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单ID，自动生成',
  `shop_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID',
  `num` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '商品数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of oyk_user_order_details
-- ----------------------------
INSERT INTO `oyk_user_order_details` VALUES (1, 9, 2, 10);
INSERT INTO `oyk_user_order_details` VALUES (2, 9, 1, 20);
INSERT INTO `oyk_user_order_details` VALUES (3, 10, 2, 30);
INSERT INTO `oyk_user_order_details` VALUES (4, 10, 1, 40);

SET FOREIGN_KEY_CHECKS = 1;

数据集处理与thinkphp请求响应

用thinkphp 实现一个网络请求
在thinkphp6 的app目录下 app/controller/index.php

<?php
namespace app\controller;

use app\BaseController;
use think\facade\Db;
use think\facade\Request;

//tp.com/Index/index
class Index extends BaseController
{
    public function index()
    {
        //return '<style type="text/css">*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px;} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:) </h1><p> ThinkPHP V' . \think\facade\App::version() . '<br/><span style="font-size:30px;">16载初心不改 - 你值得信赖的PHP框架</span></p><span style="font-size:25px;">[ V6.0 版本由 <a href="https://www.yisu.com/" target="yisu">亿速云</a> 独家赞助发布 ]</span></div><script type="text/javascript" src="https://e.topthink.com/Public/static/client.js"></script><think id="ee9b1aa918103c4fc"></think>';
        $query = Db::query("SELECT * FROM `shop_goods` where status=1");
        print_r($query);
   
   
    }

    //http://pl.com/index.php/index/edit?id=2
    public function edit(){
        print_r( $_GET );    // 原生get接收
        print_r( Request::param() ); // 获取当前请求的所有变量
        print_r( Request::param('id') );    // 获取当前请求的id变量
        print_r( Request::get() );
    }

    public function hello($name = 'ThinkPHP6')
    {
        return 'hello,' . $name;
    }
}

多项目加载

如果要使用多应用模式，你需要安装多应用模式扩展think-multi-app

composer require topthink/think-multi-app

然后在app文件夹下建立一个 admin 和 api 文件夹。

admin/controller/index.php

<?php
namespace app\admin\controller;
use app\BaseController;
use think\facade\Db;
use think\facade\Request;


class Index extends BaseController{
     // 你的入口函数是  index.php ，这个index.php不能丢了
    //http://plx.com/index.php/admin/index/index
    public function index()
    {
        print_r("admin controller");
    }
}

api/controller/index.php

<?php
namespace app\api\controller;

use app\BaseController;
use think\facade\Db;
use think\facade\Request;

//
class Index extends BaseController
{ 
    //http://plx.com/index.php/api/index/index
    public function index()
    {
        //return '<style type="text/css">*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px;} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:) </h1><p> ThinkPHP V' . \think\facade\App::version() . '<br/><span style="font-size:30px;">16载初心不改 - 你值得信赖的PHP框架</span></p><span style="font-size:25px;">[ V6.0 版本由 <a href="https://www.yisu.com/" target="yisu">亿速云</a> 独家赞助发布 ]</span></div><script type="text/javascript" src="https://e.topthink.com/Public/static/client.js"></script><think id="ee9b1aa918103c4fc"></think>';
         $query = Db::query("SELECT * FROM `shop_goods` where status=1");
         print_r($query);
   
  
    }

}

https://www.kancloud.cn/manual/thinkphp6_0/1297876

thinkphp6 允许跨越
app目录下的middleware.php

<?php
// 全局中间件定义文件
return [
    // 全局请求缓存
    // \think\middleware\CheckRequestCache::class,
    // 多语言加载
    // \think\middleware\LoadLangPack::class,
    // Session初始化
    // \think\middleware\SessionInit::class
    // 允许跨域
    \think\middleware\AllowCrossDomain::class
];

开发规范

1 ThinkPHP6.0遵循的是PSR-2的命名规范和PSR-4的自动加载。

2 目录和文件的规范如下：
a 目录名字（小写+下划线)
b 类库和函数文件统一用 .php为后缀
c 类的文件名均以命名空间定义，并且命名空间的路径和类库文件所在的路径一致
d 类（包含接口和Trait) 文件采用驼峰式命名和类库文件所在的路径一致
e 类名（包括接口和Trait)和文件名保持一致，统一采用驼峰式命名（首字母大写）

3 函数和类，属性命名规范如下：
a 类的命名采用驼峰命名，如User,UserType;
b 函数的命名使用小写字母和下划线(小写字母开头)的方式，如 get_client_ip;
c 方法的命名使用驼峰发（首字母小写）,如 getUserName;
d 属性的命名使用驼峰法（首字母小写），如：tableName;
e 特例：以双下划线 __ 打头的函数或方法作为魔术方法，如 __call 和 __autoload;

4 常量与配置的规范如下：
a 常量以大写字母和下划线命名，如 APP_PATH;
b 配置参数以小写字母和下划线命名，如url_convert;
c 环境变量定义使用大写字母和下划线命名，如 APP_DEBUG;

5 数据表和字段的规范如下：
a 数据表和字段采用小写加下划线的方式命名。
b 字段不要用下划线开头，如：think_user表和user_name
c 字段不建议使用驼峰和中文作为数据表和字段名

目录结构

1 ThinkPHP6.0 支持多应用模式部署，app是应用目录；
2 默认模式下，采用的是单模式，如下图结构：


www
|---app
|    |----controller
|    |----model
|    |----更多类库目录
|    |---common.php  公共函数文件
|    |---event.php   事件定义文件
|    |

多应用模式下

www
|   ---app
|       |--app_name  appname可以有多个
|       |       |----common.php 函数文件
|       |       |----controller   控制器目录
|       |       |----model        模型目录
|       |       |---view   视图目录
|       |       |--- ....  更多类库目录
|       |       |

我们确保对外访问的目录仅仅是public目录

在pp目录中还提供了一些文件，这些文件将在后面逐步讲到

 |---app
 |    |
 |    |----BaseController.php  默认基础控制器类
 |    |----ExceptionHandler.php  应用异常定义文件
 |    |----common.php  全局公共函数文件
 |    |----middleware.php  全局中间件定义文件
 |    |----provider.php  全局服务提供义文件
 |    |----Request.php  应用请求对象
 |    |----event.php  全局事件定义文件

开启调试和配置文件

通过命令行安装的TP6.0工程，会自动在根目录生成一个.example.env 文件，这个.env 文件是环境配置文件，我们只要删除前面的 .example 就可以让它生效就留下一个 .env

.env 文件

APP_DEBUG = true 这个改成true 就可以生效调试模式

DB_TYPE = mysql
DB_HOST = 127.0.0.1
DB_NAME = test
DB_USER = username
DB_PASS = password
DB_PORT = 3306
DB_CHARSET = utf8

DEFAULT_LANG = zh-cn

配置信息
1 配置文件有两种形式，开启调试我们采用.env 文件，这是一种，适合本地，部署的时候，它就不生效了。
2 另一种配置文件，在根目录下config里，有很多类型的配置，适合部署。

我们如何获取配置文件?
对于.env的文件，比如[DATABASE] 下的HOSTNAME=127.0.0.1 获取方式如下：

use think\facade\Env;
return ENv::get('database.hostname');

对于config文件，比如database.php 下的hostname 获取方式如下

use  think\facade\Config;
return Config::get('database.connections.mysql.hostname');

默认时候.env里的配置优先级更高

URL访问模式

public/index.php 可以省略，只要设置URL重写即可：
httpd.conf 配置文件中加载了mod_rewrite.so 模块， AllowOverride None 将None 改为All; 此时路径变更为 httP://localhost/tp6/public/test/hello/value/world

控制器定义

https://www.kancloud.cn/manual/thinkphp6_0/1037510

如果要改变controller目录名，需要在route.php配置文件中设置：

'controller_layer'    =>    'controllers',

不要在控制器中使用包括die、exit在内的中断代码。如果你需要调试并中止执行，可以使用系统提供的halt助手函数。

halt('输出测试');

guigui_hello

关注

21
点赞
踩
21

收藏

觉得还不错? 一键收藏
0
评论
创建TP 6项目的笔记

不要在控制器中使用包括die、exit在内的中断代码。如果你需要调试并中止执行，可以使用系统提供的halt助手函数。halt('输出测试');
复制链接

扫一扫