How to bind mysqli bind_param arguments dynamically in PHP?

by

Using PHP 5.6 you can do this easy with help of unpacking operator(...$var) and use get_result() insted of bind_result()

public function get_result($sql,$types = null,$params = null) {
    $stmt = $this->mysqli->prepare($sql);
    $stmt->bind_param($types, ...$params);

    if(!$stmt->execute()) return false;
    return $stmt->get_result();

}

Example:

$mysqli = new database(DB_HOST,DB_USER,DB_PASS,DB_NAME);
$output = new search($mysqli);


$sql = "SELECT * FROM root_contacts_cfm WHERE root_contacts_cfm.cnt_id = ?
        AND root_contacts_cfm.cnt_firstname = ?
        ORDER BY cnt_id DESC";

$res = $output->get_result($sql, 'ss',array('1','Tk'));
while($row = res->fetch_assoc()){
   echo $row['fieldName'] .'<br>';
}

More Related Contents:

  1. PHP create new array by value
  2. Can I bind an array to an IN() condition in a PDO query?
  3. Call to a member function bind_param() on a non-object [duplicate]
  4. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  5. How to use mysqli prepared statements?
  6. MySQLi prepared statements error reporting [duplicate]
  7. Example of how to use bind_result vs get_result
  8. Call to a member function prepare() on a non-object PHP Help
  9. mysqli bind_param() expected to be a reference, value given
  10. mysqli: can it prepare multiple queries in one statement?
  11. How to fix Trying to access array offset on value of type null error
  12. Fatal error: Cannot use object of type mysqli_result [closed]
  13. using nulls in a mysqli prepared statement
  14. Returning Multiple Rows with MySqli and Arrays
  15. mySQLi prepared statement unable to get_result()
  16. MySQLi prepared statements with IN operator [duplicate]
  17. Is mysql_real_escape_string() necessary when using prepared statements?
  18. MySQLI binding params using call_user_func_array
  19. Bind Param with array of parameters
  20. store_result() and get_result() in mysql returns false
  21. Using wildcards in prepared statement – MySQLi
  22. bind_param Number of variables doesn’t match number of parameters in prepared statement
  23. Using wildcards in prepared statement
  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