You want to use wildcard characters when searching for records in a MySQL/MariaDB database using a PDO prepared statement. Which code should you use?

Advertisement

Here is the answer of the question: You want to use wildcard characters when searching for records in a MySQL/MariaDB database using a PDO prepared statement. Which code should you use?

  • $statement->bindValue(‘:name’, ‘%’ . $_GET[‘name’] . ‘%’);
  • $statement->bindValue(‘%’ . $_GET[‘name’] . ‘%’, ‘:name’);
  • $statement->bindParam(‘:name’, ‘%’ . $_GET[‘name’] . ‘%’);
  • $statement->bindParam(‘%’ . $_GET[‘name’] . ‘%’, ‘:name’);

The above question is related to “LinkedIn PHP Skill Quiz“. You can find all the updated questions and answers related to to “LinkedIn PHP Skill Quiz” on the “LinkedIn PHP Skill Quiz” page. If you find the update in question or answers, do comment on this page and let us know. We will update the answers as soon as possible.

Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Leave a Comment


Share via
Join our list

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Send this to a friend