/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

48 votes266 views5 answers
Laravel clear route cache
PHP Laravel
0 vote190 views1 answer
How see the list all artisan in laravel
PHP Laravel
1 vote213 views4 answers
Laravel object to array
PHP Laravel
0 vote228 views1 answer
Laravel enable mysql logging
PHP Laravel
11 votes228 views3 answers
Blade condition if else laravel
PHP Laravel
0 vote199 views1 answer
Fast excel export laravel
PHP Laravel
5 votes209 views2 answers
Laravel access controller method from another controller
PHP Laravel
0 vote223 views1 answer
Chart trong laravel
PHP Laravel
0 vote206 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel
0 vote188 views1 answer
Setup laravel on AWS
PHP Laravel