Arrays : MySQLi

[pradeepmamgain]

I am working on mysqli fetch array function. Some part of the code is like

while ($row = $res->fetch_assoc()) {
echo $row['userid'];
}

$row contains a single row. I want to make a big array out of it like $rows_all, how to combine all rows in single array.

[pradeepmamgain]

This method also not working, array contains only one record

                                  $i=0;
                                  $temp_arr=NULL;
                                  while ($row = $res->fetch_assoc()) {
                                         $i++;
                                         if ($i==1)
                                         {
                                             $temp_arr =$row;
                                         }else{
                                             //$temp_arr=array_merge($temp_arr, $row);
                                             $temp_arr=$temp_arr + $row;
                                         }
                                  }

Please help.

[pradeepmamgain]

Following is also not working

while ($row = $res->fetch_assoc()) {
if(!isset($temp_arr)) {
$temp_arr = $row;
} else {
$temp_arr = $temp_arr + $row;
}
}

OutPut : $temp_arr : First row in the array

And also

while ($row = $res->fetch_assoc()) {
if(!isset($temp_arr)) {
$temp_arr = array_merge($row);
} else {
$temp_arr = array_merge($temp_arr , $row);
}
}

OutPut : $temp_arr : Last row in the array

[pradeepmamgain]

Please help.