php - 在 Laravel/Eloquent 中返回多个而不是一个

Question

我正在尝试从 mySQL 数据库中获取数据，但由于某种原因只有一个返回。这是数据库中的表:从位置中选择 *;

+----+------------+------------------+---------------------+---------------------+---------------+------------+
| 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？

Answer 1

尝试$locationSettings = Location::where('account_id', $user->account_id)->get();

find() 方法默认只会返回一条记录。您需要一个集合，因此需要使用 get() 的 where 子句。