thinkphp3.0 数据查询

来源:互联网 发布:电商美工设计 编辑:程序博客网 时间:2024/05/01 11:56
$data =$user->field('name as uname')->select();
$data = $user->order('id desc')->select();
$data = $user->order('id ')->limit(5)->select();
$data = $user->page('1,10')->select();
$data = $user->group('active')->select();
$data = $user->group('active')->having('active=1')->select();
$data = $user->join('A on user.id=A.id')->select();
$data = $user->join('inner join A on user.id=A.id')->select();
$data = $user->join('right join A on user.id=A.id')->select();
$data = lock(true)->select();
原创粉丝点击