bind_param with dynamic # of variables

[raphael75]

I'm trying to write a variable number of arguments to a table. I was looking in the php documentation of bind_param and it mentioned using a ReflectionClass and invokeArgs to do it. I've been trying and I can't get it to work.

 

Say this is my array. The first argument is the types string:

 

$myarr =>

(

[0] = "sssssi"

[1] = "'test'"

[2] = "'ttt'"

[3] = "'tester'"

[4] = "'2015-01-01'"

[5] = "'test'"

[6] = 0

)

 

And here is the code:

 

 

$res = $mysqli->prepare($qry);
$ref = new ReflectionClass('mysqli_stmt');
$method = $ref->getMethod("bind_param");
$method->invokeArgs($res,$myarr);
$res->execute();

 

Please help me understand what I'm doing wrong. Thanks!

[kicken]

You can use call_user_func_array to execute it with a variable number of arguments.

 

[raphael75]

That worked, thank you!