/PHP/Laravel Eloquent sum of multiplied columns

Laravel Eloquent sum of multiplied columns

Laravel Eloquent sum of multiplied columns

$amount = Transaction::all()->sum(function($t){ 
    return $t->jumlah * $t->harga; 
});

0

Source: stackoverflow.com

Laravel Eloquent sum of multiplied columns

$amount = Transaction::sum(\DB::raw('jumla * harga'));

0

Source: stackoverflow.com

Laravel Eloquent sum of multiplied columns

$amount = Transaction::select(DB::raw('sum(jumlah * harga) as total'))->get();

0

Source: stackoverflow.com

Similar codes

2 votes171 views1 answer
OFFICE 2013
PHP
7 votes273 views3 answers
Laravel random query
PHP
0 vote201 views1 answer
Laravel collection flatMap
PHP
3 votes207 views2 answers
Get details of user using token in laravel passport
PHP Laravel
5 votes177 views2 answers
Php global variable function
PHP
1 vote171 views2 answers
Get wordpress posts by category name..!
PHP
2 votes222 views2 answers
How to add data to the request object in laravel
PHP Laravel
1 vote236 views1 answer
Laravel + join 2 eloquent queries
PHP Laravel
17 votes297 views6 answers
Laravel auth user in constructor
PHP Laravel
0 vote176 views1 answer
Distance between two locations in php
PHP

Share