Count my totals up - Laravel 5.2

Question

I have a "orders" table that holds the totals in each row for every order in my shop. I need to count all my totals from every single row to get a grand total. How would I set up my query in Laravel?

My Orders Table:

My function:

   public function index() {



        // Get all the orders in DB

        $orders = Order::all();



        // THAT DOESNT WORK, it just counts the rows

        $count_total = DB::table('orders')->select('count(total)')->count();

        dd($count_total); 



        // Get all the carts in DB

        $carts = Cart::all();





        return view('admin.pages.index', compact('orders', 'carts', 'count_products'));

    }

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

you can use Eloquent way, by doing this you can get total sum of column.

$total = Orders::sum('total');
echo "<pre>";
  print_r($total);
echo "<pre>";

Count my totals up - Laravel 5.2

Sign up