order by
$res=$result->where('id','EXP','NOT in(20) ORDER BY id DESC')->select(); 這種類型怎么拼接order by，那位同學(xué)寫過。這么寫是錯誤的。直接order()方法沒啥問題。
storyAs
2017-07-16
3 回答
舉報
0/150
提交
取消
2017-08-26
建議你可以這樣寫：
$where= array();
$where['id'] = array('NOT IN','20');
$res=$result->where($where)->order('id DESC')->select();
2019-07-28
$sql = $db->whereOr([
? ? ? ? ? 'id' => ['NOT IN',25],
? ? ? ?])->order([
? ? ? ? ? 'id' => 'desc'
? ? ? ?])->select();
? ? ? ?
? ? ? ?dump($sql);
2017-07-16
$res=$result->where([
? ?'id'=>['not in','22'],
])->order([
? ?'id'=>'asc'
])->select();
output->
D:\thinkphp\thinkphp\library\think\Debug.php:165:array (size=2)
?0 =>
? ?array (size=5)
? ? ?'id' => int 21
? ? ?'username' => string '這個殺手不太冷' (length=21)
? ? ?'password' => string '6e453d094299ca1c9935281e6b250d31' (length=32)
? ? ?'email' => string 'shashou@hotmail.com' (length=19)
? ? ?'num' => int 0
?1 =>
? ?array (size=5)
? ? ?'id' => int 20
? ? ?'username' => string '猩球大戰(zhàn)' (length=12)
? ? ?'password' => string '914f21eb84c6fdb2b663dd6f453f65ca' (length=32)
? ? ?'email' => string 'imooc@163.com' (length=13)
? ? ?'num' => int 1