Correct way to use LIKE ‘%{$var}%’ with prepared statements?

by

Try this

$likeVar = "%" . $yourParam . "%";
$stmt = $mysqli->prepare("SELECT * FROM REGISTRY where name LIKE ?");
$stmt->bind_param("s", $likeVar);
$stmt->execute();

you need to prepare the query using simply ? then you bind the param using bind_param.

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Commands out of sync; you can’t run this command now
  3. SELECT COUNT(*) AS count – How to use this count
  4. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  5. Using PHP data in MySQL [closed]
  6. Checking the availability of rooms
  7. How to properly set up a PDO connection
  8. How to display errors for my MySQLi query? [duplicate]
  9. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  10. How can I with mysqli make a query with LIKE and get all results?
  11. MySQL Prepared statements with a variable size variable list
  12. How can I enable the MySQLi extension in PHP 7?
  13. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  14. How can I use mysqli_fetch_array() twice?
  15. Advantages Of MySQLi over MySQL [closed]
  16. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  17. check if the query results empty row mysqli [duplicate]
  18. using nulls in a mysqli prepared statement
  19. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  20. How to prepare statement for update query? [duplicate]
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. Laravel Eloquent get results grouped by days
  23. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  24. Which is fastest in PHP- MySQL or MySQLi?
  25. mysqli persistent connection
  26. SELECT row by DATEPART()
  27. UNION syntax in Cakephp
  28. Create mysql trigger via PHP?
  29. How do i search from serialize field in mysql database?
  30. How to make mysqli connect function?

Leave a Comment