public function user($username) { $uname = strip_tags(trim($username)); //get每次取多条数据,想取多条用take(n)->get(); $user = User::whereRaw('username =?', array($uname))->take(0)->get(); // $user=User::where('username',$uname)->take(0)->get();这种写法也可以 //检查用户是否存在 if (count($user) == 0) { return Response::make('user not exist', 404); } $uid = $user[0]->id; //获取当前用户的全部文章列表,分页显示 $articles = Article::where('uid', $uid)->where('status', 1)->paginate(5); //获取文章标签列表[通过uid查找] //$tags=Tag::where('uid',$uid)->groupBy('tag')->get(); $tags = $user[0]->getTags; //获取当前用户文章的总数 $total = Article::where('uid', $uid)->where('status', 1)->count(); //获取当前用户分类总数 $cates = User::find($uid)->getCate; //关联模型获取cate //获取博客创建时间 $age = $user[0]->created_at; $age = $this->formatTime($age); //按日期归档 $date = Article::select(DB::raw("DATE_FORMAT(created_at,'%Y%m') as time,count( DATE_FORMAT(created_at,'%Y%m')) as num"))->where('uid', $uid)->where('status', 1)->groupBy('time')->orderBy('created_at', 'desc')->get(); return View::make('blog.user', compact('articles'))->with('tags', $tags)->with('user', $user[0])->with('count', count($articles))->with('total', $total)->with('cates', $cates)->with('age', $age)->with('date', $date); }