Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads
<?php
session_start();
require_once 'config.php';
include_once 'class/class.php';
require 'fpdf/fpdf.php';
//
// Controleer of een villa ID is doorgegeven in de URL
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
$villa_id = $_GET['id'];
// Haal de villa-gegevens op voor de gegeven ID
$sql = "
SELECT villas.*, GROUP_CONCAT(locations.name SEPARATOR ', ') AS liggingen
FROM villas
LEFT JOIN villa_location ON villas.id = villa_location.villa_id
LEFT JOIN locations ON villa_location.location_id = locations.id
WHERE villas.id = :id
GROUP BY villas.id";
$stmt = $pdo->prepare($sql);
$stmt->execute(['id' => $villa_id]);
$villa = $stmt->fetch();
// Controleer of de villa gevonden is
if (!$villa) {
echo "Villa niet gevonden.";
exit;
}
// Haal de liggingen van de specifieke villa op
$stmt = $pdo->prepare("
SELECT locations.name
FROM locations
INNER JOIN villa_location ON locations.id = villa_location.location_id
WHERE villa_location.villa_id = :villa_id
");
$stmt->execute(['villa_id' => $villa_id]);
$liggingen = $stmt->fetchAll(PDO::FETCH_COLUMN); // Haalt alleen de namen op
} else {
echo "Geen villa ID opgegeven.";
exit;
}
$stmtImages = $pdo->prepare('SELECT image FROM villa_images WHERE villa_id = :villa_id');
$stmtImages->execute(['villa_id' => $villa['id']]);
$images = $stmtImages->fetchAll(PDO::FETCH_COLUMN);
?>
<!DOCTYPE html>
<html lang="nl">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Villa Details</title>
<link rel="stylesheet" href="styles.css">
</head>
<body>
<div class="villa-details">
<img src="<?php echo htmlspecialchars($villa['image']); ?>" alt="<?php echo htmlspecialchars($villa['name']); ?>">
<h1><?php echo htmlspecialchars($villa['name']); ?></h1>
<div class="villa-details-images">
<?php
foreach ($images as $image) {
echo '
<img class="detail-picture" src="Images/' . htmlspecialchars($image) . '" alt="' . htmlspecialchars($villa['name']) . '">
';
}
?>
</div>
<p>📍 Locatie: <?php echo htmlspecialchars($villa['location']); ?></p>
<p>Prijs: €<?php echo number_format($villa['price'], 0, ',', '.'); ?></p>
<p>Capaciteit: <?php echo htmlspecialchars($villa['persons']); ?> personen</p>
<p>Beschrijving: <?php echo htmlspecialchars($villa['description']); ?></p>
<p>Liggingen: <?php echo htmlspecialchars($villa[6]); ?></p>
<p>Eigenschappen: <?php echo htmlspecialchars($villa[7]); ?></p>
<div class="huur-button">Huren</div>
<!-- Maak hier een button die verwijst naar de pdf bestand -->
<a href="villa_pdf.php?id=<?php echo $villa['id']; ?>" class="pdf-upload">Download PDF</a>
<div class="pdf-upload"><a href="aanbod.php">Terug naar ons aanbod</a></div>
</div>
</body>
<script src="script.js"></script>
</html>