Set array in while use outside while

Question

I created a script where I set a array in an existing array through a while loop from a SQL database.

while ($nextday = odbc_fetch_array($nextdayinfo)){
$username = $nextday['user_sign'];
  if(isset($username)){
  $nextday[] = array('value' => $username, 'text' => $username);
  }
}

This is the code. If I try to print_r($nextday) after the IF clause, it will show me all the information, as soon as i put the print_r($nextday) after the while clause, it stops working.

What is $nextday? Array? Or result returned from _fetch? — u_mulder
– u_mulder, Commented Mar 23, 2017 at 12:52
$nextday is an empty array. I want to create it in the while clausule. — Wvs
– Wvs, Commented Mar 23, 2017 at 12:52
But your array has the same name as the database row, so it is overwritten on every iteration. — Jerodev
– Jerodev, Commented Mar 23, 2017 at 12:52

Jerodev · Accepted Answer · 2017-03-23 12:53:51Z

2

You are using the same variable for the fetched database row as your array. So the array is overwritten by the new row at every iteration.

Try defining your array outside of the loop and using a different name.

$array = [];
while ($nextday = odbc_fetch_array($nextdayinfo)) {
    $username = $nextday['user_sign'];
    if (isset($username)) {
        $array[] = [
            'value' => $username, 
            'text' => $username
        ];
    }
}

print_r($array);

answered Mar 23, 2017 at 12:53

Jerodev

33.3k11 gold badges96 silver badges114 bronze badges

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

Collectives™ on Stack Overflow

Set array in while use outside while

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related