1#@!#!123s

32759 1#@!#!123s
: / home / aissorg / www /
Filename : list-of-poojas.php
back
<?php
include 'admin/include/config.php'; // Database connection
?>
<!DOCTYPE html>
<html class="wide wow-animation" lang="en">
    <head>
        <title>Pooja List</title>
        <meta name="format-detection" content="telephone=no">
        <meta name="viewport" content="width=device-width height=device-height initial-scale=1.0 maximum-scale=1.0 user-scalable=0">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta charset="utf-8">
		
		<meta name='og:title' content='All India Sai Samaj'>
		<meta name='og:type' content='Sai Baba Temple - Mylapore'>
		<meta name='og:url' content='https://aiss.org.in/'>
		<meta name='og:image' content='https://aiss.org.in/demo/img/favicon.png'>
		<meta name='og:site_name' content='All India Sai Samaj'>
		<meta name='og:description' content='In 1941 Sri Narasimhaswamiji created an organization named “All India Sai Samaj" in Chennai to serve as the center of activities of Sai Mission.  During his tour in various towns several people became his followers and with the guidance of Sri Swamiji they started Sai Samajams, which were called upasamajams affiliated to the main body All India Sai Samaj.'>
		<link rel='canonical' href='https://aiss.org.in/list-of-poojas.php' />
		
        <link rel="icon" href="img/favicon.png" type="image/x-icon">
       <link rel="preconnect" href="https://fonts.googleapis.com">
	<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
	<link href="https://fonts.googleapis.com/css2?family=Arimo:ital,wght@0,400..700;1,400..700&family=DM+Serif+Display&family=Noto+Serif:ital,wght@0,100..900;1,100..900&display=swap" rel="stylesheet">
        <link rel="stylesheet" href="css/bootstrap.css">
        <link rel="stylesheet" href="css/fonts.css">
        <link rel="stylesheet" href="css/style.css" id="main-styles-link">
        <link rel="stylesheet" href="css/about.css">
		<link rel="stylesheet" href="css/custom.css">
	<style>
        .table thead {
            background-color: #007bff;
            color: white;
        }
        .table-bordered th, .table-bordered td {
            border: 1px solid #dee2e6;
        }
		.table thead th {
			border-bottom: 1px solid #aeb1be;
			background-color: #900;
			color: #fff;
		}
    </style>
    </head>
    <body>
        <div class="page">
            <?php include('includes/header.php');?>
            <?php

            $sql = "SELECT image FROM inner_banner WHERE id = 9 LIMIT 1";
            $result = mysqli_query($con, $sql);
            
            $bannerImage = 'assets/img/gallery/about_banner.jpg'; // default fallback image
            if ($row = mysqli_fetch_assoc($result)) {
                $bannerImage = $row['image']; // e.g. 'img/custom_banner.jpg'
            }
            ?>
        <section class="breadcrumbs-custom bg-image context-dark" style="background-image: url('admin/assets/img/gallery/<?php echo ($bannerImage); ?>');">
                <div class="breadcrumbs-custom-inner">
                    <div class="container breadcrumbs-custom-container">
                        <div class="breadcrumbs-custom-main">
                            <h3 class="breadcrumbs-custom-title" style="color: #fff;">Pooja List</h3>
                        </div>
                        <ul class="breadcrumbs-custom-path">
                          <li><a href="./">Home</a></li>
                          <li class="active">Pooja List</li>
                        </ul>
                    </div>
                </div>
            </section>
           <section class="section section-xs text-center bg-image context-dark" style="background-image: url('images/call-to-action.jpg')">
                <div class="container">
                  <div class="row justify-content-center">
                    <div class="col-sm-10 col-md-12">
                      <div class="box-cta-thin">
                        <h4 class="wow-outer" style="color:#fff;"><span class="wow slideInRight">Join us in making a difference — Become a donor today!</h4>
                        <div class="wow-outer button-outer"><a class="button button-primary button-winona wow slideInLeft" href="donate-now.php">Donate Now</a></div>
                      </div>
                    </div>
                  </div>
                </div>
              </section>
			 <section class="section section-lg text-center">
				<div class="container">
				  <h3 class="wow-outer"><span class="wow slideInUp" style="visibility: visible; animation-name: slideInUp;">Current Pooja List</span></h3>
				  <p class="wow-outer"><span class="text-width-1 wow slideInDown" style="visibility: visible; animation-name: slideInDown;">Devotees offer flowers, shawls, sweets, and Dakshina (donations) as a token of gratitude..</span></p>
					<div class="table-responsive wow slideInUp" style="visibility: visible; animation-name: slideInUp;">
					<table class="table table-hover table-bordered">
						<thead>
							<tr>
								<th>ID</th>
								<th>Type</th>
								<th>Name</th>
								<th>Description</th>
								<th>Time</th>
								<th>Amount</th>
								<th>Prasadam</th>
								<th>Dharshan Entry</th>
								<th>Action</th>
							</tr>
						</thead>
						<tbody>
                            <?php
                            // Fetch All data
                            function fetchCategories($con) {
                            	$sql = "SELECT * 
                                FROM upcoming_pooja
                                WHERE date IS NULL OR date = '' OR date >= CURDATE();
                                ";
                            	$result = mysqli_query($con, $sql);
                            	$categories = [];
                            	while ($row = mysqli_fetch_assoc($result)) {
                            		$categories[] = $row;
                            	}
                            	return $categories;
                            }
                            
                            $categories = fetchCategories($con);
                            $count = 1;
                            
                            foreach ($categories as $category) {
                            	$poojaDate = $category['date'];
                            	$formattedDate = $poojaDate ? date('d-m-Y', strtotime($poojaDate)) : 'N/A';
                            
                            	echo "<tr>";
                            	echo "<td>" . $count++ . "</td>";
                            	echo "<td>" . htmlspecialchars($category['type']) . "</td>";
                            	echo "<td>" . htmlspecialchars($category['title']) . "</td>";
                            	echo "<td>" . htmlspecialchars($category['description']) . "</td>";
                            	echo "<td>" . ($poojaDate ? $formattedDate . ' ' . htmlspecialchars($category['time']) : htmlspecialchars($category['time'])) . "</td>";
                            	echo "<td>" . htmlspecialchars($category['amount']) . "</td>";
                            	echo "<td>" . htmlspecialchars($category['prashadham']) . "</td>";
                            	echo "<td>" . htmlspecialchars($category['dharshan_entry']) . "</td>";
                            	
                            	echo "<td><a href='pooja-online-reservation.php?id=" . $category['id'] . "' class='btn btn-primary'>Book Now</a></td>";
                            	echo "</tr>";
                            }
                            ?>
                            </tbody>


					</table>

					</div>
				</div>
				
			  </section>
		   
		   <?php include('includes/footer.php'); ?>     
        </div>
    <div class="snackbars" id="form-output-global"></div>
    <script src="js/core.min.js"></script>
    <script src="js/script.js"></script>
    </body>
</html>