I have a MySQL table with the following fields:
id | building | title | parent
Now, I am looking to implement a timeline calendar using fullcalendar.io.
This is the structure I aim to create:
{ id: '1', building: '460 Bryant', title: 'Auditorium D', children: [
{ id: '2', title: 'Room D1' },
{ id: '3', title: 'Room D2' }
] }, and so on...
To achieve this, I have written the following code snippet:
$query = "SELECT * FROM resources ORDER BY id";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
foreach($result as $row)
{
$data[] = array(
'id' => $row['id'],
'building' => $row['building'],
'title' => $row['title']
);
}
My question is, how can I modify this array to include an element called "children" that groups all elements with the same 'parent'? Any help would be greatly appreciated. Thank you!