Binding number to the LIMIT of a PDO query with PHP

Question

I am having an issue with PDO which I have seen discussed around but the different solutions provided did not work for me. It is when binding a number to set the LIMIT of a SQL query.

Here is the error I get:

Warning: PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2'' at line 1 in ...

The code:

$remaining = 3 - $countRows;
$con->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
$result4 = $con->prepare("SELECT  * FROM  item_descr WHERE id_item != ? LIMIT ?");
$result4->execute(array($itemId, intval($remaining)));

score 2 · Accepted Answer · edited May 23 '17 at 10:27

2

$dbh->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );

Adding this line and removing the intval( was the solution, as suggested here:

Answer to a similar question

edited May 23 '17 at 10:27

Community

1
1

answered Jun 18 '13 at 21:30

samyb8

2,560
10
40
68

score 0 · Answer 2 · answered Jun 18 '13 at 21:18

0

Why dont you do something like:

SELECT  * FROM  item_descr WHERE id_item != :id LIMIT :limit

$result->bindParam(':id', $itemID, PDO::PARAM_INT);
$result->bindParam(':limit', $remainint, PDO::PARAM_INT);

with your current code you are not really binding parameters.

answered Jun 18 '13 at 21:18

GGio

7,563
11
44
81

This does not work: Fatal error: Call to a member function bindParam() on a non-object in – samyb8 Jun 18 '13 at 21:24

Binding number to the LIMIT of a PDO query with PHP

2 Answers2