🚗🏍️ Welcome to Motoshare!

Turning Idle Vehicles into Shared Rides & New Earnings.
Why let your bike or car sit idle when it can earn for you and move someone else forward?

From Idle to Income. From Parked to Purpose.
Earn by Sharing, Ride by Renting.
Where Owners Earn, Riders Move.
Owners Earn. Riders Move. Motoshare Connects.

With Motoshare, every parked vehicle finds a purpose. Partners earn. Renters ride. Everyone wins.

Start Your Journey with Motoshare

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

How to Use Test Tasks to Evaluate DevOps Freelancers

Imagine reviewing incoming applications for a freelance engineering project where every resume is packed with impressive keywords like Kubernetes, AWS, Jenkins, and Terraform. Yet, when it comes…

Read More

Cracking the Code of Mumbai Transit: A Commuter’s Guide to Getting Around

There is an unmistakable tempo to life in Maharashtra’s coastal capital that instantly captivates anyone who arrives. Fueled by the relentless momentum of millions of people on…

Read More

Protecting Your Source Code and IP When Working with Freelance Developers

Introduction Imagine a growing software startup rushing to launch a critical new feature before a tight deadline by hiring an experienced freelancer and accidentally leaving their entire…

Read More

Log Aggregation and Monitoring: Complete Consultant Guide

1. Why Organizations Need a Unified View of Logs and Monitoring Imagine a production environment running across multiple cloud regions and container clusters where customers experience intermittent…

Read More

Building Long-Term Partnerships With DevOps Freelancers

Introduction Modern technology businesses operate in an environment where speed, reliability, and security dictate market success. Because of this demand, organizations increasingly work with independent DevOps professionals…

Read More

Two-Wheeled Horizons: Navigating the UAE on a Motorcycle

When people imagine traveling through the United Arab Emirates, their minds usually go straight to air-conditioned luxury sedans gliding down Sheikh Zayed Road or high-profile SUVs tackling…

Read More
0 0 votes
Article Rating
Subscribe
Notify of
guest
2 Comments
Oldest
Newest Most Voted
trackback

[…] Count function In Laravel | Count function using whereNotNull query […]

trackback

[…] Count function In Laravel | Count function using whereNotNull query […]

2
0
Would love your thoughts, please comment.x
()
x