/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

8 votes313 views1 answer
Get all routes laravel
PHP Laravel
2 votes351 views1 answer
Call to undefined method JeroenNoten\\LaravelAdminLte\\Helpers\\MenuItemHelper::isSearchBar(
PHP Laravel
1 vote299 views2 answers
Laravel get url parameter value in controller
PHP Laravel
34 votes306 views4 answers
Make:controller in laravel 8
PHP Laravel
0 vote290 views6 answers
Socialite laravel 7
PHP Laravel
50 votes408 views6 answers
Laravel migration add column to existing table
PHP Laravel
0 vote345 views1 answer
Laravel secure url with query string
PHP Laravel
35 votes287 views3 answers
Run seeder command in laravel
PHP Laravel
8 votes282 views6 answers
Relationship in laravel
PHP Laravel
23 votes300 views4 answers
Laravel carbon isoformat
PHP Laravel