[SOLVED] Displaying an array in a prepared statement

[skyer2000]

I'm working with prepared statements and need an array to be formatted in a certain way automatically.

 

Lets say I've got $testarray, with varying amounts of parameters.

 

I need to get this displayed as:

 

mysqli_stmt_bind_param($stmt, 'sssss', $testarray[1],$testarray[2],$testarray[3],$testarray[4],$testarray[5]);

 

How can I do this? The following will not work:

 

$foo = $testarray[1],$testarray[2],$testarray[3],$testarray[4],$testarray[5];

mysqli_stmt_bind_param($stmt, 'sssss', $foo);

 

Any ideas?

[Ken2k7]

$foo = $testarray[1],$testarray[2],$testarray[3],$testarray[4],$testarray[5];

Syntax error

[RussellReal]

I'm sure u can do something like:

$foo = '$testarray[1],$testarray[2],$testarray[3],$testarray[4],$testarray[5]';

eval('mysqli_stmt_bind_param($stmt, \'sssss\', '.$foo.')');

[hchsk]

i think ken meant to look up concatenating strings?

[Ken2k7]

RussellReal, using single quotes fail.

[RussellReal]

single quotes do not evaluate you mean, and yes I already know that.. my aim was to get it to be literal

 

xx,xx,xx,xx

 

since they are variables I did not want the variables evaluating.. then in the eval I evaluate the variable once, so that it places the string

 

$xx,$xx,$xx,$xx

 

inside the function, then the eval() will evaluate the function with the now in place variables

[skyer2000]

Unfortunately the eval() did not work, so I continued to look around and actually stumbled on the answer:

 

$types = str_repeat('s', count($bind_params));
array_unshift($bind_params, $types);
array_unshift($bind_params, $stmt);
call_user_func_array('mysqli_stmt_bind_param', $bind_params); 

 

(where $bind_params is the array of data)

 

Works great and is very flexible!