duandeng2011 2014-11-14 11:08
浏览 450


This question already has an answer here:

I am trying to fetch the correct datatype from mysql with PDO on php. I have a Problem with float values. Even if the column in table is set to FLOAT(10,2), PDO isnt giving me back the correct number of decimals. Is this a PDO bug? I am using Apache/2.4.4 (Win32) OpenSSL/0.9.8y PHP/5.4.16 and mysqlnd 5.0.10. Is there any way to get back the correct result which is not something like round($var, 2)?

$sDbHost = 'someip';
$sDbUser = 'root';
$sDbPass = '';

$oPdo = new PDO("mysql:host={$sDbHost}", $sDbUser, $sDbPass);
$oPdoConn = $oPdo;
// make PDO use the datatype being returned from mysql
$oPdoConn->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
$oPdoConn->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

// create a table with a float of lenght 10 and TWO(!) decimalplaces
$oPdoConn->query("CREATE TABLE IF NOT EXISTS `paymentClass`.`floatTestTable3` (`testfield` float(10,2) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
$oPdoConn->query("INSERT INTO `paymentClass`.`floatTestTable3` VALUES (10.99);");

$oPdoFloatTest = $oPdoConn->query("SELECT * FROM `paymentClass`.`floatTestTable3`");


// result should be float 10.99

// but result is float 10.989999771118

  • 写回答

1条回答 默认 最新

  • doumu1951 2014-12-09 15:46

    Same problem as PHP PDO query returns inaccurate value for FLOAT fields

    The next time i will use DECIMAL instead of FLOAT.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥15 为什么apriori的运行时间会比fp growth的运行时间短呢
  • ¥15 帮我解决一下膳食平衡的线性规划模型的数据实例
  • ¥40 万年历缺少农历,需要和阳历同时显示
  • ¥250 雷电模拟器内存穿透、寻基址和特征码的教学
  • ¥200 比特币ord程序wallet_constructor.rs文件支持一次性铸造1000个代币,并将它们分配到40个UTXO上(每个UTXO上分配25个代币),并设置找零地址
  • ¥15 关于Java的学习问题
  • ¥15 如何使用chatgpt完成文本分类任务?
  • ¥15 已知速度v关于位置s的等式,怎么转化为已知位置求速度v的等式
  • ¥15 我有个餐饮系统,用wampserver把环境配置好了,但是后端的网页却进去,是为什么,能不能帮远程一下?
  • ¥15 R运行没有名称为"species"的插槽对于此对象类"SDMmodelCV"