在laravel中的数组错误上调用成员函数paginate()

Question

我想在laravel中创建分页，但会出现错误。这是错误的"呼叫到阵列上的成员函数paginate（）

这是我的查询

$blog = DB::select("select blog_post.*,(select img_name from blog_image WHERE blog_image.bid=blog_post.bid limit 0,1) as img_name, 
(SELECT count(*) FROM likes WHERE likes.bid =blog_post.bid) AS likes,
(SELECT count(*) FROM comment WHERE comment.bid =blog_post.bid ) as comments ,
(SELECT count(*) FROM blog_share WHERE blog_share.bid =blog_post.bid ) as  share 
from blog_post WHERE status=1 AND is_draft=0 AND is_publish=1 AND is_delete=0")->paginate(2);

Answer 1

您首先需要使用Laravel雄辩重写查询。例如：

$blog = DB::table('blog_post')->where([ 'status' => 1, 'is_draft' => 0, 'is_publish' => 1, 'is_delete' = 0 ])->paginate(2);

您严格不需要将所有计数/内部征服放入一个查询中。您可以使用雄辩的关系和突变器为您获取这些信息。例如，以下关系以获取图像：

class BlogPost extends Model
{
  public function image()
  {
    return $this->hasOne('BlogImage');
  }
}