PHP number: decimal point visible only if needed

Question

I'd like to know if exists some function to automatically format a number by it's decimal, so if I have:

<?php
    // $sql_result["col_number"] == 1,455.75
    number_format ($sql_result["col_number"], 2, ".", "");
    // will return 1455.75

    // $sql_result["col_number"] == 1,455.00
    number_format ($sql_result["col_number"], 2, ".", "");
    // could I get 1455 instead of 1455.00?
?>

so my answer is if does exist some way to remove the decimals if I have DECIMAL data forma in my DB only when it's round?

Or shoud I do something like that?

<?php
    // $sql_result["col_number"] == 1,455.00
    str_replace(".00", "", (string)number_format ($sql_result["col_number"], 2, ".", ""));
    // will return 1455
?>

Here's a concise answer: stackoverflow.com/a/14531760/1431728 — JohnK
– JohnK, Commented Mar 1, 2014 at 1:20
@JohnK, I just realized that the link that you gave is also him that asked it last year. Hahaha — Brian Coolidge
– Brian Coolidge, Commented Jul 24, 2014 at 8:11

xDiff · Accepted Answer · 2014-10-30 07:39:22Z

53

floatval or simply casting to float

php > echo floatval(7.00);
7
php > echo floatval(2.30);
2.3
php > echo floatval(1.25);
1.25
php > echo floatval(1.125);
1.125

php > echo (float) 7.00;
7
php > echo (float) 2.30;
2.3
php > echo (float) 1.25;
1.25
php > echo (float) 1.125;
1.125

answered Oct 30, 2014 at 7:39

xDiff

7311 gold badge5 silver badges5 bronze badges

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

3 Comments

Daniel Faria Over a year ago

casting to float is so far the best option

Michael Khalili Over a year ago

Anyone who would want to apply this to a string should beware of values with commas like "1,000.99" Floating this value will return 1.

Michael Khalili Over a year ago

@YohanesAI I know. I'm warning people.

Emil H · Accepted Answer · 2010-11-06 13:08:56Z

23

I actually think that your workaround is as good as any. It's simple and clear, and there's really no point talking about performance here, so just go for it.

answered Nov 6, 2010 at 13:08

Emil H

40.3k11 gold badges81 silver badges97 bronze badges

3 Comments

Farzher Over a year ago

You can simply add 0 1455.00 + 0 stackoverflow.com/questions/14531679/…

Cesc Over a year ago

The replace workaround will break with numbers expressed in european countries format, like Germany or Spain. For example 9,000 in Germany is 9.000,00 and this will become something like 90,00

Ray Coder Over a year ago

How to change decimals and thousands separator? @Farzher

Halil Özgür · Accepted Answer · 2011-10-22 08:20:15Z

14

As Emil says yours are good. But if you want to remove 0 from e.g. 7.50 too, I've got a suggestion, rtrim():

<?php
    // if $sql_result["col_number"] == 1,455.50
    rtrim(rtrim(number_format($sql_result["col_number"], 2, ".", ""), '0'), '.');
    // will return 1455.5
?>

edited Oct 22, 2011 at 8:20

answered May 6, 2011 at 21:11

Halil Özgür

16k6 gold badges51 silver badges58 bronze badges

2 Comments

bobo Over a year ago

I think there will be a bug using rtrim in this situation, for example, rtrim('1230.00','0.'); will give 123 rather than 1230.

Ken Over a year ago

@bobo The bug does not exist with the code Halil gave here, that uses 2 rtrims executed in order.

Dan Leveille · Accepted Answer · 2016-10-23 05:05:12Z

10

You could also use rtrim(), which would remove excess 0s, in the case where you might want to keep one decimal place but not the excess zeros. (For example, 4.50 becomes 4.5.) Also allows you to change the number of decimal places from 2 to any other number.

rtrim(rtrim((string)number_format($value, 2, ".", ""),"0"),".");

// 4.00 -> 4
// 4.50 -> 4.5
// 4.54000000 -> 4.54 (if you're doing more decimal places)

answered Oct 23, 2016 at 5:05

Dan Leveille

