Laravel DB select only/except?

Question

I have this line:

$user = DB::table("users")
            ->where("email", $email)
            ->where("password", $password)
            ->first();

This selects all columns. Is there a way to discard or pick which columns to fetch or do I have to add each column I want to respond with manually? Like Request only() and except() methods.

Manual way:

response()->json([
    "name" => $user->name,
    ...
])

no you add select as a function on the query before you get the results (with ->first() ) laravel.com/docs/4.2/queries#selects — oBo
– oBo, Commented Jun 26, 2015 at 8:16

Praveen Srinivasan · Accepted Answer · 2015-06-26 08:41:51Z

2

This will get selected column....

$user = DB::table("users")
        ->select('name')
        ->where("email", $email)
        ->where("password", $password)
        ->first();

or

$user = DB::table("users")
        ->select('name')
        ->where("email", $email)
        ->where("password", $password)
        ->get();

you can return this result as json as follows

return Response::json($user);

For this you should add the controller use Response on the top.

edited Jun 26, 2015 at 8:41

answered Jun 26, 2015 at 8:18

Praveen Srinivasan

1,6204 gold badges28 silver badges55 bronze badges

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

4 Comments

Arbitur Over a year ago

Thanks, so there is only option to select which, and not which to ignore?

Praveen Srinivasan Over a year ago

Actually this is the proper way to select data from the database... This similar to SELECT query

Arbitur Over a year ago

Yes but just wondering if I would add a column later and dont have to add that column in my source aswell. Maybe Ill have to make a custom function for that?

Praveen Srinivasan Over a year ago

You will add column in future and don't want to add your source means you just select * from the db, then use it in view by column name. I don't know your question has solution.

Marwelln · Accepted Answer · 2015-06-26 09:08:22Z

1

You can pass an array in the first method with each field name you want to get.

->first(['field1', 'field2']);

edited Jun 26, 2015 at 9:08

Marwelln

29.5k21 gold badges97 silver badges120 bronze badges

answered Jun 26, 2015 at 8:17

Md Adil

3071 silver badge11 bronze badges

Collectives™ on Stack Overflow

Laravel DB select only/except?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related