/PHP/Laravel/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 votes153 views1 answer
Read global laravel request()
PHP Laravel
4 votes154 views2 answers
Laravel migration update table column type
PHP Laravel
15 votes158 views6 answers
Laravel migration delete column
PHP Laravel
0 vote152 views1 answer
Laravel change error page to open in vscode
PHP Laravel
0 vote163 views1 answer
Illuminate\contracts\container\bindingresolutionexception: target class laravel 8
PHP Laravel
6 votes163 views6 answers
Get url parameters in laravel blade
PHP Laravel
5 votes143 views5 answers
Laravel csrf token off
PHP Laravel
0 vote153 views1 answer
Laravel allow null records relationship
PHP Laravel
1 vote148 views2 answers
Laravel update email unique
PHP Laravel
15 votes143 views6 answers
Laravel db transaction
PHP Laravel

Share