/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 vote381 views1 answer
Laravel change error page to open in vscode
PHP Laravel
0 vote368 views1 answer
Pusher-php-server laravel
PHP Laravel
6 votes330 views2 answers
Create migration model and seeder laravel at once
PHP Laravel
0 vote336 views1 answer
Laravel enable extensions on Ubuntu
PHP Laravel
0 vote377 views2 answers
Laravel undefined index
PHP Laravel
0 vote353 views1 answer
Laravel migrate specific path
PHP Laravel
0 vote372 views1 answer
Validate file count with validate in laravel
PHP Laravel
0 vote360 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
0 vote358 views1 answer
Morph relation laravel
PHP Laravel
1 vote288 views1 answer
Laravel pluck multiple columns
PHP Laravel