在foreach中更改数组

Question

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;
    }
}

Answer 1

You have to do it like below (changes are commented):-

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']);

        array_merge($event, $output);

    }

    return $events; //return at last
}