我有以下型号:
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(使用前将#替换为@)