/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

12 votes289 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
0 vote241 views5 answers
Run schedule laravel
PHP Laravel
0 vote239 views1 answer
Using laravel passport with mongodb
PHP Laravel
0 vote232 views2 answers
Laravel belongsto with condition date
PHP Laravel
0 vote248 views1 answer
Laravel create mode
PHP Laravel
2 votes243 views2 answers
The requested url was not found on this server. laravel
PHP Laravel
1 vote214 views1 answer
Laravel data types
PHP Laravel
0 vote244 views2 answers
Laravel sanctum instalation
PHP Laravel
0 vote230 views1 answer
Curl failed laravel centos
PHP Laravel
1 vote216 views2 answers
Return response at failedValidation() in request laravel
PHP Laravel