php - Laravel:选择数据库错误 undefined index 或尝试获取非对象的属性

Question

第一个 Laravel 项目。我有一个 DBController，它在 url 之后从数据库中选择一行(例如 URL 是/product/123，然后它搜索条形码为 123 的产品)。我想在下一页制作一个关于产品详细信息的表格。

Controller :

class ProductDetailsController extends Controller
{
    public function product($id){
    $product = DB::select('select * FROM inventory WHERE barcode = ?', [$id]);;
    return view('productdetails',['product'=>$product]);
    }
}

print_r($product) 输出:

Array ( [0] => stdClass Object ( [ID] => 1 [barcode] => 01233 [brand] => Ismeretlen [supplier] => 1 [type] => Építésianyag [name] => Homok [img] => homok.jpg [wholeprice] => 3000 [price] => 5500 [VAT] => 3 [whereis] => U [whereis2] => 1 [count] => 8 [dimension] => m3 [threshold] => 1 [lastsell] => [lastbuy] => [lastchange] => 2017-02-23 20:56:46 [register] => ) )

如果我尝试 {{ $product->brand }} 我得到:

ErrorException in 20d205ed160f36c734b8252e44ac81bfa0977988.php line 6: Trying to get property of non-object (View: /var/www/html/project/laravel/leltar/resources/views/productdetails.blade.php)

如果我尝试 {{ $product['brand'] }} 我得到:

ErrorException in 20d205ed160f36c734b8252e44ac81bfa0977988.php line 6: Undefined index: brand (View: /var/www/html/project/laravel/leltar/resources/views/productdetails.blade.php)

出了什么问题？

我从 this PDF 学习 Laravel

Answer 1

一旦检查数组的结构，它首先具有第 0 个索引，

你应该得到它，

{{$product[0]->brand}}

或

$product = DB::table("inventory")->where("barcode", $id)->first();
// and get data as
echo $product->brand;

试一试，它应该有效。