关于API

登录时判断api

public function Login(){
        $input = $this->getinput->json();
        $result = $this->db->where('user_name', $input['user_name'])->where('user_pass', $input['user_pass'])->get('user')->first_row('array');
        if ($result) {
            echo json_encode(array(
                'code' => 0,
                'msg' => '登录成功',
                'data' => $result
            ));
            return;
        }else{
            echo json_encode(array(
                'code' => -100,
                'msg' => '登录失败'
            ));
            return;
        }
    }

注册

 public function Reg(){
        $input = $this->getinput->json();
//        if (isset($input['id'])) {
//            return $this->edit_news();
//        }
        $count = $this->db->where('user_name', $input['user_name'])->from('user')->count_all_results();
        if ($count==0) {
            $data = array(
                'user_name' => $input['user_name'],
                'user_pass' => $input['user_pass'],
                'nick_name' => $input['nick_name'],
                'sex' => $input['sex'],
                'user_age' => $input['user_age'],
                'user_phone' => $input['user_phone'],
                'user_email' => $input['user_email'],
                'status' => $input['status'],
                'user_nationality' => $input['user_nationality'],
                'user_school' => $input['user_school'],
                'head_img' => $input['head_img'],
                'created_at' => date('Y-m-d H:i:s'),
            );
            $this->db->insert("user", $data);
            $nu = $this->db->affected_rows();
            if ($nu) {
                $data['code'] = 0;
                $data['msg'] = '创建成功';
                echo json_encode($data);
            } else {
                $data['code'] = -1;
                $data['msg'] = '创建失败';
                echo json_encode($data);
            }
        }
    }

上传视频类

 public function add_video(){
        $input = $this->getinput->json();
        $data = array(
            'film_name' => $input['film_name'],
            'film_time' => $input['film_time'],
            'film_language' => $input['film_language'],
            'film_classify' => $input['film_classify'],
            'film_introduct' => $input['film_introduct'],
            'classify_id' => $input['classify_id'],
//            'user_id' => $input['user_id'],
//            'video_url' => $input['video_url'],
            'poster_img' => $input['poster_img'],
            'still_img' => $input['still_img'],
            'created_at' => date('Y-m-d H:i:s'),
        );
        $this->db->insert("video", $data);
        $nu = $this->db->affected_rows();
        if ($nu) {
            $data['code'] = 0;
            $data['msg'] = '创建成功';
            echo json_encode($data);
        } else {
            $data['code'] = -1;
            $data['msg'] = '创建失败';
            echo json_encode($data);
        }
    }

根据分类id找出相应分类下的视频

根据提交字段classify_id判断找出同样id下所有视频列表

 public function get_videoList_by_classifyid()
    {
        $input = $this->getinput->json();
        $count = $this->db->where('classify_id', $input['classify_id'])->from('video')->count_all_results();
        if (isset($input['page'])) {
            $offset = ($input['page'] - 1) * 10;
            $query = $this->db->where('classify_id', $input['classify_id'])->offset($offset)->limit(10)->get('video')->result_array();
            $data = array(
                'data' => $query,
                'total' => $count,
            );
            echo json_encode($data);
        }
    }

获取电影类别标题

只读

public function get_ClassifyList()
    {
        $query=$this->db->get('classify')->result_array();
        $data = array(
            'data' => $query,
        );
        echo json_encode($data);
    }