Файловый менеджер - Редактировать - /home/gqdcvggs/.trash/more-info.php.3
Назад
<?php require_once 'db.php'; $titre = $_GET['titre'] ?? ''; if(empty($titre)) { header('Location: database-directory.php'); exit; } $stmt = $pdo->prepare("SELECT * FROM dossiers WHERE titre = ?"); $stmt->execute([$titre]); $dossier = $stmt->fetch(PDO::FETCH_ASSOC); if(!$dossier) { header('Location: database-directory.php'); exit; } $stmt_logs = $pdo->prepare("SELECT * FROM logs WHERE dossier_id = ? ORDER BY date_log DESC"); $stmt_logs->execute([$dossier['id']]); $logs = $stmt_logs->fetchAll(PDO::FETCH_ASSOC); $stmt_medias = $pdo->prepare("SELECT * FROM medias WHERE dossier_id = ?"); $stmt_medias->execute([$dossier['id']]); $medias = $stmt_medias->fetchAll(PDO::FETCH_ASSOC); ?> <!DOCTYPE html> <html lang="en-GB"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>The Lord Court - <?php echo htmlspecialchars($dossier['titre']); ?></title> <script src="https://cdn.tailwindcss.com"></script> <link href="https://fonts.googleapis.com/css2?family=Playfair+Display:wght@400;700&family=Inter:wght@300;400&display=swap" rel="stylesheet"> <style> .playfair { font-family: 'Playfair Display', serif; } .inter-light { font-family: 'Inter', sans-serif; font-weight: 300; } </style> </head> <body class="bg-white"> <header class="bg-white border-b border-black fixed top-0 left-0 right-0 z-50"> <div class="max-w-7xl mx-auto px-8 py-6 flex justify-between items-center"> <h1 class="playfair text-3xl text-black">THE LORD COURT</h1> <a href="database-directory.php" class="inter-light text-black hover:text-gray-600 transition-colors">← Back to cases</a> </div> </header> <main class="pt-24"> <section class="max-w-7xl mx-auto px-8 py-20"> <div class="max-w-4xl"> <h2 class="playfair text-5xl mb-6 text-black"><?php echo htmlspecialchars($dossier['titre']); ?></h2> <div class="inter-light text-lg text-gray-600 mb-12"> <div class="grid md:grid-cols-2 gap-8 mb-8"> <div> <p class="mb-2"><strong>Opening date:</strong> <?php echo date('d/m/Y', strtotime($dossier['date_ouverture'])); ?></p> <?php if($dossier['date_fermeture']): ?> <p class="mb-2"><strong>Closing date:</strong> <?php echo date('d/m/Y', strtotime($dossier['date_fermeture'])); ?></p> <?php endif; ?> </div> <div> <p class="mb-2"><strong>Affected sectors:</strong> <?php echo htmlspecialchars($dossier['secteurs']); ?></p> <p class="mb-2"><strong>Status:</strong> <?php echo htmlspecialchars($dossier['statut']); ?></p> </div> </div> <div class="mb-12"> <h3 class="playfair text-2xl mb-4 text-black">Case description</h3> <p class="leading-relaxed"><?php echo nl2br(htmlspecialchars($dossier['description'])); ?></p> </div> <?php if(!empty($medias)): ?> <div class="mb-12"> <h3 class="playfair text-2xl mb-6 text-black">Associated media</h3> <div class="grid md:grid-cols-2 lg:grid-cols-3 gap-4"> <?php foreach($medias as $media): ?> <div class="border border-black p-4"> <?php if(strpos($media['type'], 'image') !== false): ?> <img src="<?php echo htmlspecialchars($media['chemin']); ?>" alt="<?php echo htmlspecialchars($media['nom']); ?>" class="w-full h-40 object-cover mb-2"> <?php elseif(strpos($media['type'], 'video') !== false): ?> <video controls class="w-full h-40 mb-2"> <source src="<?php echo htmlspecialchars($media['chemin']); ?>" type="<?php echo htmlspecialchars($media['type']); ?>"> </video> <?php endif; ?> <p class="text-sm"><?php echo htmlspecialchars($media['nom']); ?></p> </div> <?php endforeach; ?> </div> </div> <?php endif; ?> <?php if(!empty($logs)): ?> <div class="mb-12"> <h3 class="playfair text-2xl mb-6 text-black">Case logs</h3> <div class="border border-black divide-y divide-gray-200"> <?php foreach($logs as $log): ?> <div class="p-6"> <div class="flex justify-between items-start mb-2"> <p class="text-sm text-gray-500"><?php echo date('d/m/Y H:i', strtotime($log['date_log'])); ?></p> <span class="px-2 py-1 bg-gray-100 text-xs"><?php echo htmlspecialchars($log['type']); ?></span> </div> <p><?php echo nl2br(htmlspecialchars($log['contenu'])); ?></p> </div> <?php endforeach; ?> </div> </div> <?php endif; ?> </div> </div> </section> </main> </body> </html>
| ver. 1.6 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка