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
– Emeka Mbah, Commented Aug 20, 2017 at 6:11

Sagar Gautam · Accepted Answer · 2017-08-20 06:00:54Z

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, 2017 at 6:00

answered Aug 20, 2017 at 5:55

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Rashed Hasan Over a year ago

Here is an error when iterate over loop in view file

Rashed Hasan Over a year ago

I am using sentinel package

Sagar Gautam Over a year ago

You have error in controller code so inpect and view error preview in network

Rashed Hasan Over a year ago

Now, It's showing just pic name, not showing the image

Sagar Gautam Over a year ago

Can you add code you have write to display your image ?

|

Dharman · Accepted Answer · 2022-09-08 12:47:24Z

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 8, 2022 at 12:47

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jul 23, 2020 at 19:59

Tofiq

3,0116 gold badges29 silver badges34 bronze badges

Comments

Ali Akbar Afridi · Accepted Answer · 2021-10-15 05:04:36Z

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, 2021 at 5:04

Ali Akbar Afridi

91010 silver badges9 bronze badges

Collectives™ on Stack Overflow

how to select specific columns in laravel

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related