PHP

Laravel Eloquent sum of multiplied columns

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

Laravel Eloquent sum of multiplied columns

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

Laravel Eloquent sum of multiplied columns

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