How to get two column of one row in one table using laravel eloquent query

Question

in Laravel i can get value of two column in one table in this code

$customerName = Customer::where('id', '=', Input::get('customerID'))->first()->customer_name;
        $created_at = Customer::where('id', '=', Input::get('customerID'))->first()->created_at;

i want to know that how to get this two value (customer_name and created_at) in one query

KyleK · Accepted Answer · 2015-01-29 09:03:09Z

1

I found this way in the doc:

Customer::where('id', '=', Input::get('customerID'))->lists('customer_name', 'created_at');

http://laravel.com/docs/4.2/queries#selects

answered Jan 29, 2015 at 9:03

KyleK

5,16920 silver badges35 bronze badges

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

Comments

Shojib Flamon · Accepted Answer · 2015-01-29 09:18:00Z

1

I use this code but not sure is it optimize or not

$customerID = Input::get('customerID');
$customer = Customer::findOrFail($customerID);
$customerName = $customer->customer_name;
$created_at = $customer->created_at;

answered Jan 29, 2015 at 9:18

Shojib Flamon

1,5694 gold badges13 silver badges18 bronze badges

1 Comment

lukasgeiter Over a year ago

This works fine and will only run one query. Not much to optimize here.

Collectives™ on Stack Overflow

How to get two column of one row in one table using laravel eloquent query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related