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 | | 46094 Viewer | Category : Laravel
READ MORE

    PHP - How to Convert file(image, audio, video) extension using CloudConvert API?

    PHP - How to Convert file(image, audio, video) extension using CloudConvert API?

    Open Post

    Codeigniter 3 - select2 ajax autocomplete from database example with demo

    Codeigniter 3 - select2 ajax autocomplete from database example with demo

    Open Post

    AngularJS Ajax Autocomplete Using Typeahead in PHP Example

    AngularJS Ajax Autocomplete Using Typeahead in PHP Example

    Open Post

    PHP - Getting Started PHPUnit test with simple example

    PHP - Getting Started PHPUnit test with simple example

    Open Post

    Jquery Select2 - Select box with search example code

    Jquery Select2 - Select box with search example code

    Open Post

    Laravel 5 - create quick backend admin panel tutorial

    Laravel 5 - create quick backend admin panel tutorial

    Open Post