Php multiple variables into one

Question

So Ive got a couple of statements using a list of variables and it seems i am always adding another column to the database so i wanted to make one list of variables and contain it somehow so i can just change it once if i need to instead of half a dozen times.

    $stmt = $mysql->prepare("SELECT * FROM table WHERE id =? LIMIT 1");

$stmt -> bind_param('i', $id);

$stmt->execute();

$stmt->bind_result($a, $b, $c, $d, $e, $f, $g);

$stmt->fetch();

$stmt->close();

But I want to make something like this:

    varList="$a, $b, $c, $d, $e, $f, $g";

    $stmt = $mysql->prepare("SELECT * FROM table WHERE id =? LIMIT 1");

$stmt -> bind_param('i', $id);

$stmt->execute();

$stmt->bind_result($varList);

$stmt->fetch();

$stmt->close();

have you checked if bind_result() also can accept an array? if so, use an array containing all of your vars — Kristian
– Kristian, Commented Apr 6, 2012 at 19:43
thanks Kristian, but i tried putting it in an array and bind doesnt seem to accept an array. I get the "doesnt match number of variables" error — killer on the road
– killer on the road, Commented Apr 6, 2012 at 19:45

Community · Accepted Answer · 2017-05-23 10:08:46Z

1

What you can do is make an array (of references to variables), and then use call_user_func_array to call bind_result.

Example:

$varList = array('a', 'b', 'c', 'd', 'e', 'f', 'g'); // variable names.
$params = array(); // list of params

foreach($varList as $v){
    $params[] = &$$v; // store a reference to the vars in $params
}

call_user_func_array(array($stmt, 'bind_result'), $params);

You may not need that foreach loop, you may also be able to do this:

$varList = array(&$a, &$b, &$c, &$d, &$e, &$f, &$g); // variable references

call_user_func_array(array($stmt, 'bind_result'), $varList);

Based off this answer: https://stackoverflow.com/a/966717/206403

edited May 23, 2017 at 10:08

CommunityBot

11 silver badge

answered Apr 6, 2012 at 19:58

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

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

Collectives™ on Stack Overflow

Php multiple variables into one

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related