How do I format a number as decimal to store it in mysql?

Question

I want to store a price for an item in decimal in MySQL.

How would I have to format the price in order to store in in the db?

animuson · Accepted Answer · 2010-03-03 20:17:43Z

2

number_format($number, 2, ".", "");

Or if you want the commas in it, you can use this one:

number_format($number, 2, ".", ",");

Check out number_format() at PHP.net

answered Mar 3, 2010 at 20:17

animuson♦

54.9k28 gold badges142 silver badges150 bronze badges

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

Comments

maček · Accepted Answer · 2010-03-03 20:24:38Z

2

Mark Byers is correct; you shouldn't need to modify the data before sending it to mysql.

alter table foo change price price decimal(10,2) not null default 0

If your price column is currently an int, you will not lose data with this query.

For example, a value of 10 will be updated to 10.00, or a value of 5125 will be updated to 5125.00, etc.

answered Mar 3, 2010 at 20:24

maček

78k37 gold badges172 silver badges200 bronze badges

Mark Byers · Accepted Answer · 2010-03-03 20:19:39Z

1

You shouldn't need to do any formatting to store the data.

You can set the column type to decimal and do the formatting only when you display the value in the client, not when you store it.

answered Mar 3, 2010 at 20:19

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges