Passing array as list of arguments to a non user defined function

Question

I am currently writing a very basic PHP api which uses MySql databases for authentication and logging user data. I use prepared statements to avoid MySql injection. I attempted to make a generic function to handle and execute prepared queries as follows:

function query_prepared($sql, $type){//$type here is the string containing the characters of the type of the data to bind - e.g. 'sss' for string, string, string
    $args = func_get_args();
    $param_args = array();
    for($i = 2; $i < count($args); $i++){
        $param_args[$i - 2] = $args[$i];
    }//the version of PHP I am using does not support variable length arguments so I have to store all of the arguments but the sql statement and parameter types in an array ($param_args)
    $con = connect();//connects to the database
    $statement = $con->prepare($sql);
    if(!$statement)
        error("Error while querying database. " . mysqli_error($con), ERR_QUERY_DB);
    $statement->bind_param($type, $param_args);//<-- My problem is here - the bind_param function is supposed to pass arguments like this, $statement->bind_param($type, $var0, $var1, $var2...) but I only have an array of $var0, $var1, $var2... so it attempts to convert my array to a string before passing it to the bind_param function.
    $statement->execute();
    $statement->bind_result($result);
    $rows = array();
    $i = 0;
    while($row = $result->fetch())
        $rows[$i++] = $row;
    $con->close();
    return $rows;
}

I have done some reading and found the call_user_func_array function but this obviously will not work in this instance.

Is there any way of passing my array ($param_args) as a variable length argument to the bind_params function.

Your array should be an associative like ':param' => 'value' — alanmm
– alanmm, Commented Oct 16, 2015 at 20:10
What do you mean by "obviously will not work in this instance"? — gen_Eric
– gen_Eric, Commented Oct 16, 2015 at 20:10
@AlanMachado: That only works with PDO. This is using MySQLi. — gen_Eric
– gen_Eric, Commented Oct 16, 2015 at 20:16

gen_Eric · Accepted Answer · 2015-10-16 20:23:14Z

1

You can use call_user_func_array here. In fact, that's the correct way to do this.

array_unshift($param_args, $type);  // <- Prepend $type to the array so it's passed too
// The 1st parameter is the callback.  It's array($object, 'method')
call_user_func_array(array($statement, 'bind_param'), $param_args);

NOTE: bind_param wants the args to be references, you'll have to tweak how you're setting $param_args:

for($i = 2; $i < count($args); $i++){
    $param_args[] =& $args[$i];
}

edited Oct 16, 2015 at 20:23

answered Oct 16, 2015 at 20:12

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Passing array as list of arguments to a non user defined function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related