/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 votes225 views2 answers
Laravel Edit
PHP Laravel
8 votes228 views6 answers
Laravel new project
PHP Laravel
-2 votes251 views2 answers
Carbon laravel d m y to y-m-d
PHP Laravel
0 vote225 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
23 votes221 views6 answers
Laravel 6 auth
PHP Laravel
0 vote242 views1 answer
Compiling multiple CSS into ONE CSS with Laravel MIX
PHP Laravel
1 vote222 views2 answers
Upload a pdf file laravel
PHP Laravel
2 votes222 views1 answer
Carbon time ago laravel
PHP Laravel
0 vote225 views1 answer
Laravel eloquent hasmany select
PHP Laravel
4 votes241 views5 answers
Laravel with and where
PHP Laravel