使用think-orm 模型查詢(xún)數(shù)據(jù)data返回為空,實(shí)際是有數(shù)據(jù)的
$lists = Order::field($field)->where($where)->order($order)->paginate($limit);
打印sql日志:SELECT * FROM order
WHERE ( pay
= 1 AND status
= 1 ) ORDER BY id
DESC LIMIT 0,10
使用環(huán)境:
"workerman/webman-framework": "~2.1",
"webman/think-orm": "~2.1",
查詢(xún)結(jié)果圖片:
因?yàn)槟闶褂昧朔猪?yè)功能,可能你的輸出查詢(xún)結(jié)果代碼有問(wèn)題,你可以試試輸出$lists->items()和$lists->total()試試
有沒(méi)有嘗試把log中生成的SQL語(yǔ)句直接在MySQL的console中查一下看看什么結(jié)果?
如果沒(méi)問(wèn)題可能就是代碼處理數(shù)據(jù)有問(wèn)題