<?php include('admin/config.php');
include('header.php');

$category = $_GET['cat'];
$getprojects = mysqli_query($conn, "SELECT * FROM tbl_projects WHERE project_category = '$category' AND  status = '1' ORDER BY id DESC");
?>

<style>
    .product-active {
        color: #f58110!important;
    }
</style>


<div class="sub-banner">
  <img src="assets/img/sub-banner/projects.jpg" class="img-fluid" alt="">
</div>



<main id="main">




<section class="projects-landing01">
  <div class="container">

    <h1><?= $category;?> projects</h1>


    <div class="row">
      



<?php foreach ($getprojects as $key => $value) {
  $getimage = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM tbl_project_images WHERE project_id = '$value[id]'"));?>
      <div class="col-lg-4 col-md-4">        
        <div class="project-box01">

          <img src="<?= $getimage['image_path'];?>" class="img-fluid" alt="Green Sparrow">
          <h4><?= $value['project_title'];?></h4>
          <p>
            <?=  str_replace(['<p>', '</p>'], '', $value['short_description']);?>
          </p>
          <a href="project-details.php?proid=<?= $value['id'];?>" class="btn btn-primary">view details</a>

        </div>
      </div>
<?php } ?>


      <!-- <div class="col-lg-4 col-md-4">        
        <div class="project-box01">

          <img src="assets/img/projects/site01/1.jpg" class="img-fluid" alt="Green Sparrow">
          <h4>Solar Nest 1 - 11 MW SOLAR POWER PLANT</h4>
          <p>
            Green Sparrow Solar Nest (P) Ltd. is at the forefront of solar energy development in Pudhukottai district, Tamil Nadu, with a project site in Udayalipatti and Odugampatti villages.
          </p>
          <a href="project-details.html" class="btn btn-primary">view details</a>

        </div>
      </div>



      <div class="col-lg-4 col-md-4">        
        <div class="project-box01">

          <img src="assets/img/projects/site01/1.jpg" class="img-fluid" alt="Green Sparrow">
          <h4>Solar Nest 1 - 11 MW SOLAR POWER PLANT</h4>
          <p>
            Green Sparrow Solar Nest (P) Ltd. is at the forefront of solar energy development in Pudhukottai district, Tamil Nadu, with a project site in Udayalipatti and Odugampatti villages.
          </p>
          <a href="project-details.html" class="btn btn-primary">view details</a>

        </div>
      </div> -->





    </div>


  </div>
</section>




</main>

  <!-- ======= Footer ======= -->
      <?php include('footer.php');?>

  <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

  <!-- Vendor JS Files -->
  <script src="assets/vendor/purecounter/purecounter_vanilla.js"></script>
  <script src="assets/vendor/aos/aos.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/glightbox/js/glightbox.min.js"></script>
  <script src="assets/vendor/isotope-layout/isotope.pkgd.min.js"></script>
  <script src="assets/vendor/swiper/swiper-bundle.min.js"></script>


  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>


<script src="assets/slider/jquery.min.js"></script> 
<script src="assets/slider/owl.carousel.js"></script>
<script src="assets/slider/lightbox.min.js"></script>

<script type="text/javascript">
      $('#slidermaster').owlCarousel({
      loop:true,
      margin:10,
      dots:true,
      nav:true,
      navText : ["<i class='bi bi-chevron-left'></i>","<i class='bi bi-chevron-right'></i>"],
      mouseDrag:true,
      autoplay:true,
      autoplayTimeout:5000,
      responsive:{
              0:{
                  items:1
              },
              600:{
                  items:1
              },
              1000:{
                  items:1
              }
          }
      });
</script>


<script>
  var fielda= Math.floor((Math.random() * 10) + 1);
  var fieldb= Math.floor((Math.random() * 10) + 1);
  var fieldc=fieldb+fielda;
  document.getElementById("fielda").value=fielda;
  document.getElementById("fieldb").value=fieldb;
  document.getElementById("fieldc").value=fieldc;
  
  var fielda1= Math.floor((Math.random() * 10) + 1);
  var fieldb1= Math.floor((Math.random() * 10) + 1);
  var fieldc1=fieldb1+fielda1;
  document.getElementById("fielda1").value=fielda1;
  document.getElementById("fieldb1").value=fieldb1;
  document.getElementById("fieldc1").value=fieldc1;
</script>



<script type="text/javascript">
  
$('#recent-projects').owlCarousel({
    items:3,
    loop:true,
    margin:10,
    nav:true,
    autoplay:true,
    center:false,
    dots:false,
    navText : ["<i class='bi bi-chevron-left'></i>","<i class='bi bi-chevron-right'></i>"],
    startPosition: 0,
    responsive:{
        0:{
            items:1
        },
        600:{
            items:1
        },
        1000:{
            items:3
        }
    }
})

</script>






<script type="text/javascript">
  
$('#our_associates').owlCarousel({
    items:4,
    loop:true,
    margin:10,
    nav:true,
    startPosition: 0,
    dots:false,
    navText : ["<i class='bi bi-chevron-left'></i>","<i class='bi bi-chevron-right'></i>"],
    responsive:{
        0:{
            items:1
        },
        600:{
            items:1
        },
        1000:{
            items:4
        }
    }
})


</script>





<script type="text/javascript">  

    $(document).ready(
      function(){
        $('#myBtn1').hover(
          function(){
            $('#more1').toggle();            
          }
        );
      }
    );

</script>


<script type="text/javascript">  

    $(document).ready(
      function(){
        $('#myBtn2').hover(
          function(){
            $('#more2').toggle();            
          }
        );
      }
    );

</script>


<script type="text/javascript">  

    $(document).ready(
      function(){
        $('#myBtn3').hover(
          function(){
            $('#more3').toggle();            
          }
        );
      }
    );

</script>


<script type="text/javascript">  

    $(document).ready(
      function(){
        $('#myBtn4').hover(
          function(){
            $('#more4').toggle();            
          }
        );
      }
    );

</script>


<script type="text/javascript">  

    $(document).ready(
      function(){
        $('#stat_btn').click(
          function(){
            $('.form-master01').toggle();   
            $('#company_name').show();
          }
        );
      }
    );

</script>



<script type="text/javascript">
  

jQuery(document).ready(function() {
    jQuery('.tabs .tab-links a').on('click', function(e)  {
        var currentAttrValue = jQuery(this).attr('href');
 
        // Show/Hide Tabs
        jQuery('.tabs ' + currentAttrValue).show().siblings().hide();
 
        // Change/remove current tab to active
        jQuery(this).parent('li').addClass('active').siblings().removeClass('active');
 
        e.preventDefault();
    });
   
     
    jQuery('.nextButton').on('click', function() {
        
   var $activeTab = $('.tab-links li.active');
   
   var $wrapper = jQuery(this).closest('.tabs');
   var indexActive = $wrapper.find('li.active').index();
   $wrapper.find('li').eq(indexActive + 1).find('a').click();
});
    
     jQuery('.prevButton').on('click', function() {
        
   var $activeTab = $('.tab-links li.active');
   
   var $wrapper = jQuery(this).closest('.tabs');
   var indexActive = $wrapper.find('li.active').index();
   $wrapper.find('li').eq(indexActive - 1).find('a').click();
});
    
});

</script>



<script type="text/javascript">
  
$('#project01').owlCarousel({
    items:1,
    loop:true,
    margin:10,
    nav:true,
    autoplay:true,
    navText : ["<i class='bi bi-chevron-left'></i>","<i class='bi bi-chevron-right'></i>"],
    dots:false,
    startPosition: 0,
    responsive:{
        0:{
            items:1
        },
        600:{
            items:1
        },
        1000:{
            items:1
        }
    }
})


</script>



</body>
</html>