insert format number in database MySQL

Question

I'm developing a Shopping Cart in PHP; after I have all my products, I have a $total.

If I have $ 14589.579 then I use number_format($total,2); to see $14,589.58.

But when I try to insert it into my database, I only see 14. The field on my database is type double.

This is my query:

"INSERT INTO cotizacion (
    idcotiza, idcli, idusuario, fechacotiza, pais, proyecto, notas, formapago, 
    tiempoentrega, flete, instalacion, venta, subtotal, descuento, total, 
    totalpesosmex, status, fecha2
) VALUES (
    NULL, '".$_SESSION['idcliente']."','".$_SESSION['idusuario']."', '".$fechatoday."',
   '".$pais."', '".$proyecto."', '".$notas."', '".$formapago."', '".$fechaentrega."',
   '".$flete."', '".$instalacion."', '".$venta."', NULL, NULL, '".$total."',
   '".$totalpesosmex."', 'Abierto', NULL
);"

Any idea about what I could do?

Alex M. · Accepted Answer · 2014-12-17 19:55:14Z

1

First, use DECIMAL to store money values.

Second, use REPLACE to remove the characters you dont want in a MySQL level.

edited Dec 17, 2014 at 19:55

answered Dec 17, 2014 at 19:42

Alex M.

6412 gold badges6 silver badges20 bronze badges

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

1 Comment

Veronica20_qro Over a year ago

It's the only way??... Or... Ammmmm... Is there a way to rollback the format?

Collectives™ on Stack Overflow

insert format number in database MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related