In this tutorial I’m going to share how to use count function using whereNotNull follow this tutorial i having mentioned in very easy way.

Difference between whereNull and whereNotNull

The whereNull and whereNotNull methods are used in Laravel’s query builder to filter query results based on whether a column value is null or not null, respectively.

Example :- whereNull

$users = DB::table('users')->whereNull('email')->get();

Example :- whereNotNull

$posts = DB::table('posts')
->whereNotNull('category_id')
->get();

Now using whereNotNull in our project for count the data.

$count_manager = DB::table('userorganisations')->where('u_org_role_id', 2)->where('u_org_slugname', $org_slug)->whereNotNull('u_org_user_id')->count();

Output :-