<?php include 'header.php'?>
<?php include 'navbar.php'?>
<?php include 'admin/connect.php'?>

 

        <div id="content" class="site-content">
            

            <div class="entry-content">
                <div class="container">
                    <div class="row">
					   <aside class="widget-area primary-sidebar col-lg-12 col-md-12 col-sm-12 col-xs-12 newpcp">
                            <section id="author_widget-2" class="widget onum_author-widget">
                                <div class="author-widget_wrapper newautoiu text-center">
                                     <section class="widget widget_categories ppdata">
                               
                                <ul>
                                    <li>Year : </li>
									<?php
									include 'admin/connect.php';
										$sql1=mysqli_query($conn,"select * from portfolioyear");
										while($row1=mysqli_fetch_array($sql1)){
									
									
									?>
									
                                    <li><a href="portfolio-category.php?id=<?php echo $row1['id'];?>"><?php echo $row1['year'];?></a>  </li>
										<?php } ?>
									
									<li><a href="portfolio.php">Go Back</a> </li>
                                    
                                </ul>
                            </section>
                                </div>
                            </section>
                            
                        </aside>
						
                        <div class="content-area col-lg-12 col-md-12 col-sm-12 col-xs-12">
                            <div class="blog-list row portcatyyy">
							
							<?php
							$data=$_GET['id'];
									include 'admin/connect.php';
										$sql2=mysqli_query($conn,"select * from portfoliocategory where yid='$data'");
										while($row2=mysqli_fetch_array($sql2)){
									
									
									?>
                                <div class="post-box col-lg-2  col-xs-6">
                                    <div class="post-inner">
                                        <div class="entry-media">
                                            
                                            <a href="portfolio-image.php?id=<?php echo $row2['id'];?>">
                                                <img src="admin/<?php echo $row2['image'];?>" alt="business development-company-in-karaikudi">
                                            </a>
                                        </div>
                                        <div class="inner-post">
                                            
                                            <div class="entry-summary the-excerpt">
                                               <a href="portfolio-image.php?id=<?php echo $row2['id'];?>"> <h5><?php echo $row2['category'];?></h5></a>
                                            </div><!-- .entry-content -->
                                        </div>
                                    </div>
                                </div>
								
										<?php } ?>
								
                                
                            </div>
                            
                        </div>

                     
                    </div>
                </div>
            </div>
        </div>

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