🚗🏍️ 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

Engineering Operations Reality Check: How to Spot Hidden Risks and Plan Real Improvements

Take a look at the tech stack of almost any fast-moving software company today, and the setup appears impressive. Workloads run on managed Kubernetes clusters, infrastructure lives…

Read More

How to Optimize Hiring Costs Without Sacrificing Quality

Introduction Growing businesses and established enterprises frequently face the challenge of hiring skilled talent while operating under strict budget constraints, yet cutting recruitment spending blindly often triggers…

Read More

Scaling Without Friction: The Enterprise Shift Toward NoOps Automation

Today’s software engineering schedules move at a blistering rate, frequently leaving legacy IT workflows gasping for breath. When a technology company experiences rapid commercial expansion, it triggers…

Read More

Ultimate Guide to DevOps Freelance Pricing and Budgeting

1. Introduction Imagine a growing technology startup launching a new software product. The development team writes clean code and builds robust features, but deployment remains a manual,…

Read More

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