number_format question

[speedy33417]

I have a form update page where I grab some number values from a db and display it in this format 1,251.05 using this code:

 

input name="amount" value="<?php echo number_format ($amount, 2); ?>" class="form4">

 

 

How do reverse it though? If the form is submitted and the value (1,251.05) is saved in the db (float) it will actually save 1 and it cuts off the rest of the numbers after the comma.

 

Is there a function to make 1,251.05 into 1251.05?

I tried number_format ($amount, 2, '.', '') but it doesn't work. Probably because $amount at this point already has the comma in it.

[cooldude832]

do this

 

strip all non numerical digits (regex or str_replace)

convert to a float

divide by 100

 

[Bauer418]

$amount = str_replace(',', '', $amount);

[alexloh]

Please consider to wrap the str_replace() into a function for code reuse purposes.

 

function stripcomma($amount) {

  return str_replace(',', '', $amount);

}

 

Details see code example at: http://www.thewebscripter.com/tutorial/code_examples/number_format.php

 

Hope this helps.

 

Alex.

[wildteen88]

Just use number_format again:

number_format ($amount, 2, '.', '')

The forth parameter is the thousands seperator.