Using mysql_results to create a variable name

Question

So I'm running a stored procedure that returns several rows, each row containing a PK counter and a phone number. I'm in need of a way to 'automate' the creation of variable names and assign those values to them. If I can't automate it, I at least need to create 3 different variables inside the while loop.

$rs = mysql_query("CALL GetUserNumbers('" . $_SESSION['UserID'] . "')");
    while ($row = mysql_fetch_assoc($rs))
    {
    $incrementingvariablename = row['phonenumber'];
    // something like $_1 = firstrow, $_2 = secondrow etc until all the rows have been read.
    }

Thanks in advance!

user557846 · Accepted Answer · 2011-08-28 19:41:56Z

4

arrays are good for this:

$incrementingvariablename[] = row['phonenumber'];

or

$incrementingvariablename[] = array('phone'=>row['phonenumber'],'counter'=>row['counter']);

answered Aug 28, 2011 at 19:41

user557846

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

Comments

petraszd · Accepted Answer · 2011-08-28 21:02:03Z

0

How about using this php feature:

$foo = 'bar';
$$foo = 'Hello I am bar';

echo $bar; // Outputs 'Hello I am bar';
echo "\n";

answered Aug 28, 2011 at 21:02

petraszd

4,3051 gold badge22 silver badges12 bronze badges

4 Comments

Álvaro González Over a year ago

This is just an extremely messy alternative to arrays.

petraszd Over a year ago

Yeah, but it is what question author asks: how to dynamically create variables.

Kulingar Over a year ago

This is useful to know. Thanks a bunch. I wonder if it would work for values pulled from a query result set? even so though, the array method seems much more feasible.

Álvaro González Over a year ago

In fact, the down vote is not fair: the answer is indeed correct given the question (but it was someone else who voted so). @Kulingar: result sets are by no means a special case; they come in variables as well.

Collectives™ on Stack Overflow

Using mysql_results to create a variable name

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related