| 涉及数据库表 视频分类表：jiaocheng_fenlei | 字段名 | 类型 | 备注 | | id | Int | 自动递增；菜单的id（主键），不允许空 | | caidan_mingcheng | varchar | 菜单名称，允许空 | | caidan_jibie | int | 菜单级别，允许空 这里做到2级：值可以是:1 | 2 | | caidan_suoshu | int | 菜单所属上级菜单的id，允许空 | | paixu_id | int | 排序数字，数字大的在前面，允许空 |
视频课程表：shipin | 字段名 | 类型 | 备注 | | id | Int | 自动递增；菜单的id（主键），不允许空 | | xinxi_lxid1 | int | 信息1级类型的id，参考类型表的id | | xinxi_lxid2 | int | 信息1级类型的id，参考类型表的id | | xinxi_biaoti | varchar | 信息标题 | | xinxi_riqi | date | 信息日期 | | xinxi_tupian | varchar | 信息图片地址 | | xinxi_neirong | text | 信息内容 | | add_riqi | datetime | 信息发布的日期 | | add_shijian | datetime | 信息发布的时间 | | sp_jiage | int | 视频价格，0表示免费 | | laoshi_id | int | 上课老师id |
后台管理文件 | ht/shipin 视频管理 | caidan_1ji.php | 视频1级分类管理 | | caidan_2ji.php | 视频2级分类管理 | | shipin_add.php | 视频录入页面 | | shipin_add_act.php | 视频录入程序处理 | | shipin_list.php | 视频列表 | | shipin_xiugai.php | 视频修改页面 | | shipin_xiugai_act.php | 视频修改程序处理 | | shipin_del.php | 视频删除 |
微信小程序接口 | 分类 | wx_shipin_fenlei_list.php | 获取分类列表 | | 视频 | wx_shipin_all.php | 获取所有视频和查询内容 |
获取视频分类接口 接口程序 | 1 | wx_shipin_fenlei_list.php
|
参数：无 接口样本 | 1 | http://localhost:500/wx_shipin_fenlei_list.php
|
返回数据 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 | [
{
"jibie":1,
"jibie_id":236,
"jibie_mc":"基础课"
,"menu":[ {
"jibie":2,
"jibie_id":246,
"jibie_mc":"HTML"
}
, {
"jibie":2,
"jibie_id":247,
"jibie_mc":"CSS"
}
, {
"jibie":2,
"jibie_id":248,
"jibie_mc":"HTML5"
}
, {
"jibie":2,
"jibie_id":249,
"jibie_mc":"CSS3"
}
]
}
,
{
"jibie":1,
"jibie_id":237,
"jibie_mc":"数据库"
,"menu":[ {
"jibie":2,
"jibie_id":255,
"jibie_mc":"ACCESS"
}
, {
"jibie":2,
"jibie_id":256,
"jibie_mc":"MYSQL"
}
, {
"jibie":2,
"jibie_id":257,
"jibie_mc":"SQLSERVER"
}
, {
"jibie":2,
"jibie_id":258,
"jibie_mc":"oracle"
}
, {
"jibie":2,
"jibie_id":259,
"jibie_mc":"MongoDb"
}
, {
"jibie":2,
"jibie_id":260,
"jibie_mc":"Redis"
}
, {
"jibie":2,
"jibie_id":261,
"jibie_mc":"其他"
}
]
}
,
{
"jibie":1,
"jibie_id":241,
"jibie_mc":"WEB开发"
,"menu":[ {
"jibie":2,
"jibie_id":264,
"jibie_mc":"ASP"
}
, {
"jibie":2,
"jibie_id":265,
"jibie_mc":"PHP"
}
, {
"jibie":2,
"jibie_id":266,
"jibie_mc":"NET"
}
, {
"jibie":2,
"jibie_id":267,
"jibie_mc":"JSP"
}
, {
"jibie":2,
"jibie_id":268,
"jibie_mc":"其他"
}
]
}
,
{
"jibie":1,
"jibie_id":242,
"jibie_mc":"微信小程序"
}
,
{
"jibie":1,
"jibie_id":243,
"jibie_mc":"JavaScript"
,"menu":[ {
"jibie":2,
"jibie_id":250,
"jibie_mc":"Javascript"
}
, {
"jibie":2,
"jibie_id":251,
"jibie_mc":"Angular"
}
, {
"jibie":2,
"jibie_id":252,
"jibie_mc":"React"
}
, {
"jibie":2,
"jibie_id":253,
"jibie_mc":"Typescript"
}
, {
"jibie":2,
"jibie_id":254,
"jibie_mc":"node"
}
, {
"jibie":2,
"jibie_id":262,
"jibie_mc":"jquery"
}
, {
"jibie":2,
"jibie_id":263,
"jibie_mc":"Vue"
}
]
}
,
{
"jibie":1,
"jibie_id":244,
"jibie_mc":"移动开发"
}
,
{
"jibie":1,
"jibie_id":245,
"jibie_mc":"其他"
}
]
|
获取所有视频接口 接口程序 参数：无 接口样本 | 1 | http://localhost:500/wx_shipin_all.php
|
返回数据 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | [
{
"sp_id" : 47,
"sp_mc" : "测试视频",
"sp_jianjie" : "",
"sp_tupian" : "http://localhost:500/up/tupian/202007011152060000008264.png",
"sp_jiage" : 20,
"yeshu" : 2 }
,
{
"sp_id" : 46,
"sp_mc" : "测试课程01",
"sp_jianjie" : "",
"sp_tupian" : "http://localhost:500/up/tupian/202006281453510000005633.png",
"sp_jiage" : 0,
"yeshu" : 2 }
,
{
"sp_id" : 44,
"sp_mc" : "CSS零基础入门",
"sp_jianjie" : "",
"sp_tupian" : "http://localhost:500/up/tupian/202006281146310000009479.png",
"sp_jiage" : 19,
"yeshu" : 2 }
.......
{
"sp_id" : 39,
"sp_mc" : "JavaScript基础",
"sp_jianjie" : "",
"sp_tupian" : "http://localhost:500/up/tupian/202006281143540000005720.png",
"sp_jiage" : 79,
"yeshu" : 2 }
]
|
|
