/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

1 vote120 views1 answer
Laravel password verification
PHP Laravel
0 vote202 views1 answer
Show sender name laravel
PHP Laravel
0 vote118 views1 answer
Laravel unique funcation
PHP Laravel
0 vote119 views1 answer
How to pass parameters to relationships laravel
PHP Laravel
0 vote110 views1 answer
Laravel asset resolving to http not https
PHP Laravel
11 votes115 views5 answers
Resource route laravel
PHP Laravel
0 vote114 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote112 views1 answer
Laravel routes return view in web.php
PHP Laravel
0 vote112 views1 answer
WhereJsonContains laravel
PHP Laravel
25 votes116 views6 answers
Laravel use cache
PHP Laravel