How do I create a PDO parameterized query with a LIKE statement?

by

Figured it out right after I posted:

$query = $database->prepare('SELECT * FROM table WHERE column LIKE ?');
$query->execute(array('value%'));

while ($results = $query->fetch())
{
    echo $results['column'];
}

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. How to apply bindValue method in LIMIT clause?
  5. PDOException “could not find driver”
  6. Row count with PDO
  7. How to prevent duplicate usernames when people register?
  8. PDO valid characters for placeholders
  9. Binding multiple values in pdo
  10. PDO Parameterized Query – Reuse named placeholders?
  11. pdo prepared statements with wildcards
  12. Get last insert id after a prepared insert with PDO
  13. Insert multiple rows with PDO prepared statements
  14. Do SQL connections opened with PDO in PHP have to be closed
  15. What is the advantage of using try {} catch {} versus if {} else {}
  16. Alternative for mysql_num_rows using PDO
  17. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  18. Call to undefined method PDO::execute()
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. How do detect that transaction has already been started?
  21. return one value from database with mysql php pdo
  22. Trying to access array offset on value of type bool
  23. LIKE query using multiple keywords from search field using PDO prepared statement
  24. return multiple response data in one response
  25. How to get a query error from prepare() in PDO PHP?
  26. PDO lastInsertId() always return 0
  27. Do PHP PDO prepared statements need to be escaped?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. PHP PDO how to run a multiple query request?
  30. Difference between PDO->query() and PDO->exec()

Leave a Comment