1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / techoozesolution / public_html /
Filename : our-blogs.php
back
<!DOCTYPE HTML>
<html lang="en">
   <head>
      <?php
      include 'db.php';
         $fetchseo=mysqli_query($conn,"select * from add_menu where menu_link='our-blogs'");
         if($fetchseo_seo=mysqli_fetch_array($fetchseo)){ ?>
<title><?php echo $fetchseo_seo['stitle']; ?></title>
<meta name="description" content="<?php echo $fetchseo_seo['sdes']; ?>">
<link rel="canonical" href="<?php echo $fetchseo_seo['scanon']; ?>">
       <?php echo $fetchseo_seo['metatags']; ?>
      <meta charset="utf-8">
      <meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<?php echo $fetchseo_seo['schme']; ?>
<?php } ?>
   <link rel="stylesheet" href="css/font-awesome.min.css">
      <link rel="stylesheet" href="css/animate.css">
      <link rel="stylesheet" href="css/icofonts.css">
      <link rel="stylesheet" href="css/bootstrap.min.css">
      <link rel="stylesheet" href="css/owlcarousel.min.css">
      <link rel="stylesheet" href="css/magnific-popup.css">
      <link rel="stylesheet" href="css/style.css">
      <link rel="stylesheet" href="css/responsive.css">
      <script src="https://www.google.com/recaptcha/api.js" async defer></script> 
<?php include('header.php');?>
<?php include('db.php');?>
<div id="banner-area" class="banner-area" style="background-image:url(images/banner/banner5.jpg)">
   <div class="container">
      <div class="row">
         <div class="col-sm-12">
            <div class="banner-heading">
               <h1 class="banner-title">Our Blogs</h1>
               <ol class="breadcrumb">
                  <li>Home</li>
                  <li><a href="#">Our Blogs</a></li>
               </ol>
            </div>
         </div>
      </div>
   </div>
</div> 
<section id="tw-blog" class="tw-blog">
         <div class="container">
            <div class="row text-center">
               <div class="col section-heading wow fadeInDown" data-wow-duration="1s" data-wow-delay=".5s">
                  <h2> 
                     Latest <span>Blog</span>
                  </h2>
                  <span class="animate-border border-offwhite ml-auto mr-auto tw-mt-20"></span>
               </div>
            </div>
            <div class="row wow fadeInUp" data-wow-duration="1s" data-wow-delay=".2s">
            <?php
include 'db.php';
if (isset($_GET['pageno'])) {
    $pageno = $_GET['pageno'];
} else {
    $pageno = 1;
}
$no_of_records_per_page = 6;
$offset = ($pageno-1) * $no_of_records_per_page;

// Check connection
if (mysqli_connect_errno()){
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    die();
}

$total_pages_sql = "SELECT COUNT(*) FROM blogs";
$result = mysqli_query($conn,$total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);

$sql = "SELECT * FROM blogs order by page_id DESC";
$res_data = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($res_data)){
   ?>
               <div class="col-lg-4 col-md-12">
                  <div class="tw-latest-post">
                     <div class="latest-post-media text-center">
                        <img src="<?php echo $row['image']; ?>" alt="blog_image_one" class="img-fluid">
                     </div>
                     <div class="post-body" >
                        <div class="post-item-date">
                           <div class="post-date">
                           <?php 
                           $olddate=strtotime($row['date']);
                           $newdate=date("d",$olddate);
                           $newmont=date("M",$olddate);
                           $fetchinh=$row['pg_url'];
                           ?>
                           <span class="date"><?php echo $newdate; ?></span>
                              <span class="month"><?php echo $newmont; ?></span>
                           </div>
                        </div>
                        <div class="post-info">
                           <div class="post-meta">
                              <span class="post-author">
                              Posted by <a href="https://www.techoozesolutions.com/blog/<?php echo $row['pg_url']; ?>">Admin</a>
                              </span>
                           </div>
                           <h3 class="post-title"><a href="https://www.techoozesolutions.com/blog/<?php echo $row['pg_url']; ?>"><?php echo $row['title']; ?></a></h3>
                           <div class="entry-content">
                              <p><?php echo substr(strip_tags($row['description']),0,160)."..."; ?></p>
                           </div>
                        </div>
                     </div>
                  </div>
               </div>
               <?php } ?>
                  
               
            </div>
         
         <div class="paging text-center " style="margin-top:30px;">
                  <!--<ul class="pagination justify-content-center">-->
                  <!--   <li><a href="#"><i class="icon icon-arrow-left"></i></a></li>-->
                  <!--   <..?php-->
                  <!--   $counter=0;-->
                  <!--   $counter2=0;-->
                  <!--   $blog=mysqli_query($conn,"select * from blogs");-->
                  <!--   while($fetch_blog=mysqli_fetch_array($blog)){-->
                  <!--   ?>-->
                  <!--   <li class="active"><a href="?pageno=<..?php echo ++$counter2; ?>"><..?php echo ++$counter; ?></a></li>-->
                  <!--   <..?php } ?>-->
                  <!--   <li><a href="#"><i class="icon icon-arrow-right"></i></a></li>-->
                  <!--</ul> -->
               </div> 
               </div>
      </section>
 

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