MySQL Float(7,2) to PHP Float

Question

I am fetching (with PHP PDO) from MySQL a value (stored in signed Float(7,2) format).

Result
=====================
Database = 8.9 //correct value
PHP = 8.8999996185303 //fetch from PHP PDO

Sample code:

$qry = 'SELECT hours FROM sample WHERE filter=?;';
$stmt = $db->prepare($qry);
$stmt->execute(array($filter));
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo $row['hours'];
}

What is the best possible way to fetch this data from the DB? Ive read about the floating point approximalization issue in PHP. Thus I was thinking to perhaps change the SQL into something like:

SELECT (hours * 100) as butSoExpensiveOnDatabase etc...

Or using round or number_format in PHP. What would you guys suggest and why?

Changing the table structure is NOT an option!

(reason: old legacy code I need to support + no time + no budget)

chandresh_cool · Accepted Answer · 2013-05-15 12:50:15Z

2

You can do this

"SELECT round(hours, 2) FROM sample WHERE filter=?;"

answered May 15, 2013 at 12:50

chandresh_cool

11.9k3 gold badges32 silver badges46 bronze badges

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

2 Comments

Terence Over a year ago

this works, but isnt there a PHP solution, I dont like to let the mysql server make lots of calculations

hjpotter92 Over a year ago

@Terence Using mathematical functions in MySQL is better than having PHP do so.

Collectives™ on Stack Overflow

MySQL Float(7,2) to PHP Float

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related