/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 vote184 views2 answers
Show query in laravel
PHP Laravel
2 votes207 views1 answer
Set session after login with laravel
PHP Laravel
0 vote182 views1 answer
Laravel post request page csrf disable
PHP Laravel
1 vote192 views1 answer
Fecade Artisan:call laravel
PHP Laravel
0 vote193 views1 answer
Laravel collection forget
PHP Laravel
0 vote209 views1 answer
Laravel 8 db like query
PHP Laravel
1 vote198 views1 answer
Laravel 8 validation required if another field is not null
PHP Laravel
7 votes174 views5 answers
Laravel foreach loop index in controller
PHP Laravel
0 vote214 views1 answer
How to set up the laravel ssh keygen
PHP Laravel
1 vote189 views2 answers
Laravel eloquent multiple join
PHP Laravel