如何在foreach时进行多个where查询 - How to make multiple where queries while foreach

How to make multiple where queries while foreach

本文关键字：where 查询 foreach | 更新日期: 2023-09-27

我想用Eloquent在查询中创建多个where。基本上你有这个：

<?php
    User::where('gender', '=', 'male')->where('age', '=', '18')->get();
?>

因此，假设您有一个foreach，它旋转两次来连接两个where子句。你怎么能做到？

$user = User::where('gender', '=', 'male')
foreach ($array as $key => $value) {
    $user .= $user->where($key, '=', $value);
}

你明白我的意思了吗？我知道我的榜样根本不可能。。但这是为了解释。

谢谢！

您可以执行以下操作。

$user = User::where('gender', 'male');
// Now add on a chain with loops or whatever expression you need.
$user = $user->where('field', 'value');
// Now get the results
$user = $user->get();