Warning: Cannot modify header information - headers already sent by (output started at /var/www/jonas-eriksen.dk/pic/private/index.php:1) in /var/www/jonas-eriksen.dk/pic/private/index.php on line 215
prepare("SELECT `result_users`.`shooterId` , `fullname` , `result_weapon`.`name` , `date` FROM `result_event` JOIN `result_users` ON `result_event`.`shooterId` = `result_users`.`id` JOIN `result_weapon` ON `result_event`.`type` = `result_weapon`.id WHERE `year` <=2018");
$stmt->execute();
$results = $stmt->fetchAll();
} catch (PDOException $e){
echo $e->getMessage();
}
$content = array();
$title = array("Skyttenummer", "Navn", "Våben", "Dato");
foreach ($results as $rs) {
$row = array();
$row[] = stripslashes($rs["shooterId"]);
$row[] = stripslashes($rs["fullname"]);
$row[] = stripslashes($rs["name"]);
$row[] = stripslashes($rs["date"]);
$content[] = $row;
}
$output = fopen('php://output', 'w');
fputcsv($output, $title);
foreach ($content as $con) {
fputcsv($output, $con);
}
?>