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

Solution 1:

AFAIK PDO::PARAM_STR is the way to go.

Solution 2:

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