/home/hdwebsolution/www/ns-interior/include/header.php
<?php
require_once('connection_font.php');
$page = basename($_SERVER['SCRIPT_NAME'],".php");
//logo header
$sql_logo="SELECT * FROM `tbl_web_logo` LIMIT 1";
$run_logo = mysqli_query($link,$sql_logo);
$result_logo = mysqli_fetch_assoc($run_logo);
//logo footer
$sql_logo_f="SELECT * FROM `tbl_footer_logo` LIMIT 1";
$run_logo_f = mysqli_query($link,$sql_logo_f);
$result_logo_f = mysqli_fetch_assoc($run_logo_f);
//Contact
$sql_Contact = "SELECT * FROM `tbl_admin` LIMIT 1";
$run_Contact = mysqli_query($link,$sql_Contact);
$result_Contact = mysqli_fetch_assoc($run_Contact);
//
$sql_social = "SELECT * FROM `tbl_social_media` LIMIT 1";
$run_social = mysqli_query($link,$sql_social);
$result_social = mysqli_fetch_assoc($run_social);
?>
<?php
define('SITE_URL', 'https://hdwebsolution.com/ns-interior/');
?>
<!DOCTYPE HTML>
<html class="no-js" lang="zxx">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<title>NS INTERIOR DESIGN</title>
<!-- GOOGLE FONTS -->
<link href="https://fonts.googleapis.com/css?family=Montserrat:500,600,700%7COpen+Sans:300,400" rel="stylesheet">
<!-- FONT AWESOME -->
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/fontawesome-all.min.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/font-awesome.min.css">
<!-- Slider Revolution CSS Files -->
<link rel="stylesheet" href="<?php echo SITE_URL; ?>revolution/css/settings.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>revolution/css/layers.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>revolution/css/navigation.css">
<!-- ARCHIVES CSS -->
<link href="<?php echo SITE_URL; ?>css/bootstrap.css" rel="stylesheet">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/menu.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/aos.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/aos2.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/slick.css">
<link href="<?php echo SITE_URL; ?>css/animate.min.css" rel="stylesheet">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/lightcase.css">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/owl.carousel.min.css">
<link href="<?php echo SITE_URL; ?>css/menu.css" rel="stylesheet">
<link rel="stylesheet" href="<?php echo SITE_URL; ?>css/styles.css">
</head>
<body class="homepage-1 int_white_bg">
<!-- Wrapper -->
<div id="wrapper">
<!-- START SECTION HEADINGS -->
<!-- Header Container
================================================== -->
<!-- Top Bar -->
<!-- Top Bar -->
<div class="top-bar">
<div class="container">
<div class="top-bar-left">
<span><i class="fa fa-map-marker"></i> DDA Janta Flats, 567, Group -1, LIG MIG Flats, Vikaspuri, Hastsal, New Delhi, Delhi, 110059</span>
<span><i class="fa fa-phone"></i> 097168 39900</span>
</div>
<div class="top-bar-right">
NS Interior || Best Interior Designer Delhi
</div>
</div>
</div>
<!-- Header Section -->
<header id="header-container" class="header">
<div id="header" class="bottom">
<div class="container">
<!-- Left Side Content -->
<div class="left-side">
<!-- Logo -->
<div id="logo" class="col-lg-2 logo-white">
<a href="#"><img src="<?php echo SITE_URL; ?>images/nsinterior.png" data-sticky-logo="<?php echo SITE_URL; ?>images/nsinterior.png" alt=""></a>
</div>
<!-- Mobile Navigation -->
<div class="mmenu-trigger">
<button class="hamburger hamburger--collapse" type="button">
<span class="hamburger-box">
<span class="hamburger-inner"></span>
</span>
</button>
</div>
<!-- Main Navigation -->
<nav id="navigation" class="style-1">
<ul id="responsive">
<li><a href="<?php echo SITE_URL; ?>index.php">Home</a></li>
<li><a href="<?php echo SITE_URL; ?>about.php">About Us</a></li>
<?php
include("connection_font.php"); // database connection
// Function to generate SEO-friendly slug
function slugify($text) {
$text = preg_replace('~[^\pL\d]+~u', '-', $text);
$text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);
$text = preg_replace('~[^-\w]+~', '', $text);
$text = trim($text, '-');
$text = preg_replace('~-+~', '-', $text);
return strtolower(!empty($text) ? $text : 'n-a');
}
// Fetch all categories
$cat_sql = "SELECT * FROM tbl_category";
$cat_res = mysqli_query($link, $cat_sql);
?>
<li><a href="#">Services</a>
<ul>
<?php while ($cat = mysqli_fetch_assoc($cat_res)) {
$cat_id = $cat['cat_id'];
$cat_slug = slugify($cat['cate_name']);
?>
<li>
<a href="<?php echo SITE_URL; ?>solutions/<?php echo $cat_slug; ?>">
<?php echo htmlspecialchars($cat['cate_name']); ?>
</a>
<?php
// Fetch products for this category
$pro_sql = "SELECT * FROM tbl_product WHERE pro_category = '$cat_id'";
$pro_res = mysqli_query($link, $pro_sql);
if (mysqli_num_rows($pro_res) > 0) {
?>
<ul>
<?php while ($pro = mysqli_fetch_assoc($pro_res)) {
$pro_slug = slugify($pro['pro_name']);
?>
<li>
<a href="<?php echo SITE_URL; ?>solution-details/<?php echo $pro_slug; ?>">
<?php echo htmlspecialchars($pro['pro_name']); ?>
</a>
</li>
<?php } ?>
</ul>
<?php } ?>
</li>
<?php } ?>
</ul>
</li>
<li><a href="<?php echo SITE_URL; ?>gallery.php">Gallery</a></li>
<li><a href="<?php echo SITE_URL; ?>blog.php">Blog</a></li>
<li><a href="<?php echo SITE_URL; ?>contact.php">Contact</a></li>
</ul>
</nav>
<!-- Main Navigation / End -->
</div>
<!-- Left Side Content / End -->
</div>
</div>
</header>