1#@!#!123s

: / home / realadss / jaipurpartyplanner.in /
Filename : index.php
back
<?php include('admin/connection.php');
    $data_homepage = mysqli_query($conn,"select * from home_page");
    $row_homepage =mysqli_fetch_array($data_homepage); 
?>

<!DOCTYPE html>
<html lang="en">

    <head>
        <meta charset="utf-8">
        <?php echo $row_homepage['seo_content'] ?? ""; ?>
        
         <?php include 'include/links.php'; ?>

        <?php include 'include/header.php'; ?>

            <!-- Carousel Start -->
            <div class="header-carousel owl-carousel">
                <?php 
                    $bannersql =  "SELECT * FROM `banner`";
                    $bannerfetch = mysqli_query($conn, $bannersql);
                 while($row_banner = mysqli_fetch_array($bannerfetch)){
                ?>
                <div class="header-carousel-item">
                    <img src="admin/<?php echo $row_banner['image']; ?>"  class="img-fluid w-100" alt="<?php echo $row_banner['image_alt']; ?>" title="<?php echo $row_banner['image_title']; ?>">
                 </div>
            <?php } ?>
            </div>
            <!-- Carousel End -->
        </div>
        <!-- Navbar & Hero End -->

<div class="pt-4 home-featured-category">
        <div class="container-fluid">
            <div class="row">
                
                <?php 
                    $sql_cate = "SELECT * FROM `decore_category`";
                    $query_cate = mysqli_query($conn, $sql_cate);
                    
                    while($row_cate = mysqli_fetch_array($query_cate)){
                ?>
                    <div class="col-md-3 col-12 mb-4">
                        <div class="featured-category-box">
                            <a href="decor-theme/<?php echo $row_cate['slug']?>"><img style="width:100%" src="<?php echo "$base_url"."admin/".$row_cate['image'];?>" class="img-fluid" width="400" height="250" alt="<?php echo $row_cate['categoryName'];?>" title="<?php echo $row_cate['categoryName'];?>"></a>
                            <h6><a href="decor-theme/<?php echo $row_cate['slug']?>" style="color:#fff;"><?php echo $row_cate['categoryName'];?></a></h6>
                        </div>
                    </div>
                <?php 
                    }
                ?>
               
            </div>
        </div>
    </div>

    <!-- About Start -->
        <div class="container-fluid about bg-light py-5">
            <div class="container ">
                <div class="row g-5 ">
                    <?php $data = mysqli_query($conn,"select * from about");
                            $row =mysqli_fetch_array($data); 
                            ?>
                    <div class="col-lg-5 wow fadeInLeft" data-wow-delay="0.2s">
                        <div class="about-img pb-5 ps-5">
                            <img src="admin/<?php echo $row['image']; ?>" class="img-fluid rounded w-100" style="object-fit: cover;" alt="<?php echo $row['headline']; ?>" title="<?php echo $row['headline']; ?>">
                            
                            <div class="about-img-inner">
                                <img src="admin/<?php echo $row['image2']; ?>" class="img-fluid rounded-circle w-100 h-100" alt="Image">
                            </div>
                            <div class="about-experience"> <?php echo $row['experience']; ?></div>
                        </div>
                    </div>
                    <div class="col-lg-7 wow fadeInRight" data-wow-delay="0.4s">
                        <div class="section-title text-start mb-5">
                            <h4 class="sub-title pe-3 mb-0">About Us</h4>
                            <h1 class=" mb-4 mt-3"><?php echo $row['headline']; ?></h1>
                            <p class="mb-4 home-about-limit"><?php echo $row['details']; ?></p>
                                
                            <a href="about-us" class="btn btn-primary rounded-pill text-white py-3 px-5">Know More</a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- About End -->

    <!-- Services Start -->
        <div class="container-fluid service py-5">
            <?php 
                $sql_cate_data = "SELECT * FROM `decore_category`";
                $sql_cate_query = mysqli_query($conn, $sql_cate_data);
                while($row_cate_data = mysqli_fetch_array($sql_cate_query)){
            ?>
            
            <div class="container-fluid mb-3">
                <div class="row align-items-center">
                    <div class="col-6">
                        <h3 style="float:left; text-transform: capitalize;"><?= $row_cate_data['categoryName']?></h3>
                    </div>
                    
                     <div class="col-6">
                        <a href="decor-theme/<?php  echo $row_cate_data['slug']?>" class="sea-more">See More</a>
                    </div>
                </div>
                <div class="row ">
                    
                    <?php 
                        $sql_cet_pro = "SELECT * FROM `product` WHERE Category = '".$row_cate_data['id']."'";
                        $query_cet_pro = mysqli_query($conn, $sql_cet_pro);
                        while($row_cet_pro = mysqli_fetch_array($query_cet_pro)){
                    ?>
                    
                            <div class="col-md-3 col-12 mb-4">
                                <div class="card bg-light shadow product-grid-box">
                                    <div class="product-grid-image"> 
                                        <a href="decor/<?php echo $row_cet_pro['slug']?>"><img src="<?= "$base_url"."admin/".$row_cet_pro['image']?>" width="555" height="420" class="img-fluid" alt="<?= $row_cet_pro['title']?>" title="<?= $row_cet_pro['title']?>" ></a>
                                        <!--<span>14.29% OFF</span>                        -->
                                    </div>
                                    <div class="product-grid-content">
                                        <h4 class="m-0 mb-2"><?= $row_cet_pro['title']?></h4>
                                       
                                        <p class="m-0"><strong><?php
                                         $price2 = $row_cet_pro['price'];
                                        if ($price2 ==""){
                                            echo " ";
                                        }else{
                                            
                                             echo '₹'.$price2.'/-';
                                        }
                                        
                                        ?>
                                        </strong></p>
                                    </div>
                                </div>
                            </div>
                    <?php 
                        }
                    ?>
                </div>
            </div>
            <?php 
                }
            ?>
        </div>
    <!-- Services End -->

    <!-- games and activity Start -->
            
            <div class="container-fluid mb-5">
                <div class="row align-items-center">
                    <div class="col-6">
                        <h3 style="float:left; text-transform: capitalize;">Games & Activity</h3>
                    </div>
                    
                     <div class="col-6">
                        <!-- <a href="games-&-activitys.php" class="sea-more">See More</a> -->
                    </div>
                </div>
                <div class="row ">
                    
                    <?php 
                        $sql_act_pro = "SELECT * FROM `activity` LIMIT 4";
                        $query_act_pro = mysqli_query($conn, $sql_act_pro);
                        while($row_act_pro = mysqli_fetch_array($query_act_pro)){
                    ?>
                    
                            <div class="col-md-3 col-12 mb-4">
                                <div class="card bg-light shadow product-grid-box">
                                    <div class="product-grid-image"> 
                                        <a href="activity/<?php echo $row_act_pro['slug']?>"><img src="<?= "$base_url"."admin/".$row_act_pro['image']?>" width="555" height="420" class="img-fluid" alt="<?= $row_act_pro['title']?>"></a>
                                        <!--<span>14.29% OFF</span>                        -->
                                    </div>
                                    <div class="product-grid-content">
                                        <h4 class="m-0 mb-2"><?= $row_act_pro['title']?></h4>
                                         <p class="m-0"><strong><?php
                                         $price3 = $row_act_pro['price'];
                                        if ($price3 ==""){
                                            echo " ";
                                        }else{
                                             echo '₹'.$price3.'/-';
                                        }
                                        
                                        ?>
                                        </strong></p>
                                    </div>
                                </div>
                            </div>
                    <?php 
                        }
                    ?>

                    
                </div>
            </div>
        

    <!-- games and activity End -->


        <!-- Testimonial Start -->
        <div class="container-fluid testimonial py-5 wow zoomInDown" data-wow-delay="0.1s">
            <div class="container py-5">
                <div class="section-title mb-5">
                    <div class="sub-style">
                        <h4 class="sub-title text-white px-3 mb-0">Testimonials</h4>
                    </div>
                </div>
                 <?php $data2 = mysqli_query($conn,"select * from testimonial");
                         $row =mysqli_fetch_array($data); 
                            ?>
                <div class="testimonial-carousel owl-carousel">
                    <?php 
                        $data3 = "select * from testimonial";
                        $fetch3 = mysqli_query($conn, $data3);
                        while ($row3=mysqli_fetch_array($fetch3)) { ?> 
                    <div class="testimonial-item">
                        <div class="testimonial-inner p-5">
                            <div class="testimonial-inner-img mb-4">
                                <img src="admin/images/preloaders/<?php echo $row3['image']; ?>" class="img-fluid rounded-circle" alt="<?php echo $row3['name'];?>">
                            </div>
                            <p class="text-white fs-7"><?php echo $row3['content'];?></p>
                            </p>
                            <div class="text-center">
                                <h5 class="mb-2"><?php echo $row3['name'];?></h5>
                              
                            </div>
                        </div>
                    </div>
                     <?php }?>
                </div>
            </div>
        </div>
        <!-- Testimonial End -->


    <!-- About Start -->
        <div class="container-fluid about bg-light py-5">
            <div class="container-fluid">
                <div class="row">
                    
                         <?php $data = mysqli_query($conn,"select * from about");
                            $row =mysqli_fetch_array($data); 
                            ?> 
                    <div class="col-lg-12 wow fadeInRight" data-wow-delay="0.4s">
                        <div class=" text-start mb-5">
                           
                            <h1 class=" mb-4 mt-3"><?php echo $row['headline2'];?></h1>
                             <?php echo $row['description'];?>
                        </div>
                    </div>
                    
                    <div class="col-lg-6">
                         <img src="admin/<?php echo $row['image3']; ?>" class="img-fluid rounded mb-2"  alt="<?php echo $row['headline2'];?>">
                    </div>
                     <div class="col-lg-6">
                       <img src="admin/<?php echo $row['image4']; ?>" class="img-fluid rounded mb-2"  alt="<?php echo $row['headline2'];?>">
                    </div>
                </div>
            </div>
        </div>
        <!-- About End -->


     <!-- FAQ Start -->
        <div class="container-fluid testimonial py-5 wow zoomInDown" style="background: url(img/bgballooon.jpg);" data-wow-delay="0.1s">
            <div class="container-fluid  py-5">
          
                
                <div class="row">
                    <div class="col-md-6">
                        <img src="img/faqImg.png" alt="faq" class="img-fluid">
                    </div>
                     <div class="col-md-6">
                      <div class="accordion accordion-flush" id="accordionFlushExample">
                        <?php 
                        $data4 = "select * from faq";
                        $fetch4 = mysqli_query($conn, $data4);
                        $index = 1;
                        while ($row4=mysqli_fetch_array($fetch4)) { ?>
                            <div class="accordion-item mb-3">
                                <h2 class="accordion-header" id="flush-heading<?php echo $index; ?>">
                                    <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#flush-collapse<?php echo $index; ?>" aria-expanded="false" aria-controls="flush-collapse<?php echo $index; ?>">
                                        <i class="fas fa-plus"></i>&nbsp;&nbsp;&nbsp;<?php echo $row4['question'];?>
                                    </button>
                                </h2>
                                <div id="flush-collapse<?php echo $index; ?>" class="accordion-collapse collapse" aria-labelledby="flush-heading<?php echo $index; ?>" data-bs-parent="#accordionFlushExample">
                                    <div class="accordion-body"><?php echo $row4['answer'];?></div>
                                </div>
                            </div>
                        <?php $index++; }?>
                    </div>

                    </div>
                    
                </div>
                
            </div>
        </div>
        <!-- FAQ End -->


        <!-- Blog Start -->
        <div class="container-fluid blog py-5">
            <div class="container py-5">
                <div class="section-title mb-5 wow fadeInUp" data-wow-delay="0.1s">
                    <div class="sub-style">
                        <h4 class="sub-title px-3 mb-0">Our Blog</h4>
                    </div>
                </div>
                 <div class="row g-4">
                    <?php 
                         $blog = "select * from blog ORDER BY id DESC LIMIT 3";
                     $blogdata = mysqli_query($conn,  $blog);
                     while ($row=mysqli_fetch_array($blogdata)) { ?> 
                             
                    <div class="col-md-6 col-lg-6 col-xl-4 wow fadeInUp" data-wow-delay="0.1s">
                        <div class="blog-item rounded">
                            <div class="blog-img">
                            <a href="blog/<?php echo $row['slug']?>">
                                 <?php echo "<img alt='".$row['title']."' src='$base_url/admin/".$row['Image']."'>";?>
                            </a>                              
                            </div>
                            <div class="blog-centent p-4">
                                
                                <div class="blog-title-head">
                                <a href="blog/<?php echo $row['slug']?>" class="h4"><?php echo $row['title'];?></a>
                                
                                 <span class="blog-span" style="float:right;"><i class="fas fa-calendar-alt"></i> <?php echo $row['createdate'];?></span>
                                </div>
                                <p class="blog-span mt-2"><?php echo $row['author'];?></p>
                                <div class="content my-4"><?php echo $row['description'];?></div>
                                <a href="blog/<?php echo $row['slug']?>" class="btn btn-primary rounded-pill text-white py-2 px-4 mb-1">Read More</a>
                            </div>
                        </div>
                    </div>
                    <?php }?>
                </div>
                 <div class="blog-btn">
                     <a href=" <?php echo $base_url;?>blog"  class="more-blog"> More Blogs</a>
                 </div>
            </div>
        </div>
        <!-- Blog End -->

<?php include 'include/footer.php'; ?>