System Manager v8.0

Editing: blog(1).php

<?php
include '../admin/includes/db.php';

/* Get slug from URL */
$slug = basename($_SERVER['REQUEST_URI'], '.php');

/* Fetch published blog */
$result = mysqli_query(
    $conn,
    "SELECT * FROM blogs WHERE slug='$slug' AND status='published'"
);

if(mysqli_num_rows($result) == 0){
    http_response_code(404);
    echo "Page not found";
    exit;
}

$blog = mysqli_fetch_assoc($result);

/* Fallbacks (safety) */
$metaTitle = !empty($blog['meta_title']) ? $blog['meta_title'] : $blog['title'];
$metaDesc  = !empty($blog['meta_description']) 
            ? $blog['meta_description'] 
            : substr(strip_tags($blog['content']), 0, 160);

/* Get current URL for social sharing */
$currentUrl = "https://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];

/* Featured image URL with correct domain */
$featuredImageUrl = '';
if(!empty($blog['featured_image'])){
    $featuredImageUrl = "https://gloriousservice.com/admin/uploads/blog-images/" . $blog['featured_image'];
}
?>
<!DOCTYPE html>
<html lang="en">

<title><?php echo htmlspecialchars($metaTitle); ?></title>
    <meta name="description" content="<?php echo htmlspecialchars($metaDesc); ?>" />
    <meta name="robots" content="index, follow">

<meta property="og:title" content="<?php echo htmlspecialchars($metaTitle); ?>">
    <meta property="og:description" content="<?php echo htmlspecialchars($metaDesc); ?>">
    <meta property="og:type" content="article">
    <meta property="og:url" content="<?php echo htmlspecialchars($currentUrl); ?>">
    <meta property="og:site_name" content="Glorious Service">
    <?php if(!empty($featuredImageUrl)){ ?>
    <meta property="og:image" content="<?php echo htmlspecialchars($featuredImageUrl); ?>">
    <meta property="og:image:secure_url" content="<?php echo htmlspecialchars($featuredImageUrl); ?>">
    <meta property="og:image:width" content="1200">
    <meta property="og:image:height" content="630">
    <meta property="og:image:alt" content="<?php echo htmlspecialchars($blog['title']); ?>">
    <?php } ?>
    
    
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:title" content="<?php echo htmlspecialchars($metaTitle); ?>">
    <meta name="twitter:description" content="<?php echo htmlspecialchars($metaDesc); ?>">
    <?php if(!empty($featuredImageUrl)){ ?>
    <meta name="twitter:image" content="<?php echo htmlspecialchars($featuredImageUrl); ?>">
    <meta name="twitter:image:alt" content="<?php echo htmlspecialchars($blog['title']); ?>">
    <?php } ?>
    
    
    <meta property="article:published_time" content="<?php echo date('c', strtotime($blog['blog_date'])); ?>">
    <?php if(!empty($blog['tags'])){ ?>
    <meta property="article:tag" content="<?php echo htmlspecialchars($blog['tags']); ?>">
    <?php } ?>
    
    <link href="https://gloriousservice.com/assets/images/favicon/favicon.png" rel="icon">

<header class="header header-layout1">
      <div class="header-topbar">
          <div class="container-fluid">
              <div class="row align-items-center">
                  <div class="col-12 d-flex align-items-center justify-content-between">
                      <span class="topbar__text">
                          <span class="colored__text"><i class="icon-alert"></i> Enjoy Our Hot Offers!</span>
                          <span>Call for Free Estimate: +919760422337</span>
                      </span>
                      <div class="d-flex">
                          <ul class="contact__list d-flex flex-wrap align-items-center list-unstyled mb-0">
                              <li>
                                  <i class="icon-email"></i>
                                  <a href="#">
                                      <span>Email: </span> <span>enquiry@gloriousservice.com</span>
                                  </a>
                              </li>

</ul>
                          <ul class="social-icons list-unstyled mb-0 ml-30">
                              <li><a href="https://www.facebook.com/share/1DRuo9siWB/"><i class="fab fa-facebook-f"></i></a></li>
                              <li><a href="https://www.instagram.com/gloriousservice"><i class="fab fa-instagram"></i></a></li>

