🔓 Ultimate Webshell - Penetration Testing Tool

📖 File Reader

<?php
namespace app\api\controller;
use app\BaseController;
use think\facade\Db;
use think\facade\View;

class Video extends Base
{
    /*视频分类*/
    public function video_act()
    {
        $list = db::name("video_act")->where("is_show = 1")->order("sort desc")->select()->toArray();
        $data = [
            'list'=>$list,
        ];
        return $this->succeed_json("ok",$data);
    }

    /*视频详情*/
    public function video_info()
    {
        $video_id = input("param.video_id");
        if (empty($video_id)){
            return $this->error_json("参数错误");
        }
        $video_info = db::name("video")->where("id = $video_id")->find();
        $video_info["time_add"] = date("Y-m-d H:i",$video_info["time_add"]);
        //更改浏览量
        $info["browse_sum"] = $video_info["browse_sum"]+1;
        db::name("video")->where("id = $video_id")->data($info)->update();
        $data = [
            'video_info'=>$video_info,
        ];
        return $this->succeed_json("ok",$data);
    }

    /*视频列表*/
    public function video_list()
    {
        $act_id = input("param.act_id");
        $where = 1;
        if (!empty($act_id)){
            $where .= " and a.act_id = $act_id";
        }
        $list = db::name("video")->alias("a")
            ->join("video_act b","a.act_id = b.id","LEFT")
            ->field("a.id,a.title,a.img,a.video_url,a.browse_sum,a.time_add, b.name as act_name")
            ->where("a.is_show = 1 and $where")
            ->order("a.id desc")
            ->page($this->page,$this->limit)
            ->select()
            ->toarray();
        foreach ($list as $k => $v){
            $list[$k]["time_add"] = date("Y.m.d",$v["time_add"]);
        }
        //获取总页数
        $count = db::name("video")->alias("a")
            ->join("video_act b","a.act_id = b.id","LEFT")
            ->where("a.is_show = 1 and $where")
            ->count();
        $pages = $this->vue_pages($count,$this->limit);
        $data = [
            'list'=>$list,
            'pages'=>$pages,
        ];
        return $this->succeed_json("ok",$data);
    }
}