我想从我的数据库中获取数据，不包括我的部分数据

Question

     if($city!='Others'){

            $posts = Post::orderby('id','desc')->where(['city'=>$city])->paginate(10);
    }
    else{
            $posts = Post::orderby('id','desc')->whereNotIn(['city'=>'Lahore'])->paginate(10);
    }
}

I have displayed some specific data now I want to display data other than those which were displayed before.

First if is showing normal data and I am trying to display remaining data in else part.

Answer 1

Thank you for all your help. The only thing required was to keep whereNotIn statement values in an array. Like this.

    if($city!='Others'){

            $posts = Post::orderby('id','desc')->where(['city'=>$city])->paginate(10);
    }
    else{
   $posts = Post::orderby('id','desc')->whereNotIn(['city',array('Lahore')->paginate(10);
    }
}