</ul>
                      </div>
                  </div>
              </div>
          </div>
      </div>
      <nav class="navbar navbar-expand-lg sticky-navbar">
          <div class="container-fluid">
              <a class="navbar-brand" href="https://gloriousservice.com/index.php">
                  <img src="https://gloriousservice.com/assets/images/logo/logo-light.png" class="logo-light" alt="logo">
                  <img src="https://gloriousservice.com/assets/images/logo/logo-dark.png" class="logo-dark" alt="logo">
              </a>
              <button class="navbar-toggler" type="button">
                  <span class="menu-lines"><span></span></span>
              </button>
              <div class="collapse navbar-collapse" id="mainNavigation">
                  <ul class="navbar-nav mr-auto">
                      <li class="nav__item">
                          <a href="https://gloriousservice.com/index.php" class="nav__item-link">Home</a>
                      </li>
                      <li class="nav__item">
                          <a href="https://gloriousservice.com/about-us.php" class="nav__item-link">About Us</a>
                      </li>
                      <li class="nav__item has-dropdown">
                          <a href="#" data-toggle="dropdown" class="dropdown-toggle nav__item-link">Services</a>
                          <ul class="dropdown-menu">
                              <li class="nav__item">
                                  <a href="https://gloriousservice.com/cleaning.php" class="nav__item-link">Cleaning Service</a>
                              </li>
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/carpenter.php">Carpenter Service</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/electrician.php">Electrician Service</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/furniture.php">Furniture Service</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/interior-design.php">Interior Design</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/kitchen.php">Modular Kitchen</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/painter.php">Painter Service</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/plumber.php">Plumber Service</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/waterprofing.php">Waterprofing Service</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/web-development.php">Web Development</a>
                              </li> 
                              <li class="nav__item">
                                  <a class="nav__item-link" href="https://gloriousservice.com/welder.php">Welder Service</a>
                              </li> 
                          </ul>
                      </li>
                      <li class="nav__item">
                          <a href="https://gloriousservice.com/blogs/index.php" class="nav__item-link">Blog</a>
                      </li>

<li class="nav__item">
                          <a href="https://gloriousservice.com/contact-us.php" class="nav__item-link">Contact Us</a>
                      </li>
                  </ul>

</div>
      </nav>
  </header>

<h1 style="
        text-align:center;
        font-size:2.4rem;
        font-weight:700;
        margin-bottom:15px;
        margin-top:30px;
    ">
      <?php echo htmlspecialchars($blog['title']); ?>
    </h1>

<div style="
        text-align:center;
        color:#777;
        font-size:0.95rem;
        margin-bottom:35px;
    ">
      <span>
        <i class="far fa-calendar-alt"></i>
        <?php echo date('d M Y', strtotime($blog['blog_date'])); ?>
      </span>

<?php if(!empty($blog['tags'])){ ?>
        <span style="margin-left:12px;">
          <i class="fas fa-tags"></i>
          <?php echo htmlspecialchars($blog['tags']); ?>
        </span>
      <?php } ?>
    </div>

<?php if(!empty($blog['featured_image'])){ ?>
      <div style="text-align:center;margin-bottom:40px;">
        <img 
          src="/admin/uploads/blog-images/<?php echo $blog['featured_image']; ?>" 
          alt="<?php echo htmlspecialchars($blog['title']); ?>"
          style="
            width:100%;
            max-width:850px;
            border-radius:12px;
            box-shadow:0 10px 30px rgba(0,0,0,0.15);
          "
        >
      </div>
    <?php } ?>

<div class="blog-content" style="
        font-size:1.05rem;
        line-height:1.9;
        color:#333;
    ">
      <?php echo $blog['content']; ?>
    </div>

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

.whatsapp-btn {
        background: #25D366;
        bottom: 20px;
        left: 20px;
    }

.call-btn {
        background: #0052da;
        bottom: 20px;
        right: 20px;
    }

.floating-btn:hover {
        transform: scale(1.08);
        color: #fff;
    }

/* Mobile friendly */
    @media(max-width:576px) {
        .floating-btn {
            width: 50px;
            height: 50px;
            font-size: 22px;
        }
    }

