Count function In Laravel | Count function using whereNotNull query

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 :-

Hi I am Amit Kumar Thakur Experienced as s Software Developer with a demonstrated history of working in the information technology and services industry. Skilled in HTML, CSS, Bootstrap4, PHP, Laravel-9 , REST API,FB API,Google API, Youtube Api, Bitbucket,Github,Linux and jQuery. Strong engineering professional focused in Computer/Information Technology Administration and Management. Currently my profile is to Software Developer, analyze the requirement, creating frame for web application, coding and maintenance.

Related Posts

Top 25 Linux Commands for Users ?

In this tutorial i’m going to share Top 50 Important Linux Command for users with example. 1. Use of ls -la command. The ls -la command is…

XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not foundfail.

In this tutorial we’re going to solve the error XAMPP: Starting ProFTPD…/opt/lampp/share/xampp/xampplib: line 22: netstat: command not foundfail. Solution :- Next to restart the server

SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into `oauth_clients` (`user_id`, `name`, `secret`

In this tutorial we are going to solve error SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: insert into oauth_clients (user_id, name, secret error: –…

The Go-To Influencer Platforms for 2024

In the ever-evolving landscape of influencer marketing, one platform has risen above the rest to claim its throne as the reigning champion in 2024: WizBrand. With its…

Medical Tourism: A Distinguished Name in Worldwide Healthcare Travel

In the expanding world of medical tourism, certain websites have established themselves as distinguished names, offering unparalleled access to global healthcare services. These platforms serve as crucial…

Call to a member function getClientOriginalExtension() on null

In this tutorial i’m going to learn how to solve this issue Call to a member function getClientOriginalExtension() on null. This error usually occurs when you try…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x