Level 75
When you use orWhere you need to use logical grouping
So that part has to be like
->when($this->recherche != '', function ($query) {
return $query->where(function ($query) {
$query->where('velos.marque', 'like', '%'.$this->recherche.'%')
->orWhere('velos.modele', 'like', '%'.$this->recherche.'%')
->orWhere('velos.annee', 'like', '%'.$this->recherche.'%')
->orWhere('clients.nom', 'like', '%'.$this->recherche.'%')
->orWhere('clients.prenom', 'like', '%'.$this->recherche.'%');
});
})
1 like