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

Why DevOps Consulting is Critical for Startups

In the fast-paced world of startups, agility, efficiency, and rapid innovation are paramount for success. DevOps practices, which integrate development and operations to streamline workflows and accelerate…

How to Prepare for a DevOps Consulting Engagement

Embarking on a DevOps consulting engagement is a strategic move that can transform your organization’s IT operations, enhance efficiency, and accelerate innovation. Proper preparation is crucial to…

How to Install Drupal 10 on Linux ?

In this tutorial we’re going to learn how to install Drupal 10 on Linux server. Follow this tutorial i have installed and run the project in very…

Best DevOps Freelancer in the World

In the dynamic and ever-evolving world of DevOps, finding individuals who not only excel in their technical capabilities but also lead with innovation and insight is rare….

File structure of drupal | Basic Directory Structure of a Drupal ?

What is Drupal ? Drupal is a popular open-source content management system (CMS) written in PHP and built upon the Symfony framework. It is used worldwide to…

How to send attachment files to email using laravel | Upload Document and send Mail in Laravel

In this tutorial im going to demonstrate how to upload document and send data via Email. Please follow some easy steps mentioned below. First let’s go to…

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