python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - eloquent

Sort an Eloquent model

Table for MyModel is like below id name parent_id -------------------------- 1 parent1 null 2 p1-c1 1 3 parent2 null 4 p1-c1-g1 2 5 p2-c1 ...
test-img

Mahdi

laravel

eloquent

Votes: 0

Answers: 3

Latest Answer

use Recursive relationship to same table For example if model name is MyModel then the relationship will be public function child(){ return $this->hasMany(MyModel::class,'parent_id','id'); } p...
test-img

John Lobo

In Laravel Eloquent, how do you UPDATE a model with a cast encrypted field in a table with a composite primary key?

I finally found out how to update data in a table with a composite primary key in Laravel. This is how. (Let's say the Vehicles table has a composite primary key of "make" and "model&q...
test-img

Magmatic

laravel

eloquent

laravel-8

laravel-9

Votes: 0

Answers: 2

Latest Answer

One way to do it is like this, but I would still like a solution that went through an actual Model. Vehicle::where("make", $make)->where("model", $model)->update([ "no...
test-img

Magmatic

Eloquent/query relationship bug?

I have a Customer model which hasMany CustomerContactInfo and hasMany CustomerBillingInfo relationships. In the controller update I get a payload and it contains data for all the three models and I se...
test-img

treb

php

laravel

eloquent

orm

Votes: 0

Answers: 0

Search multile words name in columns using laravel

Is there any better solution to the code below, I want to search names but first name and last name is different columns as of now I have this ->where(function($query) use($q){ $names =...
test-img

EasyWay

php

mysql

laravel

eloquent

laravel-8

Votes: 0

Answers: 3

Latest Answer

You can try this: Firstly concatenate first name and last name then apply search on them. $result = User::where(DB::raw('concat(first_name," ",last_name)') , 'LIKE' , '%keyword%')->get();...
test-img

Anuj Chandel

Posts

Questions

Blogs

Jobs