Why i get every Item from Database in Laravel

Asked Jul 07 '21 at 10:35

Active Jul 07 '21 at 10:54

Viewed 39 times

this is my code:

 $customer = CustomerRepository::getInstance()->read($id)->first();
 $contacts = $customer->getContacts();

 $data = $contacts->where('firstname', '=', 'test' )
->orWhere('lastname', '=', 'test2')
    ->orderBy('lastname', 'asc'])->paginate(15);

...

public function getContacts()
{
    return $this->morphToMany(Contact::class, 'contactable');
}

I only want the contacts from the customer which has the certain firstname or lastname , why i get every contact from the Database table?

UPDATE: So i found out, if i delete the orWhere clauses it works, but with the orWhere i get every contact. But how can i do it with the orWhere Clause?

edited Jul 07 '21 at 10:54

asked Jul 07 '21 at 10:35

elias.xe

`$customer->getContacts()` <-- what does it return? – Danyal Sandeelo Jul 07 '21 at 10:38
it returns only the contacts from the customer, thats right – elias.xe Jul 07 '21 at 10:39
can you apply `where` on it, is it laravel compatible? `DB::table('users') ->whereColumn([['column', '>', value] ])->get();` – Danyal Sandeelo Jul 07 '21 at 10:40
->where is a method for collections from laravel – elias.xe Jul 07 '21 at 10:42
Do you need only those customers where both first name and last name is a match? – Samir Selia Jul 07 '21 at 10:53
*or sorry, firstname or lastname – elias.xe Jul 07 '21 at 10:55
1

check this https://stackoverflow.com/questions/18660180/laravel-or-where – Samir Selia Jul 07 '21 at 10:55

Why i get every Item from Database in Laravel

0 Answers0