array_sum and trailing zero's

[coupe-r]

Hello everything,

 

I have the following code:

 

while($row = mysql_fetch_array($result))
{
     $due[] = $row['amount'];
     $total[] = $row['amount'];
}

    $due = array_sum($due);
    $total = array_sum($total);

 

My current output is:

 

$due = 23

$total = 100

 

What I would like is to have .00 at the end of each of those.

 

If either of the variables above naturally have decimals, they appear fine, just when they are integers.

 

Any help is appreciated.

[PaulRyan]

Hello Coupe-r

 

This is something off the top of my head...

  function addDecimal($value) {
    // Get length of value
    $length = strlen($value);
    // Get decimal places if any
    $getDecimal = substr($value,$length-3,$length-1);
    // Do preg match to check for decimals
    if(preg_match("/^\d+\.?\d{0,2}$/",$getDecimal)) {
      $value = $value.'.00'; // If no decimals add ".00"
    }
    return $value;
  }

 

Just pass each value though the function and it should in threory add .00 if no decimals exist.

If decimals do exist it won't do anything to the value.

 

Regards, Paul.

 

[sasa]

look function number_format()

[coupe-r]

Thank you for taking the time to do that.  I also found this:

 

number_format($total, 2, '.', '')

 

Would that do the same?

[coupe-r]

Looks like it will.  Thank you.

[Pikachu2000]

money_format() may also be useful . . .