3,2003 gold badges26 silver badges29 bronze badges

2 Comments

Hasenpriester Over a year ago

This is best way if you have other char for decimal separation.

anonymous007 Over a year ago

this seem to have trimmed numbers like 10400.00 to 104 for me

Tomas · Accepted Answer · 2012-09-10 02:24:21Z

5

Actually I think the cleanest way I can think of to do this for someone that just did a search looking for this sort of thing is to do this:

( number_format ($sql_result["col_number"], 2) * 100 ) / 100;

answered Sep 10, 2012 at 2:24

Tomas

3,2325 gold badges31 silver badges39 bronze badges

1 Comment

Felix Eve Over a year ago

I'm surprised this doesn't have more up votes as is the cleanest / most elegant solution to this problem IMHO.

Danial · Accepted Answer · 2019-02-25 02:34:52Z

2

I've been accused of doing something like this:

 floatval($foo) == intval($foo) ? number_format($foo) : number_format($foo,2);

answered Feb 25, 2019 at 2:34

Danial

1,62616 silver badges16 bronze badges

Comments

Kevin J · Accepted Answer · 2017-10-16 21:48:32Z

1

If you are targeting US currency I like to use this method:

function moneyform($number, $symbol = true) {
    return str_replace(".00", "", money_format(($symbol? '%.2n' : "%!n"), $number));
}

moneyform(1300999);
-->$1,300,999

moneyform(2500.99);
-->$2,500.99

moneyform(2500.99, false);
-->2,500.99

answered Oct 16, 2017 at 21:48

Kevin J

1942 silver badges11 bronze badges

1 Comment

jso Over a year ago

The only problem is that money_format is deprecated by now and will be removed in future.. ref. php.net/money_format

barbsan · Accepted Answer · 2019-09-06 13:15:53Z

1

Mine since most quantity or pieces do not require decimal, this function will only show decimal when needed.

str_replace(".00", "", number_format($this->pieces, 2));

edited Sep 6, 2019 at 13:15

barbsan

3,46811 gold badges23 silver badges29 bronze badges

answered Sep 6, 2019 at 12:52

Felix Labayen

4056 silver badges10 bronze badges

Comments

Sakushee · Accepted Answer · 2014-03-18 21:29:13Z

0

Warren.S answer helped me out. I didn't need the number_format function, so I just did this

$value=$value-0;

But in the OP's case, he needs number_format to remove the commas. So this would work for him

$value=number_format ($sql_result["col_number"], 2, ".", "")-0;

answered Mar 18, 2014 at 21:29

Sakushee

1

Comments

ThomasK · Accepted Answer · 2016-12-06 10:53:21Z

0

Since I could not find a flexible solution I wrote a simple function to get the best result:

function getValueFormattedWithMinimalDecimals($value, $max_decimals = 2, $dec_point = ',', $thousands_sep = '') {
    $bestNumberOfDecimals = -1;
    $decimal = 0;
    while ($decimal <= $max_decimals) {
        $bestNumberOfDecimals = $decimal;
        $valueDecimals = number_format($value, $decimal);
        if (floatval($value) == $valueDecimals) {
            break;
        }
        $decimal++;
    }
    if($bestNumberOfDecimals > 0 && number_format($value, $bestNumberOfDecimals) == number_format($value, 0)) {
        $bestNumberOfDecimals = 0;
    }

    return number_format($value, $bestNumberOfDecimals, $dec_point, $thousands_sep);
}

edited Dec 6, 2016 at 10:53

answered Dec 5, 2016 at 12:56

ThomasK

3055 silver badges11 bronze badges

Comments

Warren.S · Accepted Answer · 2014-03-17 03:15:07Z

-2

What about

number_format($value,2) - 0;

answered Mar 17, 2014 at 3:15

Warren.S

1621 silver badge5 bronze badges

Collectives™ on Stack Overflow

PHP number: decimal point visible only if needed

11 Answers 11

3 Comments

3 Comments

2 Comments

2 Comments

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

11 Answers 11

3 Comments

3 Comments

2 Comments

2 Comments

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related