I want to filter by multiple fields by appending ->where()
to $usAddresses
. My problem is that my view seems to be outputting $usAddresses::all()
. I've tried applying ->get()
outside of the loop to no avail. I've also tried $results = $usAddresses
within the loop which does apply the "where" but only the latest.
$usAddresses = new address_us;
foreach ($request->all() as $fieldName => $value):
if (array_key_exists($fieldName, $usAddresses->first()->getAttributes())):
echo "Searching for $fieldName where like %$value%<br>";
$usAddresses->where($fieldName, "LIKE", "%{$value}%")->get();
endif;
endforeach;
return view('auth.app.merchkit.dashboard', ['usAddresses' => $usAddresses->paginate(15)])
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire