Silex CSV generator

controller.php

$app->match('/export', function() use($app) {
 
    $records = $app['db']->fetchAll("SELECT * FROM formdata");
    
    $file = "/tmp/formdata.csv";

    $output = fopen($file, "w");
    fputcsv($output, array('name','surname','province'), ',');
    foreach ($records as $row)
        fputcsv($output, $row, ',');
    fclose($output);

    return $app->sendFile($file,200, array('Content-type' => 'text/csv'));
        
})
;