How to pluck multiple columns in Laravel

php laravel eloquent laravel-collection
Hasnain Kahn picture Hasnain Kahn · May 2, 2019 · Viewed 7.3k times · Source

I want to get a student's full name, but in my database, I have two different columns: first_name and last_name. I want to get both of these columns at the same time.

Controller

public function getStudentName($id) 
{
    $students = DB::table("students")->where("students_class_id", $id)
        ->pluck("first_name", "id");

    return json_encode($students);
}

Answer

Zakaria Acharki picture Zakaria Acharki · May 2, 2019

Create custom accessor in your eloquent model like :

public function getFullNameAttribute()
{
   return $this->first_name . ' ' . $this->last_name;
}

Then use it in the query like :

$students = DB::table("students")->where("students_class_id",$id)->pluck("full_name","id");

Try it with eloquent like :

Student::where("students_class_id",$id)->pluck("full_name","id")->toArray();

Related questions

How to Merge Two Eloquent Collections?

I have a questions table and a tags table. I want to fetch all questions from tags of a given question. So, for example, I may have the tags "Travel," "Trains" and "Culture" attached to a given question. I want …

Read More
Laravel collection sortBy not taking effect

I'm trying to combine and sort the results from several db queries. $events = collect(); $downedEvents = EventDowned::where('mission', $missionId) ->orderBy('mission_time', 'asc') ->get(); $events->push($downedEvents); $getInOutEvents = EventGetInOut::where('mission', $missionId) ->orderBy(…

Read More
Laravel using Sum and Groupby

I would like to fetch sum of quantity in each month, so that I can display on bar chart quantities against month This is what I thought but didn't workout $data1 = Borrow::groupBy(function($d) { return Carbon::parse($d->…

Read More