Create new variable to store each result during While loop

Question

I have a while loop that loops through 3 results and echo's these out in a list. It will always be 3 results.

Here is my current PHP:

while($row = sqlsrv_fetch_array($res))
{

    echo "<li>".$row['SessionValue']."</li>";
    // prefer to store each value in its own variable

}

However I'd like to store the $row['SessionValue'] value in each loop in a new variable.

So....

first loop: $i0 = $row['SessionValue'];

second loop: $i1 = $row['SessionValue'];

third loop: $i2 = $row['SessionValue'];

How would I achieve this with PHP?

Many thanks for any pointers.

put it in an array.. btw, tell us what you're really trying to do (not how you're trying to do it) — Karoly Horvath
– Karoly Horvath, Commented Mar 29, 2012 at 8:43
Thanks Karoly. Sorry, that's a good point. I'll try to approach it in that way next time. Can you explain how I would do this using an array? — michaelmcgurk
– michaelmcgurk, Commented Mar 29, 2012 at 8:51

Stefan · Accepted Answer · 2012-03-29 08:53:41Z

1

$lst_count = array();
while($row = sqlsrv_fetch_array($res))
  $lst_count[] = $row["SessionValue"];

answered Mar 29, 2012 at 8:53

Stefan

3,8993 gold badges28 silver badges39 bronze badges

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

2 Comments

Stefan Over a year ago

You're welcome... (Karoly already suggested this before I finished my answer).

Stefan Over a year ago

Strictly speaking, Niko's answer - which creates 3 separate variables - is what you actually wanted.

Niko · Accepted Answer · 2012-03-29 08:50:35Z

1

You just need another variable that gets incremented:

$count = 0;
while($row = sqlsrv_fetch_array($res))
{
    ${i.$count++} = $row['SessionValue'];
}

edited Mar 29, 2012 at 8:50

answered Mar 29, 2012 at 8:45

Niko

26.8k9 gold badges97 silver badges112 bronze badges

5 Comments

michaelmcgurk Over a year ago

Hi Niko. I'm afraid this gives me no variables in the loop.

Niko Over a year ago

Put var_dump($i0); after the loop, it will output the first value!

michaelmcgurk Over a year ago

Thank you, Niko. Will try just now.

Niko Over a year ago

Though I would recommend using the solution with an array, that will turn out to be easier to handle.

michaelmcgurk Over a year ago

Your answer certainly answered my question, but you guys are right, there was a better way to do it. Thanks for your time and effort here sir.

Al Mobarmij · Accepted Answer · 2017-03-19 17:00:34Z

1

You can do this have SUM of all value:

$total = array();
while($row = sqlsrv_fetch_array($res))
{
   $total[] = $row["SessionValue"]
}  $sumAll = array_sum($total);

edited Mar 19, 2017 at 17:00

answered Mar 18, 2017 at 23:29

Al Mobarmij

366 bronze badges

Collectives™ on Stack Overflow

Create new variable to store each result during While loop

3 Answers 3

2 Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related