/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

47 votes462 views6 answers
Laravel create seeder
PHP Laravel
1 vote367 views4 answers
Create laravel project specific version
PHP Laravel
11 votes392 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
1 vote387 views1 answer
Run laravel mix
PHP Laravel
3 votes431 views1 answer
Insert rows in migrations laravel
PHP Laravel
0 vote427 views1 answer
How to make:trait in commend line in laravel
PHP Laravel
6 votes386 views5 answers
Migration rename column laravel
PHP Laravel
8 votes392 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
1 vote423 views3 answers
Make model factory and controller laravel
PHP Laravel
0 vote370 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel