think php5 multi-table query paging code method to get the total number-PHP Tutorial-php.cn

think php5 multi-table query paging code method to get the total number

jacklove

Release： 2023-03-27 12:56:02

Original

2372 people have browsed it

I encounter a lot of paging situations in tp5. This article will explain the relevant knowledge.

Controller

$data = input(&#39;get.&#39;);
    $info = [];
    //搜索条件
    if(!empty($data[&#39;title&#39;])){
        $data[&#39;title&#39;] = trim($data[&#39;title&#39;]);
        $info[&#39;topic_title&#39;] = [&#39;like&#39;,&#39;%&#39;.$data[&#39;title&#39;].&#39;%&#39;];
    }
    $list = BeModel::getList($info);
    $num = $list->total();//获取总数
    return $this->fetch(&#39;&#39;,[
        &#39;list&#39;  => $list,
        &#39;title&#39; => empty($data[&#39;title&#39;]) ? &#39;&#39; :$data[&#39;title&#39;],
        &#39;num&#39;   => $num
    ]);

Copy after login

Inside the model

$search = [];
    $search[&#39;b.status&#39;]     = [&#39;neq&#39;,-1];
    if(!empty($data[&#39;topic_title&#39;]) ){
        $search[&#39;b.topic_title&#39;]  =  $data[&#39;topic_title&#39;];
    }
 
    $res = self::alias(&#39;b&#39;)->join(&#39;subject s&#39;,&#39;s.id=b.subject_id&#39;,&#39;left&#39;)
        ->join(&#39;law l&#39;,&#39;l.id=b.law_id&#39;,&#39;left&#39;)
        ->field(&#39;b.*,s.subject,l.name&#39;)
        ->where($search)
        ->order(&#39;id asc&#39;)
        ->paginate(4,false,[
        &#39;query&#39; => request()->param(),
        ]);
    return $res;

Copy after login

This article explains the paging problem of tp5. For more related content, please pay attention to the php Chinese website.

Function analysis of commonly used functions in php

PHP The simplest implementation method for verifying logged in users (basic form user verification)

In PHP development, how to determine whether the previous script has finished running during scheduled execution?

The above is the detailed content of think php5 multi-table query paging code method to get the total number. For more information, please follow other related articles on the PHP Chinese website!