PHP: How to display decimal numbers in an array?

Question

This is a tricky question to ask. A friend of mine seeks help, and I am not really into the project so it is difficult to describe the problem.

He has a shopping cart written in PHP, and in that shopping cart he wants all the product prices to be counted into a total price.

The problem is, all the prices are in a MySQL database. Displaying the prices (with decimals) is not a problem but, when these prices are counted and put in a variable, the decimals are not shown.

How can we solve this problem?

I will show you the code that he uses for displaying the prices in the shopping cart:

// Show cart
foreach($cart as $products) {
  // Split
  /*
    $product[x] -->
       x == 0 -> product id
       x == 1 -> hoeveelheid
  */
  $product = explode(",",$products);

  // Get product info

  $sql = "SELECT product_nummer, productnaam, verkoopprijs
         FROM product
         WHERE product_nummer = ".$product[0];  // Komt uit de sessie
  $query = mysql_query($sql) or die (mysql_error()."<br>in file ".__FILE__." on line ".__LINE__);
  $pro_cart = mysql_fetch_object($query);
  $i++;
  $price = $pro_cart->verkoopprijs; // variable price aanmaken zodat er opgeteld wordt

  echo "<tr>\n";
  echo "  <td>"."&nbsp;&nbsp;&bull;&nbsp;".$pro_cart->productnaam."</td>\n";     // naam
  echo "  <td><input type=\"hidden\" name=\"productnummer_".$i."\" value=\"".$product[0]."\" />\n"; // wat onzichtbare vars voor het updaten
  echo "      <input type=\"text\" name=\"hoeveelheid_".$i."\" value=\"".$product[1]."\" size=\"2\" maxlength=\"2\" /></td>\n";
  echo "  <td class=\"rechtsuitlijnen\">"."&#8364;&nbsp;".$pro_cart->verkoopprijs."</td>"."\n";
  $lineprice = $product[1] * $price;      // regelprijs uitrekenen > hoeveelheid * prijs
  echo "  <td class=\"rechtsuitlijnen\">"."&#8364;&nbsp;".$lineprice."</td>\n";
  echo "  <td><a href=\"javascript:removeItem(".$i.")\">X</td>\n"; //Product verwijderen
  echo "</tr>\n";


  // Total
  $total = $total + $lineprice; // Totaal updaten
}
?>

Alex M · Accepted Answer · 2012-01-03 13:42:38Z

2

For displaying formatted numbers, you can use the PHP sprintf function ( http://php.net/manual/en/function.sprintf.php )

<?php
$money1 = 68.75;
$money2 = 54.35;
$money = $money1 + $money2;
// echo $money will output "123.1";
$formatted = sprintf("%01.2f", $money);
// echo $formatted will output "123.10"
?>

answered Jan 3, 2012 at 13:42

Alex M

3,5232 gold badges22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Forza Over a year ago

Thank you very much ;) We added $lineprice2 = sprintf("%01.2f", $lineprice); to our code and it worked like a charm :)

Jules · Accepted Answer · 2012-01-03 13:41:16Z

1

Use: bcadd()

echo bcadd(10.50, 12.75, 2);

returns 23.25

answered Jan 3, 2012 at 13:41

Jules

7,2236 gold badges28 silver badges51 bronze badges

Comments

dusan · Accepted Answer · 2012-01-03 14:08:51Z

1

string number_format ( float $number [, int $decimals = 0 ] )
string number_format ( float $number , int $decimals = 0 , string $dec_point = '.' , string $thousands_sep = ',' )

Check out number_format documentation.

edited Jan 3, 2012 at 14:08

dusan

9,3033 gold badges39 silver badges56 bronze badges

answered Jan 3, 2012 at 13:42

Boopathi

1665 bronze badges

Collectives™ on Stack Overflow

PHP: How to display decimal numbers in an array?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related