How to use count with where condition

Category: Eloquent ORM Topic: Eloquent Builder Created: 3 years ago 

$active_requests = UserPiggyBank::where('process',1)->count();

Last Edited: 3 years ago

Related Posts

Using selectRaw with aggregate function, where, orderBy, groupBy, take and get

Created: 3 years ago

Using WhereIn

Created: 3 years ago

Updating multiple rows

Created: 3 years ago

How to delete all the rows in a table

Created: 3 years ago

How to get names in list instead of associated array ( id as key and name as value )

Created: 3 years ago

Using Like

Created: 3 years ago

Checking what query is run with eloquent

Created: 3 years ago

Using orWhere

Created: 3 years ago

How to use condition in query dynamically

Created: 3 years ago

Using dynamic condition under auth check and request query

Created: 3 years ago

What is Query Builder?

Created: 3 years ago

Using "with" in eloquent query

Created: 3 years ago

Getting last inserted id

Created: 3 years ago

Selecting last row of a table

Created: 3 years ago

How to write multiple AND queries inside OR query using closure

Created: 3 years ago

Returning rows where a column is between two values

Created: 3 years ago

Selecting rows if they are NULL or NOT NULL

Created: 3 years ago

How to use whereHas to retrieve rows based on existence of relationship

Created: 3 years ago

Using withAggregates in Eloquent way

Created: 3 years ago

Selecting fields inside eager loading method "with"

Created: 3 years ago

Quick way to save or update post with one liner of eloquent code

Created: 3 years ago

Using model observer - a separate class to observe model changes and run desired logic

Created: 3 years ago

Changing model values using mutators before saving in database

Created: 3 years ago

Using parameters in find() method

Created: 3 years ago

Using findorFail() and firstOrFail() method

Created: 3 years ago

Using whereDate, whereYear, whereMonth, whereDay and whereCreatedAt for dates

Created: 3 years ago

Using brackets to specify two or more where clauses into its own where function in eloquent

Created: 3 years ago

Using local scope in eloquent

Created: 3 years ago

Using global scope in eloquent

Created: 3 years ago

How to use eloquent when - more elegant way of using if statement

Created: 3 years ago