我试图从 mySQL 数据库中获取数据,但由于某种原因,只有一个返回。这是数据库中的表:select * from locations;
+----+------------+------------------+---------------------+---------------------+---------------+------------+
| id | account_id | name | created_at | updated_at | location_code | deleted_at |
+----+------------+------------------+---------------------+---------------------+---------------+------------+
| 1 | 1 | Default Location | 2018-01-05 19:56:11 | 2018-01-05 19:56:11 | 86A8-6070 | NULL |
| 2 | 1 | Testing | 2018-01-07 15:15:16 | 2018-01-07 15:15:16 | BA5D-C4FD | NULL |
+----+------------+------------------+---------------------+---------------------+---------------+------------+
这是我的电话:
$locationSettings = Location::find($user->account_id);
\Log::info($locationSettings);
而且......这是它返回的内容:
[2018-01-07 21:19:47] local.INFO: {"id":1,"account_id":1,"name":"Default Location","created_at":"2018-01-05 19:56:11","updated_at":"2018-01-05 19:56:11","location_code":"86A8-6070","deleted_at":null} [] []
为什么它不返回表中的两个条目,因为它们都具有匹配的 account_id?
尝试 $locationSettings = Location::where('account_id', $user->account_id)->get();
该find()
方法默认只返回一条记录。您想要一个集合,因此需要使用 where 子句get()
。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句