在Laravel中不带循环从数据库取值

Question

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

$shipping->option_one
$shipping->option_two

错误显然是

未定义属性:Illuminate\database\eloquent\collection::$preferences_option_one

未定义属性:Illuminate\database\eloquent\collection::$preferences_option_two

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

)
1

/var/www/html/vendor/laravel/framework/src/Illuminate/exception/handler.php第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);
}

Answer 1

当从数据库中获取一行时，不应该在最后使用get（）方法。必须在查询结束时使用first（）方法。所以只要改变

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

现在可以使用

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

希望能有所帮助。