D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
thread-self
/
root
/
proc
/
thread-self
/
root
/
home
/
shubmkcj
/
designpitara.com
/
Filename :
category.php
back
Copy
<?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>