/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

0 vote347 views1 answer
Laravel ID Generator
PHP Laravel
0 vote282 views1 answer
Laravel api get controller
PHP Laravel
39 votes306 views6 answers
Create table laravel
PHP Laravel
0 vote351 views1 answer
Custom pagination laravel css
PHP Laravel
32 votes341 views1 answer
How to count the characters in laravel
PHP Laravel
1 vote346 views1 answer
Laravel 6 make http request
PHP Laravel
0 vote304 views3 answers
Laravel - How to create custom configuration variables and access
PHP Laravel
12 votes323 views4 answers
Laravel return redirect to named route
PHP Laravel
-1 vote366 views1 answer
Create user with tinker php laravel
PHP Laravel
0 vote329 views1 answer
Add attachment to the invoice laravel
PHP Laravel