Is the leading colon for parameter names passed to PDOStatement::bindParam() optional?

by

No, since the documentation doesn’t mention this I think it’s safe to assume that this behaviour isn’t officially supported and shouldn’t be relied upon.

However, it does actually happen to work (in PHP 5.3.24 at least) – internally a colon will be added to the parameter if it’s missing (see ext/pdo/pdo_stmt.c:363 in the PHP 5.3.24 source code).

More Related Contents:

  1. Why does this PDO statement silently fail?
  2. Cleansing User Passwords
  3. How can I use PDO to fetch a results array in PHP?
  4. What are the disadvantages of using persistent connection in PDO
  5. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  6. MySQL check if a table exists without throwing an exception
  7. Why is PDO better for escaping MySQL queries/querystrings than mysql_real_escape_string?
  8. PDO bindParam vs. execute
  9. how safe are PDO prepared statements
  10. PDO error message? [duplicate]
  11. PHP PDO – Num Rows
  12. How to solve General error: 2006 MySQL server has gone away
  13. Replacing mysql_* functions with PDO and prepared statements
  14. How do I sanitize input with PDO?
  15. Calling stored procedure with Out parameter using PDO
  16. When *not* to use prepared statements?
  17. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  18. Setting a connect timeout with PDO
  19. PDO MySQL: Insert multiple rows in one query
  20. How to bind LIKE values using the PDO extension?
  21. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  22. PDO LIMIT and OFFSET [duplicate]
  23. PHP 7 RC3: How to install missing MySQL PDO
  24. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. escaping column name with PDO
  27. prepared parameterized query with PDO
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PDO Exception Questions – How to Catch Them

Leave a Comment