Using LIKE in bindParam for a MySQL PDO Query [duplicate]

by

No, you don’t need the inner single quotes so just $term = "$term%";

The statement you’re running now would try to match 'a%' instead of a%

bindParam will make sure that all string data is automatically properly quoted when given to the SQL statement.

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDO get the last ID inserted
  3. PDO mysql: How to know if insert was successful
  4. MySQL check if a table exists without throwing an exception
  5. Fetching single row, single column with PDO
  6. Replacing mysql_* functions with PDO and prepared statements
  7. PDO::PARAM for type decimal?
  8. Gather column name of a table from database [closed]
  9. I am seeing this error on submitting form Error: query was empty [closed]
  10. How to convert the json image url string into Bitmap image to display images in android application
  11. Insert form in MySQL with PDO [duplicate]
  12. Undefined index $_POST
  13. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  14. How to use multiple databases in Laravel
  15. Getting raw SQL query string from PDO prepared statements
  16. How do I set ORDER BY params using prepared PDO statement?
  17. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  18. “Invalid parameter number: parameter was not defined” Inserting data
  19. How can I store and retrieve images from a MySQL database using PHP?
  20. Having issue with matching rows in the database using PDO
  21. How can I properly use a PDO object for a parameterized SELECT query
  22. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  23. Real escape string and PDO [duplicate]
  24. Mechanisms for tracking DB schema changes [closed]
  25. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  26. PDO Connection Test
  27. PHP PDO vs normal mysql_connect
  28. Can I create a database using PDO in PHP?
  29. PDO error: SQLSTATE[HY000]: General error: 2031
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment