string into integers to add them

[pata]

This is a quick one, I have an string that looks like this:

11.6+34.8+11.6+69.6+ 

(grabbing it from values off a db). What is the quickest way to add them together?

I tried using some of the string to integer functions but it didn't do the trick. I can do it placing them into an array with explode then adding them, but I am sure there is a better way to do this. Even doing it as I grab them from the db:

                 $price = number_format($row['price'], 2);    // 2 decimals
                 $tax = ($price * number_format($row['tax'], 2) ) / 100;
                 $unitPrice = $tax + $price;
                 $totalPrice = ($tax + $price) * $row['quantity'];
                 $subTotal .= "$totalPrice+";
                 echo number_format($unitPrice, 2, ',', '.') ; 

Maybe do something here?

[lilleman]

Hi,

This seem to be a task for eval().

$numbers = '11.6+34.8+11.6+69.6';
echo eval('return '. $numbers); 

Let me know if I have misunderstood you, or if you need more help.

Yours, Erik.

[pata]

Thanks, I'll try it. I ended up doing this:

$subTotal[] = $totalPrice;
// after while loop
array_sum($subTotal);

I was just curious if there was a more elegant way to do it.

[lilleman]

Hi,

Using that method might be better than using eval(), since eval() takes down performance a bit.

Yours, Erik.

[swdev]

could these 3 lines

 $unitPrice = $tax + $price;
 $totalPrice = ($tax + $price) * $row['quantity'];
 $subTotal .= "$totalPrice+"; 

be replaced by

 $unitPrice = $tax + $price;
 $totalPrice = $unitPrice * $row['quantity'];
 $subTotal += $totalPrice; 

or am I missing something?

[pata]

could these 3 lines

 $unitPrice = $tax + $price;
 $totalPrice = ($tax + $price) * $row['quantity'];
 $subTotal .= "$totalPrice+"; 

be replaced by

 $unitPrice = $tax + $price;
 $totalPrice = $unitPrice * $row['quantity'];
 $subTotal += $totalPrice; 

or am I missing something?

Yes, I changed them right after posting this initially

[pata]

Hi,

Using that method might be better than using eval(), since eval() takes down performance a bit.

Ok, I'll keep it like that, thanks for your help.