.gs-footer {
        background: #ffffff;
        border-top: 1px solid #eaeaea;
        padding: 60px 0 30px;
        font-size: 15px;
    }

.footer-title {
        color: #0052da;
        margin-bottom: 15px;
        font-weight: 600;
    }

.footer-text {
        color: #333;
        line-height: 1.7;
    }

.footer-links,
    .footer-contact {
        list-style: none;
        padding: 0;
        margin: 0;
    }

.footer-links li,
    .footer-contact li {
        margin-bottom: 8px;
    }

.footer-links a {
        color: #333;
        text-decoration: none;
    }

.footer-links a:hover {
        color: #0052da;
    }

.footer-contact i {
        color: #0052da;
        margin-right: 8px;
    }

.footer-social a {
        display: inline-block;
        margin-right: 12px;
        color: #0052da;
        font-size: 18px;
    }

.footer-divider {
        margin: 30px 0;
    }

.footer-copy {
        margin: 0;
        color: #333;
    }
</style>
<footer class="gs-footer">
    <div class="container">
        <div class="row">

<div class="col-sm-12 col-md-6 col-lg-4 mb-30">
                <h4 class="footer-title">Glorious Service</h4>
                <p class="footer-text">
                    Glorious Service provides trusted home and professional services including carpentry,
                    plumbing, electrical work, interior design, waterproofing, modular kitchens and web development.
                </p>

</div>

<div class="col-sm-6 col-md-6 col-lg-2 mb-30">
                <h5 class="footer-title">Quick Links</h5>
                <ul class="footer-links">
                    <li><a href="https://gloriousservice.com/index.php">Home</a></li>
                    <li><a href="https://gloriousservice.com/about-us.php">About Us</a></li>
                    <li><a href="https://gloriousservice.com/services.php">Services</a></li>
                    <li><a href="https://gloriousservice.com/contact-us.php">Contact Us</a></li>
                    <li><a href="https://gloriousservice.com/blog.php">Blog</a></li>
                </ul>
            </div>

<div class="col-sm-6 col-md-6 col-lg-3 mb-30">
                <h5 class="footer-title">Our Services</h5>
                <ul class="footer-links">
                    <li><a href="https://gloriousservice.com/carpenter.php">Carpenter</a></li>
                    <li><a href="https://gloriousservice.com/plumber.php">Plumber</a></li>
                    <li><a href="https://gloriousservice.com/electrician.php">Electrician</a></li>
                    <li><a href="https://gloriousservice.com/interior-design.php">Interior Designer</a></li>
                    <li><a href="https://gloriousservice.com/waterprofing.php">Waterproofing</a></li>
                    <li><a href="https://gloriousservice.com/web-development.php">Web Development</a></li>
                </ul>
            </div>

<div class="col-sm-12 col-md-6 col-lg-3 mb-30">
                <h5 class="footer-title">Contact Info</h5>
                <ul class="footer-contact">
                    <li><i class="fas fa-phone"></i> +91 79060 68123</li>
                    <li><i class="fas fa-envelope"></i> enquiry@gloriousservice.com</li>
                    <li><i class="fas fa-map-marker-alt"></i> Dehradun • Rishikesh • Haridwar</li>
                </ul>
            </div>

</div>

<div class="row align-items-center">
            <div class="col-md-6 text-center text-md-left">
                <p class="footer-copy">
                    © <span id="year"></span> Glorious Service. All Rights Reserved.
                </p>
            </div>
            <div class="col-md-6 text-center text-md-right">
                Developed by <a href="https://webzenix.com" target="_blank">Webzenix</a>
            </div>

</div>

</div>
</footer>

<a href="https://wa.me/917906068123" target="_blank" class="floating-btn whatsapp-btn">
    <i class="fab fa-whatsapp"></i>
</a>

<a href="tel:+917906068123" class="floating-btn call-btn">
    <i class="fas fa-phone-alt"></i>
</a>

</div>
    <div class="search-popup">
        <button type="button" class="search-popup__close"><i class="fas fa-times"></i></button>
        <form class="search-popup__form">
            <input type="text" class="search-popup__form__input" placeholder="Type Words Then Enter">
            <button class="search-popup__btn"><i class="icon-search"></i></button>
        </form>
    </div>

</html>

Cancel