<?php include 'header.php'?>
<?php include 'navbar.php'?>
<?php include 'admin/connect.php'?>
        <div id="content" class="site-content">
            <div class="page-header dtable text-center about-back">
                <div class="dcell">
                    <div class="container">
                        <h1 class="page-title">Portfolio</h1>
                        <ul id="breadcrumbs" class="breadcrumbs">
                            <li><a href="index.php">Home</a></li>
                            <li class="active">Portfolio</li>
                        </ul>
                    </div>
                </div>
            </div>


		 <section class="p-t110 p-b90">
                <div class="container">
                    <div class="row">
                        <div class="col-md-12 m-b20">
                            <div class="ot-heading text-center">
                                <h6><span>our projects</span></h6>
                                <h2 class="main-heading">View Some of Our Works  </h2>
                            </div>
                        </div>
                    </div>
                    <div class="project-filter-wrapper">
                        <div class="container">
                            <ul class="project_filters">
                                <li style="display:none;"><a href="#" data-filter="*" class="selected">All</a></li>
                                <?php
		  $sql=mysqli_query($conn,"SELECT * FROM gallery_category");	
          while($row=mysqli_fetch_array($sql)){
			  			   $sentence = $row['category']; 
  $filter=strtok($sentence, " "); 
		?>
                    <li><a href="#" data-filter=".<?php echo $filter; ?>"><?php echo $row['category']; ?></a></li>
<?php
}
		?>                       
                            </ul>
                        </div>
                        <div class="projects-grid">
						 <?php
		  $sql1=mysqli_query($conn,"SELECT a.*,b.* FROM gallery_category AS a, gallery AS b WHERE a.id=b.cid");	
          while($row1=mysqli_fetch_array($sql1)){
			   $sentence1 = $row1['category']; 
  $filter1=strtok($sentence1, " "); 
		?>
                            <div class="project-item media <?php echo $filter1; ?> ">
                                <div class="projects-box">
                                    <div class="projects-thumbnail">
                                        <a href="portfolio-single.html">
                                            <img src="admin/<?php echo $row1['image']; ?>" class="" alt="web design, web Development, Digital Marketing, Social Marketing">
                                        </a>
                                    </div>
                                    <div class="portfolio-info s1">
                                        <div class="portfolio-info-inner">
                                             
                                             <p class="portfolio-cates"><a href="<?php echo $row1['url']; ?>" target="blank"><?php echo $row1['content']; ?></a> </p>
                                        </div>
                                    </div>
                                </div>
                            </div>
							
							
		  <?php }?>
                             
                            
 

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



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