Tag : SUM()


Laravel 5 select with sum query example

We mostly required to get sum of amount, salary etc in laravel. We can also get sum of column using mysql SUM(). We have two way to get sum of column value. first we can use laravel sum() of query builder and another one we can use with directly with select statement using DB::raw(). I give you both example you can see and use any one as perfect for you. <strong>Example 1:</strong> <pre class="prettyprint lang-php"> $data = DB::table("click")->sum('numberofclick'); print_r($data); </pre> <strong>Example 2:</strong> <pre class="prettyprint lang-php"> $data = DB::table("click") ->select(DB.....

By Hardik Savani | June 8, 2016 | | 25093 Viewer | Category : Laravel
READ MORE

    Laravel 5 - Image Upload and Resize Example using Intervention Image Package

    Laravel 5 - Image Upload and Resize Example using Intervention Image Package

    Open Post

    Bootstrap multiselect dropdown in popup using popupMultiSelect plugin

    Bootstrap multiselect dropdown in popup using popupMultiSelect plugin

    Open Post

    Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 1

    Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 1

    Open Post

    How to make simple dependent dropdown using jquery ajax in Laravel 5?

    How to make simple dependent dropdown using jquery ajax in Laravel 5?

    Open Post

    Laravel 5 ajax request validation example

    Laravel 5 ajax request validation example

    Open Post

    Laravel 5 - Custom Helper Facade Class Example from scratch

    Laravel 5 - Custom Helper Facade Class Example from scratch

    Open Post