WPDB Prepare(), update(), insert() refer to %d as a decimal

[dd32]

%d is refered to as a decimal in the inline docs for functions which use prepare().

%d is also refered to as a decimal in the PHP docs as well, however, %d represents the input as a Integer, not a Decimal, resulting in the loss of the fraction part of the number.

Mentioned by ​24/7 on wp-hackers

[nacin]

In return, we should probably add %f. I think there's another ticket for that.

[dd32]

In return, we should probably add %f. I think there's another ticket for that.

Sounds good to me, But I don't recall seeing, and can't find, another ticket referencing that.

[dd32]

In [18573]:

Clarify %d is an integer in wpdb documentation. See #18407

[dd32]

Still needs some extra testing for %f and adding to the docs if it's appropriate.

[dllh]

Display of some values tested with %f specifier

[dllh]

A little plugin that adds a Tools menu to test insertion of %f values

[dllh]

Patch to update wp-db.php docs

[dllh]

I've attached three files. One is a little plugin that makes it easy to test insertion of floats using the %f specifier. Another is graphic display of some values I tested (positive, negative, alphabetical, 0, and incorrect precision). The last is a patch that would update the phpdoc in wp-db.php should my testing prove of value.

[dd32]

In [18714]:

Add documentation for floats (%f) to wpdb::prepare() and friends. Props dllh. Fixes #18407