How to bind named parameters with PDO data-type

Asked Oct 02 '17 at 15:24

Active Oct 02 '17 at 15:24

Viewed 34 times

Im using PDO in PHP and I need to know how to bind my named parameters to a PDO data-type since PDO just reads my parameter as a string value in default when i need it to be an integer. This is my code

    $statement = self::connect()->prepare($query);
    $statement->execute(':limit'=>$limit, ':offset'=>$offset);

asked Oct 02 '17 at 15:24

Seto Sato

Does the string not function the same way? – GrumpyCrouton Oct 02 '17 at 15:26
3

Use http://php.net/manual/en/pdostatement.bindparam.php. – chris85 Oct 02 '17 at 15:27
offset and limit doesn't read strings – Seto Sato Oct 02 '17 at 15:27
https://stackoverflow.com/tags/pdo/info – deceze Oct 02 '17 at 15:31

How to bind named parameters with PDO data-type

0 Answers0