Taking values from database without loop in Laravel

Question

Is it possible to query table and show certain columns without looping of all the results?

So, I have this query

$shipping = Preferences::where('preferences_id', '=', 1)->get();

Now I'm trying to get this columns

$shipping->option_one
$shipping->option_two

The error is obviously

Undefined property: Illuminate\Database\Eloquent\Collection::$preferences_option_one

Undefined property: Illuminate\Database\Eloquent\Collection::$preferences_option_two

How can I do this?

print_r($shipping)

Array
(
    [0] => stdClass Object
        (
            [preferences_id] => 1
            [preferences_option_one] => Priority Mail
            [preferences_option_two] => Express Mail
        )

)
1

Error:

[2017-05-30 10:06:10] production.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Uncaught TypeError: Argument 1 passed to Illuminate\Exception\WhoopsDisplayer::display() must be an instance of Exception, instance of TypeError given, called in /var/www/html/vendor/laravel/framework/src/Illuminate/Exception/Handler.php on line 281 and defined in /var/www/html/vendor/laravel/framework/src/Illuminate/Exception/WhoopsDisplayer.php:43

/var/www/html/vendor/laravel/framework/src/Illuminate/Exception/Handler.php line 281

protected function displayException($exception)
{
    $displayer = $this->debug ? $this->debugDisplayer : $this->plainDisplayer;

    return $displayer->display($exception);   <--- line 281
}

/var/www/html/vendor/laravel/framework/src/Illuminate/Exception/WhoopsDisplayer.php:43

public function display(Exception $exception) <-- line 43
{
    $status = $exception instanceof HttpExceptionInterface ? $exception->getStatusCode() : 500;

    $headers = $exception instanceof HttpExceptionInterface ? $exception->getHeaders() : array();

    return new Response($this->whoops->handleException($exception), $status, $headers);
}

Md. Abutaleb · Accepted Answer · 2017-05-30 09:46:20Z

0

When you getting one row from the database then you should not use get() method at the end. You have to use first() method at the end of the query. So just change

From 
$shipping = Preferences::where('preferences_id', '=', 1)->get();
To 
$shipping = Preferences::where('preferences_id', '=', 1)->first();
or 
$shipping = Preferences::whereIn('preferences_id', 1)->first();

Now you can use

{{ $shipping->option_one }}
{{ $shipping->option_two }}

Hope it will helpful.

edited May 30, 2017 at 9:46

answered May 30, 2017 at 9:28

Md. Abutaleb

1,6551 gold badge15 silver badges24 bronze badges

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

6 Comments

user7956165 Over a year ago

This return some meaningless to me error: ::display() must be an instance of Exception, instance of Error given, called...

Md. Abutaleb Over a year ago

just make it dd($shipping) and show me the result as a screenshot

Md. Abutaleb Over a year ago

the output of print_r is by get() or first() ?

user7956165 Over a year ago

get() and first() same output for both.

user7956165 Over a year ago

Again this

Uncaught TypeError: Argument 1 passed to Illuminate\Exception\PlainDisplayer::display() must be an instance of Exception, instance of TypeError given,

|

linktoahref · Accepted Answer · 2017-05-30 09:52:33Z

0

You can use :

$pluck = $shipping->pluck('column', 'other')
$pluck->all()

edited May 30, 2017 at 9:52

linktoahref

8,0273 gold badges32 silver badges54 bronze badges

answered May 30, 2017 at 9:22

tom

11 bronze badge

Comments

Sagar Arora · Accepted Answer · 2017-05-30 09:59:35Z

0

Do it like below:

$shipping = Preferences::where('preferences_id', '=', 1)->get();//it return collection of objects

So to get value use it like:

$shipping[0]->option_one

Or change method from get() to first()

$shipping = Preferences::where('preferences_id', '=', 1)->first();//it returns single value object

And get value like:

$shipping->option_one

answered May 30, 2017 at 9:59

Sagar Arora

1,7831 gold badge11 silver badges20 bronze badges

1 Comment

user7956165 Over a year ago

when i use ->first(); it's return this PlainDisplayer::display() error

Exprator · Accepted Answer · 2017-05-30 10:00:12Z

0

$shipping[0]->preferences_option_one
$shipping[0]->preferences_option_two

edited May 30, 2017 at 10:00

answered May 30, 2017 at 9:20

Exprator

27.8k6 gold badges54 silver badges64 bronze badges

11 Comments

user7956165 Over a year ago

Now I got ErrorException: Undefined offset: 1

user7956165 Over a year ago

No errors now but this This page isn’t working. localhost didn’t send any data. ERR_EMPTY_RESPONSE

Exprator Over a year ago

do one thing can you show the output of this print_r($shipping );

user7956165 Over a year ago

Again this error

Uncaught TypeError: Argument 1 passed to Illuminate\Exception\PlainDisplayer::display() must be an instance of Exception, instance of TypeError given,

I don't even know what this means

user7956165 Over a year ago

in logs/laravel.log on page is just blank white page

|

Akash Kumar Verma · Accepted Answer · 2020-01-16 12:43:58Z

0

the problem :

$shipping = Preferences::where('preferences_id', '=', 1)->get();

will return a collection and you want to have an object.

so try

$shipping = Preferences::where('preferences_id', '=', 1)->first();

or other ways to get 1 object from the collection of results where 'preferences_id', '=', 1

edited Jan 16, 2020 at 12:43

Akash Kumar Verma

3,3582 gold badges19 silver badges33 bronze badges

answered May 30, 2017 at 9:23

VikingCode

1,0521 gold badge8 silver badges21 bronze badges

Collectives™ on Stack Overflow

Taking values from database without loop in Laravel

5 Answers 5

6 Comments

Comments

1 Comment

11 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

6 Comments

Comments

1 Comment

11 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related