tp3 key json 分頁

標籤：decode   str   array   轉換   member   json   join   list   row   

　//json 強制轉換為array

$arr[$key][‘checkpro‘] = json_decode($val[‘checkpro‘],JSON_FORCE_ARRAY);
    $arr[$key][‘messpro‘] = json_decode($val[‘messpro‘],JSON_FORCE_ARRAY);

{$Think.lang.$key}

$pro = D(‘Project‘);
        $count = $pro->where(‘status != -1‘)->count();
       
        $page = new \Think\Page($count,8);  
        $data = $pro->alias(‘p‘)
        ->field(‘m.realname,p.*,d.dname‘)
        ->where(‘p.status !=-1 ‘)
        ->join(‘ left join ganen_member m on p.charge = m.uid‘)
        ->join(‘ left join ganen_department d on p.pro_id = d.did‘)
        ->limit($page->firstRow.‘,‘.$page->listRows)
        ->select();  
        $page->setConfig(‘first‘,‘首頁‘);
        $page->setConfig(‘last‘,‘末頁‘);
        $page->setConfig(‘prev‘,‘上一頁‘);
        $page->setConfig(‘next‘,‘下一頁‘);
        $page->setConfig(‘theme‘,‘%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%‘);
        $show = $page->show();

        $this->assign(‘_page‘,$show);  
        $this->assign(‘_list‘, $data);
        $this->meta_title = ‘使用者資訊‘;
        $this->display();

tp3 key json 分頁