decimal value gets saved as floored down value

jfontein

Hi,

I have a variable $cost that holds a 2 decimal value (eg 1.75).

When I update the database it is saved as the floored down value of $cost > 1.00

$q6 = "UPDATE {$tbl_planning} SET cost='{$cost}' WHERE code='{$_SESSION['code']}'";

The type of cost in mysql is decimal(10,2).

Any clue??

jfontein

In the headers of the doc I: setlocale(LC_ALL, 'nl_NL');

When I print $cost'; I get 1,75 (with a comma)
When I print $tbl_planning['cost']; after updating $cost to the table I get 1.00 (with a dot).

When I calculate $total = $tbl_planning['cost'] + $tbl_planning['open_debt']
and then print $total; I get 2.99 (if debt was 1.99)

So I suppose it might have something to do with that comma ...

Joost

tsinka

Hi,

use str_replace to replace the , by . in $cost.

Thomas

jfontein

But i defined cost as:

$cost = 1.75;

So it is not defined as a string (I suppose) and it doesn't have a ",".

And actually I am normally not printing $cost, I just printed it to check what it would give me... so it doesn't matter to me how $cost is printed.

Any other clues???

jfontein

OK, I tried the str_replace.

It works, but it isn't particulary nice ....

So I understand the following:

I:
While I program in PHP
- $cost = 1.75;
- or I calculate something in PHP using $cost from the PHP code and $row['variable'] retrieved from the mysql database
=> it always gets printed using a "," for the decimal separator

II:
When I retrieve a value straight from the mysql database and print it direcly (without performing any calculation).
=> it always gets printed using a "." for the decimal separator

III:
When I want to save a variable (type decimal, eg $cost = 1.75😉 'defined' in PHP I need to replace the "," (that is somehow created by PHP) by "." to be able to update it into the mysql database.

?? Is there an easy way that all values get printed the same (without specifying it for each print)??

?? Is there a way I don't have to use "str_replace" before every update query ??

Thanx in advance for a nice solution....

Joost