/PHP/Laravel/Laravel search data relationship

Laravel search data relationship

$data = Subcategory::with(["category"])
                            ->where('name','like', '%'.$this->searchData.'%')
                            ->orWhereHas('category', function($query){$query->where('name', 'like', '%'.$this->searchData.'%');})
                            ->orderBy($this->orderByData, $this->orderByAsc ? 'asc' : 'desc')
                            ->paginate($this->showData);

Similar codes

44 votes226 views6 answers
Laravel migrate seed
PHP Laravel
0 vote163 views1 answer
Laravel eloquent return array where
PHP Laravel
19 votes165 views6 answers
Laravel query builder join
PHP Laravel
1 vote236 views1 answer
How to use old for select in blade laravel
PHP Laravel
0 vote205 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
0 vote226 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
1 vote172 views4 answers
Create json laravel
PHP Laravel
0 vote183 views1 answer
Laravel access request in provider
PHP Laravel
10 votes172 views3 answers
For loop in laravel
PHP Laravel
24 votes176 views6 answers
Laravel create model
PHP Laravel