php - Laravel find() 没有从数据库中获取数据

问题描述

我有一个使用这种index方法的资源控制器，如下所示：

public function index()
{
        $args = [];
        $args = array_merge($args, $this->data_creator(35, 12, 'book'));
        $args = array_merge($args, $this->data_creator(37, 12, 'kit'));
        $args = array_merge($args, $this->data_creator(38, 12, 'game'));

        $args['menu_links'] = [
            'books'     => route('shopping-products.category', Category::find(25)->slug),
            'videos'    => route('shopping-products.category', Category::find(24)->slug),
            'kits'      => route('shopping-products.category', Category::find(23)->slug),
            'games'     => route('shopping-products.category', Category::find(22)->slug),
        ];
    
        return view('frontend.shop.products.index', $args);
}

但它返回此错误：

试图获得非对象的属性“slug”

当我dd(Category::find(25), Category::find(24), Category::find(23), Category::find(22));得到NULL结果时。

这意味着它无法找到具有指定 ID 的数据。

但是，categories表中存储了 25 条记录：

那么这里出了什么问题呢？我该如何解决这个问题？

我真的很感激你们的任何想法或建议......

提前致谢。

这是Category.php模型：

class Category extends Model
{
    use Sluggable, SoftDeletes;

    protected $table = 'categories';
    protected $primaryKey = 'cat_id';
    protected $guarded = [];

    /**
     * Return the sluggable configuration array for this model.
     *
     * @return array
     */
    public function sluggable()
    {
        return [
            'slug' => [
                'source' => 'cat_name'
            ]
        ];
    }

    public function path()
    {
        return "/products/categories/$this->slug";
    }

    public function children()
    {
        return $this->hasMany(Category::class, 'cat_parent_id', 'cat_id');
    }

    public function parents()
    {
        return $this->hasMany(Category::class, 'cat_id', 'cat_parent_id');
    }

    public function products()
    {
        return $this->belongsToMany(Product::class, 'category_products', 'ctp_cat_id', 'ctp_prd_id');
    }

    public function news()
    {
        return $this->belongsToMany(News::class, 'category_news', 'ctn_cat_id', 'ctn_nws_id');
    }

    public function galleries()
    {
        return $this->belongsToMany(Gallery::class, 'category_galleries', 'ctg_cat_id', 'ctg_gly_id');
    }

    public function uploaded()
    {
        return $this->hasMany(UploadedFile::class, 'upf_object_id', 'cat_id')->where('upf_object_type_id', '=', '107');
    }

    public function articles()
    {
        return $this->belongsToMany(Article::class, 'article_category', 'act_cat_id', 'act_art_id');
    }

    public function olympiadExam()
    {
        return $this->belongsToMany(OlympiadExam::class, 'olympiads_exams_categories', 'oec_ole_id', 'oec_cat_id');
    }

    public function olympiadExamQuestion()
    {
        return $this->belongsToMany(OlympiadExamQuestion::class, 'olympiads_exams_questions_categories', 'oes_cat_id', 'oes_oeq_id')->orderBy('oeq_number', 'asc');
    }

    public function attr_attributes()
    {
        return $this->hasMany(CategoryAttribute::class, 'category_id', 'cat_id');
    } //

    public function attr_product()
    {
        return $this->hasMany(Product::class, 'prd_cat_att_id', 'cat_id');
    } //

    public function couponRelation()
    {
        return $this->hasMany(couponRelation::class, 'object_id', 'cat_id')->where('object_type', 'product_category');
    }

    public function magazines()
    {
        return $this->belongsToMany(Magazine::class, 'category_magazine', 'category_id', 'magazine_id');
    }

}

当我这样做时：dd(Category::where('cat_id', 25), Category::where('cat_id', 24), Category::where('cat_id', 23), Category::where('cat_id', 22));我得到这个结果：

标签： phplaraveleloquentlaravel-8laravel-5.8

php - Laravel find() 没有从数据库中获取数据

问题描述

解决方案

推荐阅读