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

Question

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')) }}

Answer 1

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

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);