public function getMemberHome() { date_default_timezone_set(config::$timezone); $today = date("Y-m-d"); // Holding watched movies id $watchedMovies = Order::where('member_id', '=', Session::get('member_id'))->select('movie_id')->get()->toArray(); // Building query whare id = ? or id = ? so on $ids = 'id = ?'; for ($i = 1; $i < count($watchedMovies); $i++) { $ids .= ' or id = ?'; } $memberWatchedMovies = Movie::orWhereRaw($ids, $watchedMovies)->get(); return View::make('adminArea/home/member-dashboard')->with('newMovies', Movie::orderBy('id', 'desc')->get()->take(20))->with('watchedMovies', $memberWatchedMovies); }