问题描述
我对laravel很陌生，有两个表，一个表，一个表.我只有一个与一个帖子相关的类别，因此我在帖子表中添加了类别ID.所以现在我要显示所有带有类别名称的帖子.
I am very new to laravel and have two table one post table and one category table. I have only one category related to one post, so i add category id in post table.So now i want to display all post with category name.
帖子表:id，名称，category_id，状态
post table:id,name,category_id,status
类别表:ID，名称
我想像职位名称类别名称
i want to dispaly likePOST NAMECATEGORY NAME
我有两个模型类别和职位，所以我该如何写出雄辩的关系或给我一种简单的方法来获取具有类别名称的职位数组
I have two model category and post, so how can i write the eloquent relationship or give me a simple way to get the array of post with category name
推荐答案
在Post模型上，您可以这样编写类别关系:
On your Post model you can write the category relationship like this:
public function category() {
return $this->belongsTo(Category::class); // don't forget to add your full namespace
}
然后您可以执行以下操作...
You can then do something like this...
$posts = Post::with('category')->get();
这将获取您所属类别的所有帖子.
which will get all your posts with the category it belongs to.
然后您可以遍历$posts变量，例如，使用blade ...
You can then iterate over the $posts variable, for example, using blade...
@foreach ($posts as $post)
<tr>
<td>{{ $post->name }}</td>
<td>{{ $post->category->name }}</td>
</tr>
@endforeach
在此处进一步阅读: https://laravel.com/docs/5.4/eloquent-relationships#defining-relationships
这篇关于从类别ID laravel获取类别名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！