How do I pass dynamic parameters in a preparedStatment?

I solved the problem by reordering the values, and calling the function bind_param through another function called cal_user_func_array as @rray spoke up there, I just could not understand it right, so I did different using the same function.

1st I separated the part that returned the values depending on the type, and put everything in a function called type :

function type($args = [], $bind = false){
    # Essa função retorna o codigo para o valor 
    # Se o $bind for igual a true, ela vai retornar os simbolos
    $type = $binds = "";    
    $i = 1;
    foreach($args as $valor){
        switch(gettype($valor)){
            case 'integer':
            $type .= 'i';
            break;
            case 'string';
            $type .= 's';
            break;
            default:
            $type .= 's';
            break;  
        }   
        $binds .= "?";
        if($i < count($args)){
            $binds .= ", ";     
        }
        $i++;
    }
    if($bind){
        return $binds;  
    }
    return $type;
}

It returns the value types. If the second argument is as true it returns the symbols for the query SQL .

var_dump(type(['nome'=>'Anel de Ouro','preco'=>1000]));

  

string (2) "yes"

var_dump(type(['nome'=>'Anel de Ouro','preco'=>1000], true));

  

string (4) "?,?"

2nd I tried the parameters, creating a new function parametros :

function parametros($args=[], $sec=false){
    # Essa função retorna os parametros já referenciados
    # Se a variavel $sec for igual a true, ela vai retornar  os campos separados por vírgulas   
    $type = type($args);    
    $parametro[] = &$type;
    foreach($args as $key=>$valor){
        $parametro[] =& $args[$key];    
    }   
    if($sec){
        $campos = implode(', ', array_keys($args)); 
        return $campos; 
    }
    return $parametro;
}

It returns different data, depending on the second argument too:

var_dump(parametros(['nome'=>'Anel de Ouro','preco'=>1000]));

  

array (3) {[0] = > string (2) "yes" [1] = > string (12) "Golden Ring" [2] = > int (1000)}

var_dump(parametros(['nome'=>'Anel de Ouro','preco'=>1000], true));

  

string (11) "name, price"

3rd I modified my original function by adding the function cal_user_func_array :

$mysqli = new mysqli('localhost','root','','loja_teste');

function insert($tabela, $args = []){
    global $mysqli;

    $campos = parametros($args, true); # aqui passo os nomes dos campos da tabela
    $binds = type($args, true); # aqui passo os simbolos (?) para a consulta

    $sql = "INSERT INTO {$tabela} ({$campos}) VALUES ({$binds})";
    if($prepare = $mysqli->prepare($sql)){
        if(call_user_func_array(array($prepare, "bind_param"), parametros($args))){
            if($prepare->execute()){
                print "Cadastrado com sucesso"; 
            }
        } else {
            die("Erro (execute): " . $mysqli->error);
        }
    } else {
        die("Erro: (prepare)" . $mysqli->error);    
    }


}

Then I ran this function using the same data:

var_dump(insert('tabela', ['nome'=>'Anel de Ouro','preco'=>1000]));

  

Successfully signed up

The function to identify the type of the field is only showing integer and string , I made some changes but I could not identify the blob , then I made a mooring in the condition string :

function type($args = [], $bind = false){
    # Essa função retorna o codigo para o valor 
    # Se o $bind for igual a true, ela vai retornar os simbolos
    $type = $binds = "";    
    $i = 1;
    foreach($args as $valor){
        switch(gettype($valor)){
            case 'integer':
                $type .= 'i';
                break;
            case 'double':
                $type .= 'd';
                break;
            case 'string':
                if (array_search($valor, $args) == 'fd_imagem') {
                    $type .= 'b';
                } else {
                    $type .= 's';
                }
                break;
            default:
                $type .= 's';
                break;  
        }   
        $binds .= "?";
        if($i < count($args)){
            $binds .= ", ";     
        }
        $i++;
    }
    if($bind){
        return $binds;  
    }
    return $type;
}