Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 带千分位和小数位的数据写入数据库的问题

带千分位和小数位的数据写入数据库的问题

WBOY
Release： 2016-06-23 13:26:19
Original
1442 people have browsed it

310
1,000.00
2,000


上面三个数据，写入数据库是310,1,2，有什么正确的方法写入数据库呢~


回复讨论(解决方案)

知道怎么做千分位的，没见过怎么取消千分位，number_format() 

$num = 千分位的数字;$num .= ''; //转为字符串$newnum = str_replace(',', '', $num);$newnum += 0; //转为数字
Copy after login

这种业务逻辑一般都是从数据库读取出来之后再加上千分符

str_replace()替换就可

如果是要强制四位小数的话就字段定义decimal(M,N)

Related labels：
带千分位和小数位的数据写入数据库的问题
source：php.cn
Previous article：php文件求解密及删除授权代码，谢谢 Next article：怎么获取只能在手机浏览器上打开的页面的源代码？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
From 2024-04-03 14:46:04
0
1
298
How to do conditional rendering in Vue I'm developing an app that can be used to create tasks and put them into lists to track th...
From 2024-04-01 19:36:54
0
1
329
MYSQL query to copy all data in a column from one database to another I accidentally used the "Generate Description" feature on the Opencart SEO tool ...
From 2024-04-01 00:00:37
0
1
375
Save post metadata for SQL query results when using "woocommerce_thankyou" hook I'm trying to query a database and pass the results to the update_post_meta function. But ...
From 2024-03-31 21:34:04
0
1
389
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template