CREATE TABLE `Packs` (
`id_packs` int(11) NOT NULL auto_increment,
`price` double(7,3) default '0.000',
PRIMARY KEY (`id_packs`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `Contracts` (
`id_contracts` int(11) NOT NULL auto_increment,
`FinalPrice` decimal(20,3) default '0.000',
PRIMARY KEY (`id_contracts`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO Packs VALUES (3371, 27.260), (3372, 0.000), (3373, 0.000), (3374, 12.409);
INSERT INTO Contracts VALUES (204028, 27.260), (204029, 0.000), (204030, 0.000), (204031, 12.409);
SELECT * FROM Packs;
SELECT * FROM Contracts;
<?php
$queryPrice = "SELECT SUM(price) AS total_price FROM Packs WHERE id_packs IN (3371,3372,3373,3374);";
$queryFinalPrice = "SELECT SUM(FinalPrice) AS total_final_price FROM Contracts WHERE id_contracts IN (204028,204029,204030,204031);";
// Select using Laravel
$priceObj = $db::select($db::raw($queryPrice));
$finalPriceObj = $db::select($db::raw($queryFinalPrice));
var_dump($priceObj[0]->total_price, $finalPriceObj[0]->total_final_price);
$priceDouble = (double) $priceObj[0]->total_price;
$totalPriceDouble = (double) $finalPriceObj[0]->total_final_price;
var_dump($priceDouble, $totalPriceDouble);