我想知道如何从数据库中按从最新到最旧的顺序发布帖子,但要分页。
这是我当前的代码:
return view('index', [
'featured' => Post::orderBy('created_at', 'desc')->first(),
'posts' => Post::orderBy('created_at', 'desc')->skip(1)->take(6)->get(),
]);
因此,我将最新的帖子作为";特色";对于其余的帖子,我想先跳过(因为它已经被视为"特色"帖子(,然后从最新的帖子到最旧的帖子,但要分页。
编辑
如果以后有人需要这个,这段代码对我有效
$featured = Post::orderBy('created_at', 'desc')->first();
$posts = Post::orderBy('created_at', 'desc')->where('id', '!=', $featured->id)->paginate(2);
return view('index', [
'featured' => $featured,
'posts' => $posts,
]);
尝试以下代码:
return view('index', [
'featured' => Post::orderBy('created_at', 'desc')->first(),
'posts' => Post::orderBy('created_at', 'desc')->where(id, '!=', 1)->paginate(6),
]);
仅通过created_at 显示并订购
下面的代码对我有效:
$posts = Post::orderBy('created_at', 'desc')->get();