47 lines
1.2 KiB
PHP
47 lines
1.2 KiB
PHP
<!DOCTYPE html>
|
|
|
|
<!--
|
|
/*
|
|
* smzint/Files (c) schmamazon.com 2025
|
|
*/
|
|
-->
|
|
|
|
<html lang="en">
|
|
<?php
|
|
/*
|
|
* smzint/Files (c) schmamazon.com 2025
|
|
*/
|
|
|
|
|
|
include('../Auth/db.ini.php');
|
|
$fileId = filter_var($_GET['file'], FILTER_SANITIZE_NUMBER_INT);
|
|
|
|
$conn = new mysqli($dbservername, $dbusername, $dbpassword, $dbname);
|
|
if ($conn->connect_error) {
|
|
die("Connection failed: " . $conn->connect_error);
|
|
}
|
|
|
|
$sql = "SELECT name, description, type FROM smz_files_data WHERE id='$fileId'";
|
|
$result = $conn->query($sql);
|
|
$conn->close();
|
|
if ($result->num_rows > 0) {
|
|
while ($row = $result->fetch_assoc()) {
|
|
$fileName = $row["name"];
|
|
$fileDesc = $row["description"];
|
|
$fileType = $row["type"];
|
|
}
|
|
} else {
|
|
echo "Datei nicht in der Datenbank gefunden.";
|
|
}
|
|
?>
|
|
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<title>smzint/Files</title>
|
|
</head>
|
|
<body>
|
|
<?php
|
|
echo "<h1>$fileName<sup>$fileType</sup></h1><p>$fileDesc</p><br><form action='download.php' method='POST' target='_blank'><input type='hidden' name='file' value='$fileId'><input type='submit' value='Herunterladen'></form>";
|
|
?>
|
|
</body>
|
|
</html>
|