What's the point of using explicit data types in PDO::bindValue()?

bindvalue, mysql, pdo, php, placeholder

Solution

When you need something like

SELECT * FROM ... LIMIT :intValues

That avoids to enclose the value inside quote, rising a SQL syntax error

Problem

What's the point of using explicit data types in `PDO::bindValue()`? For example in either of the following forms there would be an `SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'a'` ``` $pdos->bindValue(':Value_For_An_Int_Col', 'a');//default arg for the third and opt par is PDO::PARAM_INT $pdos->bindValue(':Value_For_An_Int_Col', 'a', PDO::PARAM_INT); ```

Original source