<?php include '../db.php';

$id = $_GET['id'];
$stmt = $conn->prepare("SELECT h.*, c.name FROM hostings h JOIN clients c ON h.client_id = c.id WHERE h.id=?");
$stmt->execute([$id]);
$h = $stmt->fetch();
?>

<h2>Hosting Details</h2>
<p><strong>Client:</strong> <?= $h['name'] ?></p>
<p><strong>Plan:</strong> <?= $h['plan'] ?></p>
<p><strong>Provider:</strong> <?= $h['provider'] ?></p>
<p><strong>Start Date:</strong> <?= $h['start_date'] ?></p>
<p><strong>Expiry Date:</strong> <?= $h['expiry_date'] ?></p>
<p><strong>Status:</strong> <?= $h['status'] ?></p>
<p><strong>Price:</strong> ?<?= $h['price'] ?></p>

<button onclick="window.print()">Print</button>
