<?php
    include('header.php');
    $news_letter_class = "newsletter-area-2";
?>

<section class="page-banner">
    <div class="page-banner-bg bg_cover" style="background-image: url(assets/images/page-banner.jpg);">
        <div class="container">
            <div class="banner-content text-center">
                <h2 class="title">Contact</h2>
            </div>
        </div>
    </div>
</section>

<section class="mb-50">
    <div class="container">
        <div class="mt-50">
            <?php
            if(isset($_SESSION['error_msg']))
            {
              ?>
              <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <?php echo htmlspecialchars($_SESSION['error_msg']); ?>
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <?php
              unset($_SESSION['error_msg']);
            }
            ?>
            <?php
            if(isset($_SESSION['success_msg']))
            {
              ?>
              <div class="alert alert-success alert-dismissible fade show" role="alert">
                <?php echo htmlspecialchars($_SESSION['success_msg']); ?>
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                  <span aria-hidden="true">&times;</span>
                </button>
              </div>
              <?php
              unset($_SESSION['success_msg']);
            }
            ?>
        </div>
        <div class="row">
            <div class="col-md-5">
                <div class="single-contact-info mt-30">
                    <div class="info-icon">
                        <i class="fas fa-map-marker-alt"></i>
                    </div>
                    <div class="info-content">
                        <h5 class="title">Address</h5>
                        <p> PBA Central School, Bangalore Bye Pass Road, Taluk: Lingasugur, Dist: Raichur, Karnataka -584122</p></p>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-contact-info mt-30">
                    <div class="info-icon">
                        <i class="fas fa-phone"></i>
                    </div>
                    <div class="info-content">
                        <h5 class="title">Phone</h5>
                        <p><a href="tel:+08362208758">9480284484</a></p>
                       <!-- <p><a href="tel:+919945163848">9945163848 / 7259407160</a></p>-->
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="single-contact-info mt-30">
                    <div class="info-icon">
                     <i class="far fa-globe"></i>
                    </div>
                    <div class="info-content">
                        <h5 class="title">Web/email</h5>
                        <p><a href="pbacbse.org" target="_blank">pbacbse.org</a></p>
                        <p><a href="mailto:pbacentralschoolcbse@gmail.com">pbacentralschoolcbse@gmail.com</a></p>
                    </div>
                </div>
            </div>
        </div>
        <div class="mt-50">
            <div class="row justify-content-center">
                <div class="col-lg-12 mb-50">
                    
                    <iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3832.702874141841!2d76.53076167513726!3d16.132664084556044!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3bc80193deeb1d91%3A0x2e2fa0d9d6bb0e90!2sPBA%20CENTRAL%20SCHOOL%20CBSE!5e0!3m2!1sen!2sin!4v1747130321467!5m2!1sen!2sin" width="600" height="450" style="border:0;" allowfullscreen="" loading="lazy" referrerpolicy="no-referrer-when-downgrade"></iframe>
                    
                  
                </div>
            </div>
            <div class="row justify-content-center">
                <div class="col-lg-8">
                    <div class="contact-title text-center">
                        <h3 class="title">Leave a message here</h3>
                        <p>Here is our event schedule where you can get information about time schedule about this event so it's very easy for you to manage your time and schedule</p>
                    </div>
                </div>
            </div>
            <div class="row justify-content-center">
                <div class="col-lg-8">
                    <div class="contact-form-wrapper">
                        <form action="" method="POST">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="text" name="name" placeholder="Name" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="email" name="email" placeholder="Email" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="text" name="mobile_number" placeholder="Phone" required>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="single-form">
                                        <input type="text" name="subject" placeholder="Subject" required>
                                    </div>
                                </div>
                                <div class="col-md-12">
                                    <div class="single-form">
                                        <textarea name="message" placeholder="Write here..." required></textarea>
                                    </div>
                                </div>
                                <p class="form-message"></p>
                                <div class="col-md-12">
                                    <div class="single-form text-center">
                                        <button class="main-btn" name="btnSubmit" type="submit">Submit</button>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>

<?php
if(isset($_POST['btnSubmit']))
{
    // Sanitize input data
    $name = mysqli_real_escape_string($con, $_POST['name']);
    $email = mysqli_real_escape_string($con, $_POST['email']);
    $mobile_number = mysqli_real_escape_string($con, $_POST['mobile_number']);
    $subject = mysqli_real_escape_string($con, $_POST['subject']);
    $message = mysqli_real_escape_string($con, $_POST['message']);

    // Insert into database using prepared statement
    $stmt = $con->prepare("INSERT INTO `enquiry` (`name`, `email`, `mobile_number`, `subject`, `message`) VALUES (?, ?, ?, ?, ?)");
    $stmt->bind_param("sssss", $name, $email, $mobile_number, $subject, $message);
    
    if($stmt->execute())
    {
        $_SESSION['success_msg'] = 'Contact enquiry has been sent successfully!';
        header("Location: contact.php");
        exit();
    }
    else
    {
        $_SESSION['error_msg'] = 'Unable to send Contact enquiry. Please try again.';
        header("Location: contact.php");
        exit();
    }
    $stmt->close();
}
?>

<?php include('footer.php'); ?>