Using dynamic condition under auth check and request query

$query = Post::query();
if ( Auth::check() ) {
	$category = Category::pluck('id')->toArray(); //dd($category);  
	$categories = Category::get();    
	$recentPosts = Post::take(8)->orderBy( 'created_at', 'desc' )->get();;
} else {    
	$category = Category::where('is_public','=',1)->pluck('id')->toArray();           
	$query = $query->where('is_public',1);
	$categories = Category::where('is_public','=',1)->get();
	$recentPosts = Post::where( 'is_public', 1 )->take(8)->orderBy( 'created_at', 'desc' )->get();
}

if(!empty($request->query('keyword'))){
	$query->where('name','Like', '%'.$request->query('keyword').'%');
	$meta_title = 'Keyword: "'. $request->query('keyword') .'" Posts of Md Mahfoozur Rahman';
}

Related Posts


Using WhereIn

Updating multiple rows

Using Like

Using orWhere

What is Query Builder?

Using "with" in eloquent query

Getting last inserted id

Selecting last row of a table

Using parameters in find() method

Using local scope in eloquent

Using global scope in eloquent