How to automatically convert decimal into number not a string in php?

Question

How to make auto convert a decimal data type into number not a string in php?

I changed data field into decimal(4,2) from double. I have many checks like

if ($row->field)

And $row->field === 0.00. When it was double it's ok. But when I get decimal in php it's get string type and '0.00' it's TRUE.

"Add (float) before $row->field" are not my way, because I change many field and too many places where I use it.

I want find a better way, than change too many lines of code. Maybe some extensions or something else.

The example if($row->field) is always better coded as if($row->field != 0) or if($row->field > 0) if those are what is meant. — zanlok
– zanlok, Commented Nov 2, 2013 at 5:24
I know, but code was written and now I need to refactor this moment. — fr05t1k
– fr05t1k, Commented Nov 2, 2013 at 5:37

zanlok · Accepted Answer · 2013-11-02 05:27:15Z

1

Why not return a boolean expression from MySQL itself as part of your query?

SELECT decimal_column <> 0.00 as bool_expression FROM table;

Then test the expression like: if($row->bool_expression)

answered Nov 2, 2013 at 5:27

zanlok

1,6301 gold badge16 silver badges29 bronze badges

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

3 Comments

fr05t1k Over a year ago

Because I want find a better way, than change too many lines of code. Maybe some extensions or smth else.

zanlok Over a year ago

The mechanism presented in this answer will work if you test only (and use the old column name), but not if the value itself is used. Either way, the data layer change seems will necessitate refactoring.

fr05t1k Over a year ago

In my way, It using with active record and easier way to change code like if($row->field != 0) than change sql queries. However thanks for answer ;)

Collectives™ on Stack Overflow

How to automatically convert decimal into number not a string in php?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related