Laravel (HasMany) 不检索值

2023-12-07

我有以下型号:

    namespace App;

use Illuminate\Database\Eloquent\Model;

class forum_category extends Model
{
    //

    protected $table = 'forum_category';

    public function posts()
    {
        $this->hasMany('App\forum_post');
    }
}

And

namespace App;

use Illuminate\Database\Eloquent\Model;

class forum_post extends Model
{
    //
    protected $table = 'forum_post';


    public function category()
    {
        $this->belongsTo('App\forum_category');
    }
}

在我的控制器中,我尝试获取所有类别及其帖子:

    namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Routing\Controller;

use App\forum_category as forum_category;


class ForumController extends Controller
{

    public function __construct()
    {

    }

    public function index ()
    {

        $categories = forum_category::all();

        return view('forum', ['categories' => $categories]);
    }

    public function createPost()
    {

    }

    public function createReply()
    {

    }
}

然而,它似乎只返回我的类别。

有人可以告诉我我做错了什么吗?


查询应如下所示:

$categories = forum_category::with('posts')->get();

https://laravel.com/docs/5.5/eloquent-relationships#eager-loading

如果你有category_id in the forum_post表,这将加载具有相关帖子的类别。

然后只需迭代集合即可获取帖子:

@foreach ($categories as $category)
    @foreach ($category->posts as $post)
        {{ $post->title }}
    @endforeach
@endforeach

另外,关系应该是:

public function category()
{
    return $this->belongsTo('App\forum_category');
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

Laravel (HasMany) 不检索值 的相关文章