MySQLi Bind Param with an array for IN [duplicate]

by

It can but SHOULD NOT be done, as it is code that is hard to maintain (read, understand, debug, change).

A way to do it would use dynamic variables to provide auto-referencable variables and using call_user_func_array to supply a dynamic amount of arguments to the callback/method $stmt->bind_param().

<?php
$values = array('a','b','c','d');

$s = substr( str_repeat( ' , ?' , count( $values ) ) , 2 );
$stmt->prepare('SELECT value1, value2 FROM table1 WHERE value3 IN (' . $s . ')');
# OR array_map in case of different datatypes
$typeDefintions = str_repeat( 's' , count( $values ) );
$params = array( $typeDefinitions );
foreach ( $values as $k => $v ) {
    ${ 'varvar' . $k } = $v;
    $params[] = &${ 'varvar' . $k };# provide references
}
call_user_func_array( array( $stmt , 'bind_param' ) , $params );

More Related Contents:

  1. PHP create new array by value
  2. How to bind mysqli bind_param arguments dynamically in PHP?
  3. mysqli bind_param() expected to be a reference, value given
  4. How to fix Trying to access array offset on value of type null error
  5. Fatal error: Cannot use object of type mysqli_result [closed]
  6. Returning Multiple Rows with MySqli and Arrays
  7. Removing array of arrays for certain inner values in PHP
  8. PHP Mysqli query update not working with variable
  9. Can't echo items from array
  10. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  11. How to start and end transaction in mysqli?
  12. Replace keys in an array based on another lookup/mapping array
  13. php implode (101) with quotes
  14. Echo a multidimensional array in PHP
  15. Combinations, Dispositions and Permutations in PHP
  16. PHP foreach with Nested Array?
  17. Compare multidimensional arrays in PHP
  18. Selecting multiple array elements
  19. Sorting multidim array: prioritize if column contains substring, then order by a second column
  20. using nulls in a mysqli prepared statement
  21. PHP get both array value and array key
  22. store_result() and get_result() in mysql returns false
  23. Accessing JSON array after json_decode/multidimensional array
  24. Checking if mysqli_query returned any values?
  25. PHP: Create an array for a range
  26. Interleaving multiple arrays into a single array
  27. How to create multi-dimensional array from a list?
  28. Which is fastest in PHP- MySQL or MySQLi?
  29. Check to see if an email is already in the database using prepared statements
  30. Save array in mysql database

Leave a Comment