1#@!#!123s

: / home / shubmkcj / designpitara.com /
Filename : category.php
back
<?php
   include 'dash/config.php';
   
   $category = $_GET['url'];
  
    $pageName = str_replace("-", " ", $category);
    $pageTitle =ucwords($pageName) . " - Design Pitara";
     // Program to display URL of current page. 
  
    if(isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on') 
        $link = "https"; 
    else
        $link = "http"; 
      
    // Here append the common URL characters. 
    $link .= "://"; 
      
    // Append the host(domain name, ip) to the URL. 
    $link .= $_SERVER['HTTP_HOST']; 
      
    // Append the requested resource location to the URL 
    $link .= $_SERVER['REQUEST_URI']; 
         
         
         
         
   $cat_cut = str_replace('-',' ',$category);
   
   
   //echo "SELECT * FROM `b_category` where `b_category`.`url`='$category'";
   $de = mysqli_query($conn,"SELECT * FROM `b_category` where `b_category`.`url`='$category'");
   
   $derow = mysqli_fetch_assoc($de);
   
   $blogcat_title = $derow['b_category_name'];
   $blog_cat_id = $derow['id'];
   $title = $derow['meta_title'];
   $desc = $derow['meta_description'];
   $keyword = $derow['meta_keyword'];
   
//   echo $blogcat_title;
?> 
<!doctype html>
<html class="no-js" lang="en">
   <head>
      <meta charset="utf-8">
      <meta http-equiv="x-ua-compatible" content="ie=edge">
      <title><?php if(!empty($title)){ echo $title; }else{ echo $pageTitle;} ?></title>
      <meta name="description" content="<?php echo $desc ?>">
      <meta name="keywords" content="<?php echo $keyword ?>">
      <link rel="canonical" href="<?php echo $link ?>" />
      <meta name="robots" content="follow,index">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <!-- favicon -->		
      <link rel="shortcut icon" type="image/x-icon" href="/img/logo/favicon.ico">
      <!-- all css here -->
      <!-- bootstrap v3.3.6 css -->
      <link rel="stylesheet" href="/css/bootstrap.min.css">
      <!-- owl.carousel css -->
      <link rel="stylesheet" href="/css/owl.carousel.css">
      <link rel="stylesheet" href="/css/owl.transitions.css">
      <!-- meanmenu css -->
      <link rel="stylesheet" href="/css/meanmenu.min.css">
      <!-- font-awesome css -->
      <link rel="stylesheet" href="/css/font-awesome.min.css">
      <link rel="stylesheet" href="/css/icon.css">
      <link rel="stylesheet" href="/css/flaticon.css">
      <!-- magnific css -->
      <link rel="stylesheet" href="/css/magnific.min.css">
      <!-- venobox css -->
      <link rel="stylesheet" href="/css/venobox.css">
      <!-- style css -->
      <link rel="stylesheet" href="/style.css">
      <!-- responsive css -->
      <link rel="stylesheet" href="/css/responsive.css">
      <!-- modernizr css -->
      <script src="/js/vendor/modernizr-2.8.3.min.js"></script>
   </head>
   <body>
       <?php include 'inner-header.php'; ?>
      <!-- header end --> 
      <!-- Start breadcumb Area -->
      <div class="page-area">
         <div class="breadcumb-overlay"></div>
         <div class="container">
            <div class="row">
               <div class="col-md-12 col-sm-12 col-xs-12">
                  <div class="breadcrumb text-center">
                     <div class="section-headline white-headline">
                        <h1 class="text-white text-capitalize"><?php echo ucwords($blogcat_title); ?></h1>
                     </div>
                     <ul class="breadcrumb-bg">
                        <li class="home-bread">Home</li>
                        <li>Category</li>
                     </ul>
                  </div>
               </div>
            </div>
         </div>
      </div>
      <!-- End breadcumb Area -->
      <!--Blog Area Start-->
      <div class="blog-page-area page-padding">
         <div class="container">
            <div class="row">
               <div class="blog-sidebar  row-two">
                  <div class="col-md-8 col-sm-8 col-xs-12">
                     <div class="row">
                        <div class="blog-left-content">
                           <?php
                              $sql = "SELECT * FROM `atul_blogs` WHERE `atul_blogs`.`status`='active' AND `atul_blogs`.`blogs_categ_id`='$blog_cat_id' order by id desc";
                              $result = mysqli_query($conn,$sql);
                              while($row = mysqli_fetch_assoc($result)){
                                  
                                  $blogs_categ_id = $row['blogs_categ_id'];
                                   $sql1 = "SELECT * FROM `b_category` WHERE `b_category`.`id`='$blogs_categ_id'";
                              $result1 = mysqli_query($conn,$sql1);
                              while($row1 = mysqli_fetch_assoc($result1)){
                                  $blogs_categ_url = $row1['url'];
                              }
                              
                              ?>
                           <div class="col-md-12 col-sm-12 col-xs-12">
                              <div class="single-blog">
                                 <div class="blog-image">
                                      <a  class="image-scale" href="/blog/<?php echo $blogs_categ_url; ?>/<?php echo $row['url'] ?>">
                                    
                                    <img class="multi_blog_img" src="/admin/blogs/blogs-files/<?php echo $row['picture']; ?>" alt="<?php  echo $row['title'] ?>">
                                    </a>
                                 </div>
                                 <div class="blog-content">
                                    <div class="blog-meta">
                                       <span class="date-type">
                                       <?php echo $row['date_add']; ?>
                                       </span> 
                                    </div>
                                    <a href="/blog/<?php echo $blogs_categ_url; ?>/<?php echo $row['url'] ?>">
                                       <?php 
                                          $post =  $row['title'];
                                          ?>
                                       <h4><?php echo $post ?></h4>
                                    </a>
                                    <?php 
                                       $character = 430;
                                       $blog_content = substr($row['blogs_details'],0,$character);
                                    ?>
                                    <p><?php echo strip_tags($blog_content). ' ...'; ?></p>
                                    <a class="read-more" href="/blog/<?php echo $blogs_categ_url; ?>/<?php echo $row['url'] ?>"> Read more</a>
                                 </div>
                              </div>
                           </div>
                           <?php } ?>
                           <!-- End single blog --> 
                           <!-- End single blog --> 
                        </div>
                     </div>
                  </div>
                  <!-- End single blog -->
                  <!-- Start Right Sidebar blog -->
                  <?php
                     include 'blogleftmenu.php';
                     ?>
                  <!-- End Right Sidebar -->
               </div>
            </div>
            <!-- End row -->
         </div>
      </div>
      <!--End of Blog Area-->	
      <!--Start Footer Area-->
      <?php include 'footer.php'; ?>
      <!-- all js here -->
      <!-- jquery latest version -->
      <script src="../js/vendor/jquery-1.12.4.min.js"></script>
      <!-- bootstrap js -->
      <script src="../js/bootstrap.min.js"></script>
      <!-- owl.carousel js -->
      <script src="../js/owl.carousel.min.js"></script>
      <!-- Counter js -->
      <script src="../js/jquery.counterup.min.js"></script>
      <!-- waypoint js -->
      <script src="../js/waypoints.js"></script>
      <!-- isotope js -->
      <script src="../js/isotope.pkgd.min.js"></script>
      <!-- stellar js -->
      <script src="../js/jquery.stellar.min.js"></script>
      <!-- magnific js -->
      <script src="../js/magnific.min.js"></script>
      <!-- venobox js -->
      <script src="../js/venobox.min.js"></script>
      <!-- meanmenu js -->
      <script src="../js/jquery.meanmenu.js"></script>
      <!-- Form validator js -->
      <script src="../js/form-validator.min.js"></script>
      <!-- plugins js -->
      <script src="../js/plugins.js"></script>
      <!-- main js -->
      <script src="../js/main.js"></script>
   </body>
</html>