results into array

[timmah1]

I'm trying to get info from my database into an event calendar, but I'm lost as to what I need to do here.

Can anybody help me out?

 

Thanks in advance

 

 

$sql = "SELECT * FROM events";
$result = $connection->query($sql);
 
while($row = $result->fetch_assoc()){
 
$events = array( 
 
         array(
'id' => $row['id'],
'title' => $row['event'],
'start' => $row['eventDate']
)
);
echo json_encode($events); 
}

?>

This currently shows results like this

[{"id":"1018","title":"Free Lunch Friday","start":"2016-01-29 12:30:00"}][{"id":"1020","title":"College Football Championship Game","start":"2016-01-11 00:00:00"}]

 

I want to be like this

    array(
        'id' => $row['id'],
        'title' => $row['event'],
        'start' => $row['eventDate']
    ),
    array(
        'id' => $row['id'],
        'title' => $row['event'],
        'start' => $row['eventDate']
    )

 

[Barand]

Do you mean

while($row = $result->fetch_assoc()){
 
  $events[] = array(
    'id' => $row['id'],
    'title' => $row['event'],
    'start' => $row['eventDate']
    );
}

[timmah1]

Thank you

simple things elude me most of the time