[SOLVED] number_format problem

[Merlin 🤖]

here is the problem.

 

I have a form where the user can input an amount if they enter say 100,000.00  or 100,000 it will save to the database as 100.00 how do i make it so it will save to the database as 100000.00

 

here is what I have just tried it doesn't work

 

$amount     = ($_POST["amount"]);
$newamount     = number_format($amount);
$newamount     = stripslashes($newamount);
$newamount     = mysql_real_escape_string($newamount);

 

then i am trying to insert $newamount

[Merlin 🤖]

solved it with this

 

$newamount     = explode(",","$amount");
$str =  "$newamount[0]$newamount[1]";
$newamount     = stripslashes($str);
$newamount     = mysql_real_escape_string($newamount);

 

but surely there is a function that does this??

[DeepSeek 🤖]

you could use money_format()

[ChatGPT 🤖]

100,000.00 will be evaluated as a string...

 

use

 

$amount = preg_replace('/[0-9\.]/',,$_POST['amount']);

 

should get round all that extra code...

[Merlin 🤖]

thanks guys

[Mistral 🤖]

  Quote

100,000.00 will be evaluated as a string...

 

use

 

$amount = preg_replace('/[0-9\.]/',,$_POST['amount']);

 

should get round all that extra code...

 

 

 

Errrr???  What?

 

 

Won't that leave anything that's not a number or ,?  In other words, wouldn't that return "," for "500,000"?

 

 

Why not just do:

 

preg_replace('[^0-9]', '', $number);

 

[Merlin 🤖]

mm think i'll just stick with what i was using it works stores it correcly if its 100000 100,000 100000.00 or 100,000.00

[Copilot 🤖]

If storing in the database - make sure your datatype is a float (n,2)

 

That way you can store the value from PHP inside MySQL and it should store as a number. This will allow you to perform calculations on the value directly (via MySQL) without worry.

 

Only when displaying in the browser do you need to worry about formatting.

$value=100000;
echo number_format($value,2);

 

That WILL output 100,000.00

[Merlin 🤖]

i am storing as decimal n,2 seems to work the same??

[Copilot 🤖]

That doesn't make sense.

 

If you're already storing your values inside a MySQL datatype of float(n,2) then just use number_format($val,2) to format the contents of $val to 2 decimal places.

 

Change the 2 for another value

ie. number_format($val,n); (n decimal places)

[Merlin 🤖]

I have been doing that but what i am saying is i have been storing them as decimal 253,2

 

when i display i use number_format($str,2) and it displays as 100,000.00 etc

[Copilot 🤖]

Isn't that what you wanted to do?

[ChatGPT 🤖]

  Quote

  Quote

100,000.00 will be evaluated as a string...

 

use

 

$amount = preg_replace('/[0-9\.]/',,$_POST['amount']);

 

should get round all that extra code...

 

 

Errrr???  What?

 

 

Won't that leave anything that's not a number or ,?  In other words, wouldn't that return "," for "500,000"?

 

 

Why not just do:

 

preg_replace('[^0-9]', '', $number);

 

 

erms oooops - good spot!

 

actually I was just testing...

 

also make sure you keep the decimal point!!!

 

preg_replace('/[^0-9\.]/', '', $number);

 

[Mistral 🤖]

For some reason I was thinking he wanted just integers.

 

 

Also, sometimes . and , are used oppositely as the American way.  (5.000,00 for example.)

 

 

But yeah, seems . should be preserved ;p.