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';
//
global $pdo;
// 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
v.id,
v.name AS villa_name,
v.price,
v.persons,
v.description AS villa_description,
GROUP_CONCAT(DISTINCT l.name) AS location_names,
GROUP_CONCAT(DISTINCT e.name) AS feature_names
FROM villas v
LEFT JOIN villa_has_locations vl ON v.id = vl.villa_id
LEFT JOIN locations l ON vl.location_id = l.id
LEFT JOIN villa_has_eigenschappen ve ON v.id = ve.villa_id
LEFT JOIN eigenschappen e ON ve.eigenschappen_id = e.id
WHERE v.id = :villa_id -- Filter op een specifieke villa ID
GROUP BY v.id';
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':villa_id', $villa_id, PDO::PARAM_INT);
$stmt->execute();
$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_has_locations ON locations.id = villa_has_locations.location_id
WHERE villa_has_locations.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_path 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 isset($villa['image']) ? htmlspecialchars($villa['image']) : ''; ?>" alt="<?php echo isset($villa['villa_name']) ? htmlspecialchars($villa['villa_name']) : 'Villa'; ?>">
<h1><?php echo htmlspecialchars($villa['villa_name']); ?></h1>
<div class="villa-details-images">
<?php
foreach ($images as $image) {
echo '
<img class="detail-picture" src="' . htmlspecialchars($image) . '" alt="' . htmlspecialchars($villa['villa_name']) . '">
';
}
?>
</div>
<p>📍 Locatie: <?php echo htmlspecialchars($villa['villa_name']); ?></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['villa_description']); ?></p>
<p>Locaties: <?php echo htmlspecialchars($villa['location_names']); ?></p>
<p>Eigenschappen: <?php echo htmlspecialchars($villa['feature_names']); ?></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>