在 Laravel 9 中，查找集合中的多个键值对的实现
1、现在集合格式如下
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | Illuminate\Support\Collection Object( [items:protected] => Array ( [0] => Array ( [id] => 77631 [name] => 客户姓名 [email] => 44445@163.com [type] => 1 ) [1] => Array ( [id] => 77630 [name] => 王某人2 [email] => 4444@163.com [type] => 0 ) [2] => Array ( [id] => 77629 [name] => 王某人 [email] => 44445@163.com [type] => 1 ) [3] => Array ( [id] => 77628 [name] => 王某某 [email] => 44445@163.com [type] => 1 ) [4] => Array ( [id] => 77627 [name] => 李某某 [email] => 4444@163.com [type] => 1 ) ) [escapeWhenCastingToString:protected] => ) |
2、如果需要基于 id 查找，firstWhere 方法返回集合中具有给定键 / 值对的第一个元素
1 2 3 | $customer = $customers->firstWhere('id', 77631);print_r($customer);exit; |
1 2 3 4 5 6 7 | Array( [id] => 77631 [name] => 客户姓名 [email] => 44445@163.com [type] => 1) |
3、现在需要基于 name 与 email 这2个键值对查找。first 方法返回集合中通过给定真值测试的第一个元素。符合预期
1 2 3 4 5 | $customer = $customers->first(function ($value, $key) { return $value['name'] == '客户姓名' && $value['email'] == '44445@163.com';});print_r($customer);exit; |
1 2 3 4 5 6 7 | Array( [id] => 77631 [name] => 客户姓名 [email] => 44445@163.com [type] => 1) |
![在 Spatie\QueryBuilder ，请求参数中包含 "," 报错：SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens (SQL: select count(*) as aggregate from `table` where `table`.`shipping_type` = 2 and `shipping_at_gmt` >= 2024-05-21 08:54:14 and `shipping_at_gmt`](https://www.shuijingwanwq.com/wp-content/uploads/2024/09/1-520x245.png)
近期评论