如何从列表laravel中显示的数据库中获取数据

Whenever I am using this code I keep getting the following error: "Trying to get property of non-object"

每当我使用此代码时,我不断收到以下错误:“试图获取非对象的属性”

Controller:

public function createBooking()
{
    $products = DB::table('products')->orderBy('id', 'asc')->lists('id', 'name');
    return View::make('users.addbooking', array('products' => $products));
}

Blade View:

{{ Form::select('products', $products , Input::all('products')) }}

1 个解决方案

#1

Try this out, I'm running laravel 5 and it works fine for me.

尝试一下,我正在运行laravel 5,它对我来说很好。

Controller:

public function createBooking()
{
    $products = DB::table('products')
        ->orderBy('id', 'asc')
        ->lists('name', 'id'); // checked some of my code I have these swapped value first then id
    return View::make('users.addbooking', array('products' => $products));
}

Blade:

{{ Form::select('products', ['' => 'Select'] + $products, '', ['class' => 'myClass', 'id' => 'myId'] }}

If you're getting the Trying to get property of non-object error, try this at after your query in your controller to check your getting the right results for your query:

如果您正在尝试获取非对象错误的属性,请在控制器中的查询后尝试此操作,以检查您的查询是否获得了正确的结果:

dd($products);