I'm editing my array in a foreach, but when I return the values I get only one array as the result and not my 500 events.
Can someone explain why I can't get my 500 array's?
private function getEventsScroll($param = null)
{
$sql = $dbh->prepare('SELECT * FROM events WHERE date >= NOW() AND status = "0" ORDER BY `date` ASC');
$sql->execute();
$events = $sql->fetchAll(PDO::FETCH_ASSOC);
foreach ($events as &$event) {
$output = [
'name' => setHalveText(ucfirst($event['name']), 17),
'sub_text' => setHalveText($event['sub_text'], 45),
'datetime' => getDaytimeFormat($event['date'], 'Y-m-d\TH:i:s.u'),
'dayNumber' => getDaytimeFormat($event['date'], 'd'),
'monthName' => getDaytimeFormat($event['date'], 'F'),
'year' => getDaytimeFormat($event['date'], 'l'),
'time_start' => setTime($event['time_start']),
'time_end' => setTime($event['time_start']),
'url' => '../../event/' . setUuid($event['uid']) . ':'. getEventSlug($event['name']),
];
unset($event['name']);
unset($event['sub_text']);
unset($event['time_start']);
unset($event['time_end']);
$event = array_merge($event, $output);
return $event;
}
}