Finding out if a table is empty in laravel

Question

I'm trying to find out if my table is empty but I get this error

Call to undefined function App\Http\Controllers\isEmpty()

I did check the question that had a similar title to mine but that didn't have what I needed.

Here is my code

$orders = Order::all();

if(isEmpty($orders))
{
    echo "Im empty";
    die();
 }else{
    echo "im not empty";
     die();
 }

Duplicate of https://stackoverflow.com/questions/20563166/eloquent-collection-counting-and-detect-empty — Pankaj, Mar 01 '19 at 08:56
Possible duplicate of [Eloquent Collection: Counting and Detect Empty](https://stackoverflow.com/questions/20563166/eloquent-collection-counting-and-detect-empty) — René Höhle, Mar 01 '19 at 08:57

Cameron Wilby · Answer 1 · 2021-06-15T18:05:12.857

8

You should use Model::exists(). It returns true/false and runs a select count(*) from table where query under the hood.

if (Order::exists()) {
    echo "im not empty";
    die();
} else {
    echo "Im empty";
    die();
}

edited Jun 15 '21 at 18:05

answered May 16 '21 at 06:52

Cameron Wilby

2,222
1
25
35

score 4 · Answer 2 · answered Aug 24 '21 at 08:13

Ok since all of the answers in here are not good/optimized here is the fastest way to check whether a table has any rows/table is not empty

$order = Order::first();
if(is_null($order)) {
    // Table is empty.
}else {
    // Table is not empty.
}

Order::all() and Order::count() is bad because your table may have millions of records in it and when you get all rows you may get memory exception or even system hanging

Afraz Ahmad · Answer 3 · 2021-03-18T04:49:28.483

3

You can call eloquent count function to get count and then check if count is equal to zero.

$products = Order::count(); //returns products count
if($products == 0){
    //products table is empty
}

or

if($collection->isEmpty()){
//products table is empty.
}

edited Mar 18 '21 at 04:49

answered Mar 01 '19 at 09:01

Afraz Ahmad

5,193
28
38

Hemerson Varela · Answer 4 · 2021-03-30T12:54:10.093

1

The optimal and fastest way to check if a table is empty is by:

//When using eloquent
if(empty(Order::count())){
   // Do something here
}

Or

//When using query builder
if(empty(DB::table('orders')->count())){
   // Do something here
}

Internally these will count total number of rows on the database itself and it will generate the following query.

select count(*) as aggregate from `orders`

edited Mar 30 '21 at 12:54

answered Mar 16 '21 at 21:03

Hemerson Varela

24,034
16
68
69

score -1 · Accepted Answer · answered Mar 01 '19 at 09:01

-1

If you want to check an array, use empty($orders), for a Laravel Collection you can use $orders->isEmpty()

Currently you're calling a function isEmpty(), which doesn't exist.

Try this:

$orders = Order::all();

if($orders->isEmpty())
{
    echo "Im empty";
    die();
 }else{
    echo "im not empty";
     die();
 }

answered Mar 01 '19 at 09:01

Sam Smekens

46
8

This might give issues when you have like a lot of records in that table without a limiter, paging or anything. I would not recommend using this method. Say you have 2000 records. That's 2000 records that get loaded into ram, then hydrated into models, filling up your ram, snooping at CPU capacity. An `::exists()` or `count()` would be more at place, than this overly heavy operation. – Tschallacka Aug 24 '21 at 08:30

Udhav Sarvaiya · Answer 6 · 2019-03-01T09:15:26.703

-1

According to Laravel Documentation states you can use this way:

$orders = Order::all();
if($orders->isEmpty())
{   
  echo "Im empty";
} else {
  echo "Im not empty";
}

edited Mar 01 '19 at 09:15

answered Mar 01 '19 at 09:06

Udhav Sarvaiya

9,380
13
53
64

Finding out if a table is empty in laravel

6 Answers6