<?php
include 'db.php';

$stmt = $conn->prepare("SELECT Nama_bengkel, Alamat, Email, No_hape, Gbr_bengkel FROM profil LIMIT 1");
$stmt->execute();
$stmt->bind_result($nama_bengkel, $alamat, $email, $no_hape, $logo);
$stmt->fetch();
$stmt->close();
$conn->close();
?>

<html>
<head>
<title><?= htmlspecialchars($nama_bengkel) ?></title>
</head>

<body>

<table border="0" cellspacing="0" cellpadding="0" width="100%" height="100%">
<tr>
<td bgcolor="#cc0000" align="center" valign="center">
    <font face="verdana" size="6" color="#ffffff">
        <?= htmlspecialchars($nama_bengkel) ?><br><br>
    </font>
    <font face="verdana" size="3" color="#ffffff">
        <?= htmlspecialchars($alamat) ?><br>
        <?= htmlspecialchars($email) ?><br>
        <?= htmlspecialchars($no_hape) ?><br><br>
    </font>
</td>
</tr>

<tr>
<td align="center" valign="center">
    <a href="login.php">
    <img src="gambar/<?= htmlspecialchars($logo) ?>" width="350">
    </a>
</td>
</tr>
</table>

</body>
</html>
