How to get the full-name from this query?

Question

I am trying to get the fullname from the database. but the data base doesn't have fullname but firstname lastname & middlename, I am new to laravel and i am trying to get the full name like this. but its giving me error

 'firstName' => $this->first_name,
 'middleName' => $this->middle_name,
 'lastName' => $this->last_name,
 'fullName' => $this->first_name + $this->middle_name + $this->last_name,

`$this->first_name . $this->middle_name . $this->last_name` use `.` to concat https://www.php.net/manual/en/language.operators.string.php#:~:text=The%20first%20is%20the%20concatenation,argument%20on%20the%20left%20side. — Kamlesh Paul, Dec 22 '20 at 08:39
@Daan Today my first day in php. I don't know the terms use in php. I am searching how to merge data :D — Kerry, Dec 22 '20 at 08:48

score 2 · Answer 1 · answered Dec 22 '20 at 08:45

2

easy to search but here you go:

$this->first_name .' '. $this->middle_name .' '. $this->last_name,

answered Dec 22 '20 at 08:45

milad hedayatpoor

626
4
15

score 0 · Answer 2 · answered Dec 22 '20 at 08:52

0

You can add it to your model. $user = User::find(1)

$user->fullName = $user->first_name.' '.$user->middle_name.' '.$user->lastName;

answered Dec 22 '20 at 08:52

Mohamed Baklouti

121
9

How to get the full-name from this query?

2 Answers2