php - How can I fetch all the rows of the data? -

i have code in php:

if (empty($_get)) {         $response['code'] = 1;         $response['status'] = $api_response_code[$response['code']]['http response'];         $sql = "select * table";         $result = $conn->query($sql);          if ($result->num_rows > 0) {             // output data of each row             while ($row = $result->fetch_assoc())                     $response['data'] = $row;         } else             $response['data'] = null; } 

currently, taking last row @ $response['data']. how transform code in order $row values?

i tried initializing $response['data'] = array(); , did $this->response['data'] = $row; didn't trick. please note begginer in php.

you overwriting $response['data'] each iteration of while fetch loop , not appending array. hence, last record 1 retained.

consider following adjustment $data own array hold row records of sql query resultset. entire array object can appended initial $response array (creating nested setup):

 $i = 0;  $data = [];  if ($result->num_rows > 0) {      // output data of each row      while ($row = $result->fetch_assoc()) {             $data[$i] = $row;             ...              $i++;      }  }   $response['data'] = $data;