<?php
$host = 'localhost';
$user = 'ahmeuesz_dino';
$pwd = 'X39IW2ho3^5h6d_5';
$db = 'ahmeuesz_myapp';
$conn = mysqli_connect($host, $user, $pwd, $db);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $del = "DELETE FROM enter WHERE id = $id";
    mysqli_query($conn, $del);
    header('Location:' . $_SERVER['PHP_SELF']);
    exit();
}

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $name = $_POST['name'];
    $email = $_POST['email'];
    $contact = $_POST['contact'];

    $sql = "INSERT INTO enter (name, email, contact) VALUES ('$name', '$email', '$contact')";
    mysqli_query($conn, $sql);

    header('Location:' . $_SERVER['PHP_SELF']);
    exit();
}

$sel = 'SELECT * FROM enter';
$result = mysqli_query($conn, $sel);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>✨ Registration Form</title>
    <link rel="stylesheet" href="style.css">
    <link rel="stylesheet" href="youtube.css">
</head>
<body>
    <div class="container">
        <h2 class="page-title">🌸 Registration Form</h2>

        <form action="" method="post" class="reg-form">
            <div class="input-group">
                <label>Name</label>
                <input type="text" name="name" placeholder="Enter your name" required>
            </div>

            <div class="input-group">
                <label>Email</label>
                <input type="email" name="email" placeholder="Enter your email" required>
            </div>

            <div class="input-group">
                <label>Contact</label>
                <input type="number" name="contact" placeholder="Enter contact number" required>
            </div>

            <input type="submit" value="Submit" class="btn btn-submit">
        </form>

        <div class="table-wrap">
            <table class="data-table">
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>NAME</th>
                        <th>EMAIL</th>
                        <th>CONTACT</th>
                        <th>ACTION</th>
                    </tr>
                </thead>
                <tbody>
                    <?php while ($row = mysqli_fetch_array($result)) { ?>
                        <tr>
                            <td><?php echo $row['id']; ?></td>
                            <td><?php echo $row['name']; ?></td>
                            <td><?php echo $row['email']; ?></td>
                            <td><?php echo $row['contact']; ?></td>
                            <td>
                                <a href="?id=<?php echo $row['id']; ?>" class="btn btn-del">Delete</a>
                            </td>
                        </tr>
                    <?php } ?>
                </tbody>
            </table>
        </div>

        <div class="controls">
            <a href="showcode.php?file=delete.php" class="btn showcode-btn">💻 Show Code</a>
        </div>

        <?php include 'youtube.php'; ?>
    </div>
</body>
</html>
