如何在oop中将数组作为参数传递给bind_param方法

Question

When I want to pass an array to bind_param method, I get an error like the following.

Warning: call_user_func_array() expects parameter 1 to be a valid callback, first array member is not a valid class name or object in C:\xampp\htdocs\mvc\libs\Database.php on line 26

Here is code:

class Database extends mysqli {

    function __construct($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME) {
        parent::__construct($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
    }

    function insert($table, $data){

        echo $table . '<br />';
        print_r($data);
        echo '<br />';        
        $param_types=$this->gettypes_bind_param($data, $keys, $values, $place_holder);
        $field_names= implode(', ', $keys);
        $inputArray[]=&$param_types;
        $j= count($values);
        for ($i=0;$i<$j;$i++)
        {
            $inputArray[]=&$values[$i];
        }

        print_r($inputArray); 
        echo '<br />';
        $result= $this->prepare("INSERT INTO $table ($field_names) VALUES ($place_holder)");
        call_user_func_array(array($result, 'bind_param'), $inputArray);
        $result->execute();
        die;
    }

    function gettypes_bind_param(&$data, &$keys, &$values, &$place_holder){
        $types='';
        foreach ($data as $tmp)
        {
            switch (gettype($tmp))
            {
                case "string" :
                    $types.='s';
                    break;
                case "integer" :
                    $types.='i';
                    break;                
                case "double" :
                    $types.='d';
                    break;                
                default :
                    $types.='b';
                    break;                
            }
            $place_holder .='?, ';
        }
        $place_holder= rtrim($place_holder, ', ');
        $keys = array_keys($data);
        $values = array_values($data);
        return $types;
    }

Sorry, for my English

Answer 1

You can use the Argument unpacking (...) operator...

$result->bind_param ($param_types, ...$values);

Note that you pass the types and values as separate items and don't have to join them as you would in call_user_func_array().