<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $studentName = $_POST["studentName"];
    $std = $_POST["std"];
    $parentName = $_POST["parentName"];
    $numMembers = $_POST["numMembers"];
    $vehicleType = $_POST["vehicleType"];
    $parking = $_POST["parking"];
    $area = $_POST["area"];
    $day = $_POST["day"];

    $uniqueId = generateUniqueId();
 
    echo "<script>alert('Dear Carnival Participant, Thank you for registering! Your unique ID is: $uniqueId Please make sure to keep this ID handy and present it at the time of entry to ensure smooth access to the carnival. Your alotted parking is : $parking. We look forward to seeing you at the event! Best regards, CiS');</script>";

    $servername = "localhost";
    $username = "nifzdonk_user";
    $password = "s1w&afHHJnu3";
    $dbname = "nifzdonk_carnival";

    $conn = new mysqli($servername, $username, $password, $dbname);

    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    $sql = "INSERT INTO registrations (unique_id, student_name, std, parent_name, num_members, vehicle_type, parking, area, day)
            VALUES ('$uniqueId', '$studentName', '$std', '$parentName', '$numMembers', '$vehicleType', '$parking', '$area', '$day')";

    if ($conn->query($sql) === TRUE) {
        echo "Registration successful!";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

    $conn->close();
}

function generateUniqueId() {
    
    return rand(100000, 999999);
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Carnival Registration Form</title>
    <style>
        h3 {
            text-align: center;
        }
        body {
            font-family: Arial, sans-serif;
            margin: 20px;
        }
        form {
            max-width: 600px;
            margin: 0 auto;
        }
        label {
            display: block;
            margin-bottom: 8px;
        }
        input, select {
            width: 100%;
            padding: 8px;
            margin-bottom: 15px;
            box-sizing: border-box;
        }
        button {
            width: 100%;
            background-color: #4CAF50;
            color: white;
            padding: 10px 15px;
            border: none;
            border-radius: 92px;
            cursor: pointer;
        }

    </style>

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    
<!-- *************for parking************* -->
    <script>

    $(document).ready(function() {

    $("#area").on( "change", function(e) {

    var a = $("#area").val();
    if(a=='Jail Road' || a=='Konark Nagar' || a=='Park Side' || a=='Bali Maharaj Mandir' || a=='Dasak' || a=='Narayan Bapu Nagar'){
    //alert('this is bus');
    $("#parking").val('Parking 1');

    }
    else if(a=='Nashik Road' || a=='Dwarka' || a=='Ashoka Marg' || a=='Indira Nagar' || a=='Pathardi Phata' || a=='Mumbai Naka'){
    //alert('other');
    $("#parking").val('Parking 2');
    }

    });
    });

    </script>
<!-- *************for day************* -->

    <script>

    $(document).ready(function() {

     $("#std").on( "change", function(e) {

    var d = $("#std").val();
    if(d=='Second' || d=='Third' || d=='Fourth' || d=='Fifth'|| d=='Sixth' || d=='Seventh' || d=='Eighth'){
    $("#day").val('2');
    }
    else{
    $("#day").val('1');
            }
    });
    });

    </script>

</head>


<body>
    
    <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>">
        <img src="logo.jpeg" width="100%" height="230">
        <h3>Carnival Registration Form</h3>

        <label for="std">Standard/Class:</label>
        <select type="text" id="std" name="std" required>
            <option value="Nursery">Nursery</option>
            <option value="LKG">LKG</option>
            <option value="UKG">UKG</option>
            <option value="First">First</option>
            <option value="Second">Second</option>
            <option value="Third">Third</option>
            <option value="Fourth">Fourth</option>
            <option value="Fifth">Fifth</option>
            <option value="Sixth">Sixth</option>
            <option value="Seventh">Seventh</option>
            <option value="Eighth">Eighth</option>
        </select>

         <label for="day">Carnival Day :</label>
        <input id="day" name="day" required>
            <!-- <option value="Day 1">Day 1 - 20/01/2024</option>
            <option value="Day 2">Day 2 - 21/01/2024</option>
        </select> -->

       

        <label for="studentName">Student's Name:</label>
        <input type="text" id="studentName" name="studentName" required>
        


        <label for="parentName">Parent's Name:</label>
        <input type="text" id="parentName" name="parentName" required>

        <label for="numMembers">Number of Members Coming:</label>
        <input type="number" id="numMembers" name="numMembers" min="1" required>


        <label for="area">Select your nearby area:</label>
        <select id="area" name="area" required>
    
            <option value="Jail Road">Jail Road</option>
            <option value="Konark Nagar">Konark Nagar</option>
            <option value="Park Side">Park Side</option>
            <option value="Bali Maharaj Mandir">Bali Maharaj Mandir</option>
            <option value="Dasak">Dasak</option>
            <option value="Narayan Bapu Nagar">Narayan Bapu Nagar</option>
    
            <option value="Nashik Road">Nashik Road</option>
            <option value="Dwarka">Dwarka</option>
            <option value="Ashoka Marg">Ashoka Marg</option>
            <option value="Indira Nagar">Indira Nagar</option>
            <option value="Pathardi Phata">Pathardi Phata</option>
            <option value="Mumbai Naka">Mumbai Naka</option>
        </select>

        <label for="parking">Your Alloted parking is :</label>
        <input type="text" id="parking" name="parking">

        <label for="vehicleType">Type of Vehicle:</label>
        <select id="vehicleType" name="vehicleType" required>
            <option value="car">Car</option>
            <option value="bike">Bike</option>
            <option value="bus">Bus</option>
            <option value="other">Other</option>
        </select>

        <button type="submit">Submit</button>
    </form>
</body>
</html>
