9169-php/Application/Bibidd/Controller/TeacherController.class.php

<?php

namespace bibidd\Controller;

use Bibidd\Controller\CommonBaseController;

/**
 *
 * 老师
 */
class TeacherController extends  CommonBaseController
{
    /**
     * 查询三个随机老师
     * @return void
     */
    public function query_three_rand_teacher()
    {
        $this->addHeaders();

        $jintian = M("suiji_num")->where("id=1")->getField("time");
        $teacher_list_suiji_list = M("video_twelve_suiji")->where("type='性爱老师' and time='$jintian'")->Field('v_id')->select();
        //拼接查询ID
        $sql_charu = "";
        foreach ($teacher_list_suiji_list as $key1 => $value1) {
            $duifang_id = $value1['v_id'];;
            $xianzhi_one = " or id='$duifang_id'";
            $sql_charu .= $xianzhi_one;
        }

        $teacher_list = M('sex_knowledge')->where("id=0 $sql_charu")->select();
        $data['data'] = $teacher_list;
        $data['message'] = 'ok';
        $data['code'] = '200';
        echo  json_encode($data);
    }

    /**
     * 查询老师
     * @return void
     */
    public function query_teacher()
    {
        $this->addHeaders();

        $page = $_POST['page'];
        $one_size = $_POST['pageSize'];; //每頁30行記錄
        $page_one = ($page - 1) * $one_size;

        $teacher_list = M("sex_knowledge")->LIMIT($page_one, $one_size)->order("id desc")->select();

        $data['code'] = '200';
        $data['message'] = 'ok';
        $data['all_num'] =  M("sex_knowledge")->count();
        $data['data'] = $teacher_list;
        echo json_encode($data);
    }
}