
[字段名稱存在大寫字母時候],盡量采用閉包查詢:
用例:orderId
~~~
//更新驗證及發放狀態
//
$record = Verify::get(function ($query) use ($transaction_id) {
$query->where('orderId', $transaction_id);
});
~~~
下面是錯誤的寫法:
~~~
//更新驗證及發放狀態
//
$record = Verify::getByOrderId($transaction_id);
~~~
因為駝峰字段的字符串將會被自動轉換成下劃線:
~~~
SELECT * FROM `Verify` WHERE `order_id` = '1000000383771410';
~~~