How to convert data from table to json file?

Question

PHP

I need to get some data from a table and then convert the query to a .json file. For some reason, only the last line of the table is written to the file. Where did I go wrong?

<?php

$query = \R::getAll("SELECT YEAR(updated_at) AS year,MONTHNAME(updated_at) AS month,COUNT(*) AS cnt FROM tickets GROUP BY YEAR(updated_at), MONTHNAME(updated_at)"); // использую ORM Redbeanphp
$data = array();
foreach ($query as $item) {
    $data = [
            'Year' => $item['year'],
            'Month' => $item['month'],
            'Count' => $item['cnt']
    ];
}

$json_data = json_encode($data);
file_put_contents('your_json_file.json', $json_data);

Answer 1

How it is written is how it is recorded.

foreach ($query as $item) {
    $data[] = [
            'Year' => $item['year'],
            'Month' => $item['month'],
            'Count' => $item['cnt']
    ];
}