how to select specific columns in laravel

Question

I want to show all values of two specified columns 'first_name' and 'pic' from my 'users' table. I am trying 'pluck' but it showing like json format when echo. But I need to show it, something - 'John pic' for all.Please, someone help me. Here is my sample code in 'index.blade.php' bellow -

<?php
$fName = DB::table('users')->pluck('first_name','pic');

echo $fName;
?>

`echo $fName;` casts to json. Try `dd($fName);` to see a collection. pluck method generates array key and value pairs, useful when generating select options.. in this case `array('pic'=>'first_name');` — Emeka Mbah, Aug 20 '17 at 06:11

Sagar Gautam · Accepted Answer · 2017-08-20T06:00:54.017

2

Use you can simply use select as

$fName = DB::table('users')->select('first_name','pic')->get();

Since, direct access to database from view is not preferred, you can write this query in controller function,

public function getData(){
    $fName = DB::table('users')->select('first_name','pic')->get();
    return view('index',compact('fName'));
}

Now, iterate over loop in view file,

@foreach($fName as $name)
    // access data like {{$name->first_name}} and {{$name->pic}}
@endforeach

Hope you understand.

edited Aug 20 '17 at 06:00

answered Aug 20 '17 at 05:55

Sagar Gautam

9,049
6
53
84

Here is an error when iterate over loop in view file – Rashed Hasan Aug 20 '17 at 06:20
I am using sentinel package – Rashed Hasan Aug 20 '17 at 06:39
You have error in controller code so inpect and view error preview in network – Sagar Gautam Aug 20 '17 at 06:57
Now, It's showing just pic name, not showing the image – Rashed Hasan Aug 20 '17 at 07:10
Can you add code you have write to display your image ? – Sagar Gautam Aug 20 '17 at 07:42
@foreach($fName as $name)
{{$name->first_name}}
{{$name->last_name}}
{{$name->pic}}

Rashed Hasan

Aug 20 '17 at 07:44

$fName = DB::table('users')->select('first_name','last_name','pic')->get(); – Rashed Hasan Aug 20 '17 at 07:44

@Md.RashedulHasan you should use `` tag to display image and should have to add file location in src value – Sagar Gautam Aug 20 '17 at 07:46

score 1 · Answer 2 · edited Sep 08 '22 at 12:47

1

You can use this code for retrieving specific column value:

//Eloquent: Get specific columns (not all the row). Pluck returns an array.
\App\Model::where('id', 1)->pluck('first_name','pic');
// If you only want to get the result value:
\App\Model::where('id', 1)->value('first_name');

edited Sep 08 '22 at 12:47

Dharman

30,962
25
85
135

answered Jul 23 '20 at 19:59

Tofiq

2,901
6
26
34

score 0 · Answer 3 · answered Oct 15 '21 at 05:04

0

You can get specific columns from a model using get() method, like

PostModel::where('post_status', 'publish')->get(['title', 'content', 'slug', 'image_url'])

pass the list of columns to get([...]) it will retrieve the modal data with specified columns.

answered Oct 15 '21 at 05:04

Ali Akbar Afridi

676
7
7

how to select specific columns in laravel

3 Answers3

Linked