/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

15 votes146 views1 answer
Laravel composer install ignore
PHP Laravel
0 vote134 views1 answer
Current time input field in laravel form
PHP Laravel
1 vote158 views2 answers
Laravel route group middleware prefix
PHP Laravel
0 vote132 views1 answer
Singular from table laravel
PHP Laravel
7 votes137 views5 answers
Laravel remove public from url
PHP Laravel
0 vote144 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP Laravel
8 votes139 views1 answer
Get all routes laravel
PHP Laravel
0 vote140 views1 answer
Laravel Testing send raw data in GET method
PHP Laravel
0 vote136 views1 answer
Href in laravel view
PHP Laravel
2 votes158 views3 answers
Multiple primary key defined laravel
PHP Laravel