/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

1 vote253 views1 answer
Laravel eloquent get only field name
PHP Laravel
0 vote244 views2 answers
Laravel limit foreach
PHP Laravel
0 vote259 views1 answer
How to migrate new column without empty the table in laravel
PHP Laravel
0 vote242 views1 answer
Laravel custom validation check if valid url
PHP Laravel
0 vote264 views1 answer
Dynamic modal name appending in laravel
PHP Laravel
8 votes289 views6 answers
Laravel transaction
PHP Laravel
15 votes249 views3 answers
Laravel make model with migration 5.8
PHP Laravel
0 vote246 views2 answers
How change default value for enum colun in laravel
PHP Laravel
38 votes185 views2 answers
Create request laravel command
PHP Laravel
8 votes250 views1 answer
If any error in blade laravel
PHP Laravel

Share