MySQLi prepared statements with IN operator [duplicate]

by

I’ve recently found the solution for my question. Maybe it’s not the best way to do it, but it works nice! Prove me wrong:)

<?php
$lastnames = array('braun', 'piorkowski', 'mason', 'nash');
$arParams = array();

foreach($lastnames as $key => $value) //recreate an array with parameters explicitly passing every parameter by reference
    $arParams[] = &$lastnames[$key];

$count_params = count($arParams);

$int = str_repeat('i',$count_params); //add type for each variable (i,d,s,b); you can also determine type of the variable automatically (is_int, is_float, is_string) in loop, but i don't need it
array_unshift($arParams,$int); 

$q = array_fill(0,$count_params,'?'); //form string of question marks for statement
$params = implode(',',$q);

$data_res = $_DB->prepare('SELECT `id`, `name`, `age` FROM `users` WHERE `lastname` IN ('.$params.')');
call_user_func_array(array($data_res, 'bind_param'), $arParams);
$data_res->execute();
$result = $data_res->get_result();
while ($data = $result->fetch_array(MYSQLI_ASSOC)) {
    ...
}

$result->free();
$data_res->close();
?>

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Use an array in a mysqli prepared statement: `WHERE .. IN(..)` query [duplicate]
  3. How can I with mysqli make a query with LIKE and get all results?
  4. Call to a member function bind_param() on a non-object [duplicate]
  5. How to use mysqli prepared statements?
  6. MySQLi prepared statements error reporting [duplicate]
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Example of how to use bind_result vs get_result
  9. How to bind mysqli bind_param arguments dynamically in PHP?
  10. Call to a member function prepare() on a non-object PHP Help
  11. MySQL Prepared statements with a variable size variable list
  12. mysqli: can it prepare multiple queries in one statement?
  13. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  14. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  15. PHP UPDATE prepared statement
  16. using nulls in a mysqli prepared statement
  17. mySQLi prepared statement unable to get_result()
  18. Is mysql_real_escape_string() necessary when using prepared statements?
  19. How to avoid code repetition with PHP SQL prepared statements?
  20. Using fetch_assoc on prepared statements
  21. store_result() and get_result() in mysql returns false
  22. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  23. How to prepare statement for update query? [duplicate]
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. How to run the bind_param() statement in PHP?
  26. Is using prepared statements necessary? [duplicate]
  27. Using Prepared Statement, how I return the id of the inserted row?
  28. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]
  29. Dynamically bind mysqli_stmt parameters and then bind result
  30. Check to see if an email is already in the database using prepared statements

Leave a Comment