如何在PHP中用DB计算字符串中的数字

Question

I echo some numbers from the database and show only those numbers with a foreach. I now want to calculate the total of these numbers.

$test = str_replace('\\', '', $orderDetails['jsonData']);
$bonbonOrders = unserialize($test);

foreach($bonbonOrders as $bonbonOrder){
    foreach($bonbonOrder as $bonbons){
        echo $bonbons['gewicht'];
    }
}

I tried several things but I really don't know how I can calculate them.

the output for a example can be:

18 15 16 12 11

Thanks!

Answer 1

This depends how you are getting those numbers from your database. However, since you are deserializing something I will assume that it cannot be done in a simple SQL query.

The following code should echo out the total of all of the numbers.

$test = str_replace('\\', '', $orderDetails['jsonData']);
$bonbonOrders = unserialize($test);

$nums = array();
foreach($bonbonOrders as $bonbonOrder){
    foreach($bonbonOrder as $bonbons){
        $nums[] =$bonbons['gewicht']; 
    }
}
$total = array_sum($nums);
echo $total;

Achieved by adding all of the numbers to an array, and calling array_sum on the final array.

Another alternative would have been to create $total = 0 before the foreach and to simply increment it as you get access to each number.