revealability

Back Back Up Advanced Editor

<?php
session_start();
include '../../assets/constant/config.php';

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

if (isset($_POST['submit'])) {
        
       $email= trim(strtolower($_POST['email']));
       
       print_r($email);exit;
        $st = $conn->prepare("SELECT COUNT(*) FROM subscribe WHERE email = ?");
        $st->execute([$email]);
        $emailExists = $st->fetchColumn();

if ($emailExists > 0) {
           
            ?>
            <script>
                alert("This email is already subscribed!");
                 window.location.href = "../../../index.php"; // Redirect back to the previous page
            </script>
            <?php
        } else {
            // Insert the new email
            $stmt = $conn->prepare("INSERT INTO subscribe (email) VALUES (?)");
            $stmt->execute([$email]);

// Show success message
            ?>
            <script>
                alert("Thank you for subscribing!");
                window.location.href = "../../../index.php"; // Redirect to the specified page
            </script>
            <?php
        }
    }
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

<footer class="site-footer">
   <div class="upper-footer">
      <div class="container">
         <div class="row">
            <div class="col col-lg-3 col-md-3 col-sm-6">
               <div class="widget about-widget">
                  <div class="widget-title">
                     <h3>
                        <span>About us</span>
                     </h3>
                  </div>
                  <p class="">Bharatiya Open Volunteer Association (OVA) is a tech-driven NGO committed to fostering volunteerism and community empowerment through innovative solutions. </p>
                  <div class="social-icons">
                     <ul>
                        <li><a href="https://www.facebook.com/OpenVolunteerAssociation/" target="_blank"><i class="ti-facebook"></i></a></li>
                        <li><a href="https://www.twitter.com"  target="_blank"><i class="ti-twitter-alt"></i></a></li>
                        <li><a href="https://www.linkedin.com/company/bharatiya-open-volunteer-association"  target="_blank"><i class="ti-linkedin"></i></a></li>
                        <li><a href="https://www.youtube.com/@OVA2024"  target="_blank"><i class="ti-youtube"></i></a></li>
                          <li><a href="https://www.instagram.com/ovango2024"  target="_blank"><i class="ti-instagram"></i></a></li>
                     </ul>
                  </div>
               </div>
            </div>
            <div class="col col-lg-3 col-md-3 col-sm-6">
               <div class="widget contact-widget service-link-widget">
                  <div class="widget-title">
                     <h3>Contact</h3>
                  </div>
                  <ul>
                     <li><span>Address :</span> <?php echo $row['address'];?></li>
                     <li><span>Phone :</span><a href="tel:<?php echo $row['contact'];?>" class="text-white"> <?php echo $row['contact'];?></a></li>
                      <li><span>Email  :</span><a href="mailto:<?php echo $row['email'];?>" class="text-white"><?php echo $row['email'];?></a></li>
                  </ul>
               </div>
            </div>
            <div class="col col-lg-3 col-md-3 col-sm-6">
               <div class="widget link-widget">
                  <div class="widget-title">
                     <h3>Links</h3>
                  </div>
                  <ul>
                     <li><a href="./">Home</a></li>
                     <li><a href="about-us.php">About</a></li>
                     <li><a href="service.php">Service</a></li>
                     <li><a href="event.php">Event</a></li>
                  </ul>
                  <ul>
                     <li><a href="gallery.php">Gallery</a></li>
                     <li><a href="join.php">Join Member</a></li> 
                     <li><a href="contact.php">Contact</a></li>
                     <li><a href="team.php">Team</a></li>
                  </ul>
               </div>
            </div>
            <div class="col col-lg-3 col-md-3 col-sm-6">
                <div class="widget newsletter-widget">
                    <div class="widget-title">
                        <h3>Newsletter</h3>
                    </div>
                    <p>You will be notified when somthing new will be appear.</p>
                  <form method="post" action="panel/admin/app/subscribe.php">
    <div class="input-1">
        <input type="email" name="email" class="form-control" placeholder="Email Address *" required>
    </div>
    <input type="hidden" name="page" id="page" value="">
    <div class="submit clearfix">
        <button type="submit" name="submit"><i class="fi flaticon-paper-plane"></i></button>
    </div>
</form>

</div>
            </div>
         </div>
      </div>
      
   </div>
   <div class="lower-footer">
      <div class="container">
         <div class="row">
            <div class="separator"></div>
            <div class="col col-xs-12">
               <p class="copyright">Copyright &copy; <?php echo date('Y'); ?> Bharatiya Open Volunteer Association. All rights reserved</p>
               <div class="extra-link">
                  <ul>
                     <li><a href="terms-condition.php">terms and conditions</a></li>
                     <li><a href="privacy-policy.php">Privacy & Policy</a></li>
                     <li><a href="refund-policy.php">Refund Policy</a></li>
                  </ul>
               </div>
            </div>
         </div>
      </div>
   </div>
</footer>

</div>

<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<script src="assets/js/jquery-plugin-collection.js"></script>

<script src="assets/js/script.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.2.0/jquery.magnific-popup.min.js" integrity="sha512-fCRpXk4VumjVNtE0j+OyOqzPxF1eZwacU3kN3SsznRPWHgMTSSo7INc8aY03KQDBWztuMo5KjKzCFXI/a5rVYQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
 <script src="assets/js/security.js"></script> 
<script src="https://www.google.com/recaptcha/api.js" async defer></script>
<script>
    $('.bg-background-area').each(function() {
  "use strict";
  if ($(this).attr("data-bg")) {
    $(this).css({
      'background': 'url(' + $(this).data('bg') + ')',
      'background-position': 'center center',
      'background-repeat': 'no-repeat',
      'background-size': 'cover',
      'background-attachment': 'scroll'
    });
  }
});
</script>

// form.action = file + '/' + encodeURIComponent(sanitizedName);
      form.action = friendlyURL;
      form.method = 'post';

// Create hidden input fields for ID and Name
      var idInput = document.createElement('input');
      idInput.type = 'hidden';
      idInput.name = 'id';
      idInput.value = id;

var nameInput = document.createElement('input');
      nameInput.type = 'hidden';
      nameInput.name = 'name';
      nameInput.value = sanitizedName;

// Append the input fields to the form
      form.appendChild(idInput);
      form.appendChild(nameInput);

// Append the form to the body and submit it
      document.body.appendChild(form);
      form.submit();
   }
</script>

// Create a form dynamically
        var form = document.createElement('form');
        form.action = file;
        form.method = 'post';

// Create a hidden input field for the ID
        var input = document.createElement('input');
        input.type = 'hidden';
        input.name = 'id';
        input.value = id;

// Append the input field to the form
        form.appendChild(input);

// Append the form to the body and submit it
        document.body.appendChild(form);
        form.submit();
    }
</script>
</body>
</html>