Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 這次要解決的是如何在更新資料時,當傳進的值為null時,不會把null也存進db,只挑出有值的存入db.
- 省思:
- 對於array的概念和key、value的概念還不夠通透,所以無法將'oneMonthRent' => $data['oneMonthRent'] 直接想到設一個$value[],
- 用 $value[$rent] = $data[$rent]來存.
- 解法:
- // 將key名稱存入array中
- $rents = [
- 'oneMonthRent',
- 'twoMonthsRent',
- 'threeMonthsRent',
- 'fourMonthsRent',
- 'fiveMonthsRent',
- 'sixMonthsRent',
- 'yearRent'
- ];
- // 建立一個array,待會兒將有值的資料存入該陣列
- $values = [];
- // 檢查是否有值
- foreach($rents as $rent) {
- if (isset($data[$rent])) {
- $value[$rent] = $data[$rent];
- }
- }
- // 進行更新
- $this->listing
- ->where('listingId', $listingId)
- ->update($value);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement