variable variables in parameter

Question

I want to bind a variable amount of results from a database.

$randomAmount = rand(0, 10);

for ($i = 1; $i <= $randomAmount; $i++) {
    mysqli_stmt_bind_result($databaseGet, ${'op'. $i});
}

It runs the mysqli_stmt_bind_result() function a random amount of times. What I want to achieve is the $randomAmount as variable in the parameter.

So, if $randomAmount = 4, the code should do something to achieve this:

mysqli_stmt_bind_result($databaseGet, $op1, $op2, $op3, $op4;

As per documentation, mysqli_stmt_bind_result binds variables to columns so it's not clear how it could be a variable number of columns. — max
– max, Commented Mar 21, 2016 at 10:57
I want to reuse this function. the query with amount of columns comes in as a variable. Something like this: $query = "select k1, k2, k3, k4 FROM table" $randomAmount = 4; — Jeroen de Beer
– Jeroen de Beer, Commented Mar 21, 2016 at 11:07

max · Accepted Answer · 2016-03-21 11:21:35Z

1

$vars = [$databaseGet]
for ($i = 1; $i < 6; $i++) {
    $vars[] = &${'op' . $i};
}

call-user-func-array('mysqli_stmt_bind_result', $vars);

answered Mar 21, 2016 at 11:21

max

2,81725 silver badges21 bronze badges

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

1 Answer 1