What is the best way to bind decimal / double / float values with PDO in PHP?

Question

It appears the class constants only cover PDO::PARAM_BOOL, PDO::PARAM_INT and PDO::PARAM_STR for binding. Do you just bind decimal / float / double values as strings or is there a better way to treat them?

MySQLi allows the 'd' type for double, it's surprising that PDO doesn't have an equivalent when it seems better in so many other ways.

score 13 · Accepted Answer · answered Aug 26 '09 at 14:39

13

AFAIK PDO::PARAM_STR is the way to go.

answered Aug 26 '09 at 14:39

Alix Axel

151,645
95
393
500

thanks! i'm probably just going to do this and validate myself. – Rob Aug 27 '09 at 08:53
3

For those who didn't know, the syntax is: `$sth->bindParam(':keyword', $keyword, PDO::PARAM_STR);` – tylerl May 10 '13 at 19:41

score 1 · Answer 2 · edited May 23 '17 at 12:10

1

You have to use PDO::PARAM_STR, but for SQLite and other engines this can have unpredictable behaviors. See this issue for one example: SQLite HAVING comparison error

edited May 23 '17 at 12:10

Community

1
1

answered Jun 29 '16 at 18:24

Dan Blaisdell

59
4

score -4 · Answer 3 · edited Oct 30 '13 at 11:12

-4

If you really want to use PDO you'll have to enter it as an PARAM_INT, but I never use a specification for double.

It is an optional parameter to specify the PDO type.

I guess you would better not set the PDO type for doubles.

edited Oct 30 '13 at 11:12

Ankur

2,171
23
29

answered Aug 26 '09 at 14:38

Kennethvr

2,660
5
26
35

I don't think I'd want to lose precision by binding it as an INT but you make a good point about just not specifying the type, thanks. – Rob Aug 26 '09 at 14:42
12

Actually, if no param_TYPE is given then PARAM_STR is assumed. – Xeoncross Dec 05 '09 at 19:24
You don't have and shouldn't bind it as integer or you will lose data! Read @AlixAxel answer instead. – PhoneixS Jun 25 '14 at 16:36

What is the best way to bind decimal / double / float values with PDO in PHP?

3 Answers3

Linked