Файловый менеджер - Редактировать - /var/www/jonas-eriksen.dk/export/exportUsersUnder25.php
Назад
<?php include "../include.php"; $filename = "Eksport-skytter-U25-exports.csv"; header("Content-type: text/csv"); header("Content-Disposition: attachment; filename=$filename"); header("Pragma: no-cache"); header("Expires: 0"); try { $stmt = $db->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); } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка