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
exportUsersUnder25.php 0000644 00000005073 15233471246 0011001 0 ustar 00 prepare("SELECT result_users.shooterId, cpr, fullname, adress, birthday, email, allowPicture, subscriptionPaid, phone, ownWeapon, eventsLeft, memberDate, newShooter, result_class.class, skvNumber, date, `skv-id` FROM `result_users` LEFT JOIN `result_skv` ON result_users.id = result_skv.shooterId LEFT JOIN result_class ON result_users.class = result_class.id WHERE TIMESTAMPDIFF(YEAR, `birthday`, CURDATE()) < 25 AND `isDeleted` != 1");
$title = array("Skyttenummer", "cpr", "Navn", "Adress", "Fødselsdag", "E-mail", "allowPicture", "Subscription Paid", "Phone", "ownWeapon", "EventsLeft", "member Year", "newShooter", "class", "skvNumber", "date", "skv-id");
$stmt->execute();
$results = $stmt->fetchAll();
} catch (PDOException $e){
echo $e->getMessage();
}
$content = array();
$title = array("Skyttenummer", "cpr", "Navn", "Adress", "Fødselsdag", "E-mail", "Må tages billede af", "Betalt abodoment", "Telefonnummer", "Ejer våben", "Skydninger tilbage", "Indmeldelsesår", "Ny skytte", "Klasse", "SKV Nummer", "SKV dato", "skv-id");
foreach ($results as $rs) {
$row = array();
$row[] = stripslashes($rs["shooterId"]);
$row[] = decrypt(stripslashes($rs["cpr"]),$encryptKey);
$row[] = stripslashes($rs["fullname"]);
$row[] = stripslashes($rs["adress"]);
$row[] = date_format(date_create(stripslashes($rs["birthday"])), 'd-m-Y');
$row[] = stripslashes($rs["email"]);
$row[] = ($rs["allowPicture"] == "0") ? "Nej" : "Ja";
$row[] = ($rs["subscriptionPaid"] == "0") ? "Nej" : "Ja";
$row[] = stripslashes($rs["phone"]);
if(stripslashes($rs["ownWeapon"]) == 0){
$row[] = "Ejer ikke våben selv";
}
elseif (stripslashes($rs["ownWeapon"]) == 1){
$row[] = "Ejer gevær";
}
elseif (stripslashes($rs["ownWeapon"]) == 2){
$row[] = "Ejer pistol";
}
else{
$row[] = "Ejer gevær og pistol";
}
$row[] = stripslashes($rs["eventsLeft"]);
$row[] = stripslashes($rs["memberDate"]);
$row[] = stripslashes($rs["newShooter"]);
$row[] = stripslashes($rs["class"]);
$row[] = stripslashes($rs["skvNumber"]);
$row[] = stripslashes($rs["date"]);
$row[] = stripslashes($rs["skv-id"]);
$content[] = $row;
}
$output = fopen('php://output', 'w');
fputcsv($output, $title);
foreach ($content as $con) {
fputcsv($output, $con);
}
?> private/index.php 0000644 00000236704 15233471246 0010061 0 ustar 00 <\/script>\r\n