Retrieve sql data and generate as json file

Question

I am trying to retrieve the data from mySQL and generate as JSON file.
But the output is just showing only 1 row.
There are many rows inside the database table.
What is wrong with this code?

$sql = "SELECT * FROM form_element";
$result = mysqli_query($conn, $sql);
$response = array();
$data_array = array();
if (mysqli_num_rows($result) > 0) {
   // output data of each row
   while($data = mysqli_fetch_assoc($result)) {
      $id = $data['id'];
      $name = $data['name'];
      $email = $data['email'];
      $phone = $data['phone'];
      $address = $data['address'];
      $data_array = array(
         'name' => $name, 
         'email' => $email, 
         'phone' => $phone, 
         'address' =>  $address
      );
   }
} else {
   echo "0 results";
}
$response['data_array'] = $data_array;
$fp = fopen('results.json', 'w');
fwrite($fp, json_encode($response));

Louys Patrice Bessette · Accepted Answer · 2017-09-14 03:07:16Z

3

You're overwriting $data_array every time in the loop.

So, this part:

$data_array = array(
  'name' => $name, 
  'email' => $email, 
  'phone' => $phone, 
  'address' =>  $address
);

should be changed to:

$data_array[] = array(
  'name' => $name, 
  'email' => $email, 
  'phone' => $phone, 
  'address' =>  $address
);

Then each row is added to the $data_array.

edited Sep 14, 2017 at 3:07

Louys Patrice Bessette

34k7 gold badges40 silver badges69 bronze badges

answered Sep 14, 2017 at 2:40

Duc Filan

7,2073 gold badges24 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Retrieve sql data and generate as json file

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