/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 vote160 views1 answer
How to take last entry in database in laravel Method ONe
PHP Laravel
0 vote147 views1 answer
How to get a particular column in laravel 8
PHP Laravel
12 votes164 views4 answers
Laravel get second last record
PHP Laravel
0 vote157 views2 answers
Nested array in laravel
PHP Laravel
0 vote168 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel
0 vote152 views1 answer
Laravel event generate
PHP Laravel
0 vote155 views1 answer
Textarea laravel migration
PHP Laravel
2 votes152 views1 answer
Laravel delete route
PHP Laravel
2 votes141 views1 answer
Global laravel request()
PHP Laravel
1 vote171 views3 answers
Laravel JSON query
PHP Laravel