thinkphp 数据表结合查询、带条件的分页、数值在两者之间查询

数据表结合查询

$data = Db::table('classify')
    ->alias('a')                //classify数据表的别名
    //join ['hf_help' => 'w'] w是别名, 要哪个表id在这写 ， condition是哪两个字段进行关联
    ->join(['hf_help' => 'w'], 'a.id=w.classifyId')
    ->order(['recommend' => 'desc', 'time' => 'desc'])
    ->select();
dump($data);

带有条件的数据库查询，但分页想要添加额外条件

$data = Db::table('classify')
    ->alias('a')
    ->join(['hf_help' => 'w'], 'a.id=w.classifyId')
    /*->where('a.id', $int)*/
    ->order(['recommend' => 'desc', 'time' => 'desc'])
    ->paginate(3, false, [
        'query' => request()->param()]);

查询数据库中间数值 在两者之间进行比较

$data = Request::only(['startime', 'endtime']);
//dump($data);

$startime = strtotime($data['startime']);
$endtime = strtotime($data['endtime']);
//dump($startime);
//dump($endtime);

$time = Db::table('hf_couple')
    ->whereTime('time', 'between', [$startime, $endtime])
    ->where('dispose', '=', 'n')
    ->order('time', 'desc')
    ->select();

转载于:https://my.oschina.net/u/4003338/blog/2870104