問(wèn)題描述
使用 Raw，如何返回更新行的集合?
Using Raw, how to return collection of updated row?
例如:
$updated = DB::table('users')->where('id', 1)->update(['votes' => 123]);
我期待 dd($updated) 返回更新后的集合行，但它返回了 1.
I was expecting dd($updated) to return updated row of collection but it returned 1.
{{$updated->votes}} should return 123
推薦答案
它不是這樣工作的.你不能指望這個(gè)查詢會(huì)返回一個(gè)對(duì)象:
That's not how it works. You can't expect this query will return you an object:
$updated = DB::table('users')->where('id', 1)->update(['votes' => 123]);
如果您只想按照問(wèn)題中提到的方式使用查詢生成器，則需要手動(dòng)獲取一個(gè)對(duì)象:
If you want to use Query Builder only as you mentioned in your question, you'll need to get an object manually:
$data = DB::table('users')->where('id', 1)->first();
使用 Eloquent，您可以使用 updateOrCreate():
With Eloquent you can use the updateOrCreate():
$data = User::where('id', 1)->updateOrCreate(['votes' => 123]);
這將返回一個(gè)對(duì)象.update() 將返回布爾值，因此您不能在這里使用它.
This will return an object. update() will return boolean, so you can't use it here.
這篇關(guān)于update() 后返回集合?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！