How to get parent_id name of category table from post table-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)

How to get parent_id name of category table from post table

P粉936568533 2023-09-12 22:21:06

400

I have the following table in the "Category" table.

I have the following table in the "Release" table.

id	Name	category_id
1	阿杰	3
2	Mohan	3

Post.php file in model

public function category(){
            return $this->belongsTo(Category::class, 'category_id', 'id');
  }

If I put the following code, I will get the name of the third id which is math_student.

$post->category->name

But I want to get the name of the parent_id of the category, i.e. - "Student"

I tried the following code but got an error.

$post->category->parent_id->name

Please suggest me a solution

P粉936568533

reply all(2)

P粉3930309172023-09-13 10:28:10 2 floor

In the category model, add a parent relationship:

public function parent(){
        return $this->belongsTo(Category::class, 'parent_id', 'id')->withDefault();
    }

Then, you can get the parent name

$post->category->parent->name

Like +0

Add Reply

P粉9900084282023-09-13 00:59:29 1 floor

You need to establish a relationship using parent_id to find the model instance for Category inside it.

In the Category.php model:

public function parent(){
    return $this->belongsTo(Category::class, 'parent_id', 'id');
}

Afterwards, you will be able to:

$post->category->parent->name;

Like +0

Add Reply

Php8, I'm coming too