Use one bind_param() with variable number of input vars

by

You could use the call_user_func_array function to call the bind_param method with a variable number or arguments:

$paramNames = array('myvar1', 'myvar2', /* ... */);
$params = array();
foreach ($paramNames as $name) {
    if (isset($_POST[$name]) && $_POST[$name] != '') {
        $params[$name] = $_POST[$name];
    }
}
if (count($params)) {
    $query = 'UPDATE mytable SET ';
    foreach ($params as $name => $val) {
        $query .= $name.'=?,';
    }
    $query = substr($query, 0, -1);
    $query .= 'WHERE id = ?';
    $stmt = $mysqli->prepare($query);
    $params = array_merge(array(str_repeat('s', count($params))), array_values($params));
    call_user_func_array(array(&$stmt, 'bind_param'), $params);
}

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. How to change mysql to mysqli?
  4. Best way to INSERT many values in mysqli?
  5. Call to a member function bind_param() on a non-object [duplicate]
  6. MySQLi prepared statements error reporting [duplicate]
  7. How can I get an unknown username given an ID?
  8. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  9. mysqli_query() expects parameter 1 to be mysqli, object given
  10. How to call a MySQL stored procedure from within PHP code?
  11. MySQLi count(*) always returns 1
  12. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  13. Converting MySQL result array to JSON [duplicate]
  14. Fatal error: Cannot use object of type mysqli_result [closed]
  15. Do I have to guard against SQL injection if I used a dropdown?
  16. Inserting data to table (mysqli insert) [duplicate]
  17. Using MySQLi from another class in PHP
  18. How to echo a MySQLi prepared statement?
  19. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  20. MySQLi prepared statements with IN operator [duplicate]
  21. MySQLI binding params using call_user_func_array
  22. mysqli_select_db() expects parameter 1 to be mysqli, string given
  23. What does the mysqli_error() expects parameter 1 to be mysqli, null given mean?
  24. Mysqli prepared statement column with variable [duplicate]
  25. Unknown database error in PHP but it exists in PHPMyAdmin
  26. Can I blindly replace all mysql_ functions with mysqli_?
  27. Is mysqli_real_escape_string safe?
  28. Set character set using MySQLi
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment