vendredi 2 octobre 2015

Appending "where" to model in foreach is not applying

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