如何在数据库中正确插入浮点变量 [英] How to insert float variable in database properly

问题描述

我有下表

CREATE TABLE IF NOT EXISTS `payment_data` (
  `orderid` int(11) NOT NULL,
  `orderDesc` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `orderAmount` float NOT NULL,
  UNIQUE KEY `orderid` (`orderid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

我正在尝试使用 PHP 在其中插入一行.

and I'm trying to insert a line in it using PHP.

$sql = 'INSERT INTO payment_data '.
           '(orderid, orderDesc, name, email, orderAmount) '.
           'VALUES ( '.$form_order_id.', "'.$form_order_desc.'", "'.$form_name.'", "'.$form_email.'", '.number_format($form_order_amount, 2, '.', ',').' )';

问题是插入的orderAmount"没有小数部分.例如，如果 $form_order_amount=30,45 那么 30 就是插入到数据库中的内容.

The problem is that "orderAmount" is inserted without the decimal part. For example if $form_order_amount=30,45 then 30 is what's inserted in database.

我使用 number_format() 因为它应该将30,45"转换为30.45".

I used number_format() because it's supposed to convert "30,45" to "30.45".

推荐答案

先将 form_order_amount 转换为浮动，使用这个:

Convert form_order_amount to float first, using this:

$form_order_amount = floatval(str_replace(',', '.', $form_order_amount));

这篇关于如何在数据库中正确插入浮点变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！