PDO: Invalid parameter number: mixed named and positional parameters

by

Change 

LIMIT :offset, :limit

to 

LIMIT ?, ?

and

$stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
$stmt->bindParam(':limit', $limit, PDO::PARAM_INT);

to:

$stmt->bindValue($index+1, $offset, PDO::PARAM_INT);
$stmt->bindValue($index+2, $limit, PDO::PARAM_INT);

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. Can PHP PDO Statements accept the table or column name as parameter?
  3. Can I bind an array to an IN() condition in a PDO query?
  4. PDOException “could not find driver”
  5. PDO get the last ID inserted
  6. How do I use password hashing with PDO to make my code more secure? [closed]
  7. How to view query error in PDO PHP
  8. How to get multiple parameters with same name from a URL in PHP
  9. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  10. Insert/update helper function using PDO
  11. Is the leading colon for parameter names passed to PDOStatement::bindParam() optional?
  12. PDO’s query vs execute
  13. Resetting array pointer in PDO results
  14. .htaccess RewriteRule to preserve GET URL parameters
  15. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  16. PDO::PARAM for type decimal?
  17. Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’ with pdo
  18. Is “SET CHARACTER SET utf8” necessary?
  19. Retrieve (or simulate) full query from PDO prepared statement
  20. Call to undefined method PDO::execute()
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. How do detect that transaction has already been started?
  23. Trying to access array offset on value of type bool
  24. LIKE query using multiple keywords from search field using PDO prepared statement
  25. return multiple response data in one response
  26. How to get a query error from prepare() in PDO PHP?
  27. PDO lastInsertId() always return 0
  28. Do PHP PDO prepared statements need to be escaped?
  29. PHP PDO how to run a multiple query request?
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment