<?php require("libs/fetch_data.php");
 //code to get the item using its id
error_reporting(E_ALL);
include("database/conn.php");//database config file

$id = $_REQUEST['id']; 
$query = "SELECT * FROM blogs WHERE url = '" . $id . "' OR id = '" . $id . "' ORDER BY id DESC LIMIT 1";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $query) or die(
    (is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) :
    (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : true)
);

if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);

    // ✅ If URL is accessed via ID, redirect permanently to canonical slug
    if (isset($_GET['id']) && is_numeric($_GET['id'])) {
        header("HTTP/1.1 301 Moved Permanently");
        header("Location: " . $row['url']);
        exit;
    }

    // ✅ Else: proceed normally (already on clean slug)
    // process $row here to display the post

} else {
    // ❌ No post found
    header("Location: 404.php");
    exit();
}

//pageview count query
$page=$row['title'];
$count="SELECT * FROM page_hits WHERE page='".$page."'";$feedback=mysqli_query($GLOBALS["___mysqli_ston"],$count) or die ( ((is_object($GLOBALS["___mysqli_ston"]))? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ?$___mysqli_res : true))); 
$roo=mysqli_fetch_assoc($feedback);
$protocol = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off' || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$host = isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : 'localhost';
$requestUri = $_SERVER['REQUEST_URI'];
$pathParts = explode('/', trim($requestUri, '/'));
$subdomain = explode('.', $_SERVER['HTTP_HOST'])[0];
$domain = explode('.', $_SERVER['HTTP_HOST'])[1];
$parts = explode('.', $host);
$domain1 = $parts[0];
$brand = ucwords(str_replace('-', ' ', $domain1));
$author = isset($row['author']) && trim($row['author']) != '' ? $row['author'] : $brand;

if (strcasecmp($author, 'admin') === 0) {
    $author = $brand;
}
$currentUrl = $protocol .$host.  $requestUri;
$currentUrl = urldecode($currentUrl);
if (strlen($domain)<4)
{
	$host=$host.str_replace('/single.php','',strtolower($_SERVER['PHP_SELF']));
}
//$firstPathSegment = (count($pathParts) > 1) ? '/' . $pathParts[0] : '';
//}
//else
//{
//	$currentUrl = "**".$protocol . $host . $requestUri;
//}


								$image =$row['photo'];
			if (strpos(strtolower($image),"https://") !== false)
			{
				//file_put_contents("links.txt",$image, FILE_APPEND | LOCK_EX);
				//$image='shit'; //$griditem['photo'];
			}
			else
			{
				//file_put_contents("nolink.txt",$image.chr(13), FILE_APPEND | LOCK_EX);
				$image=$protocol . $host.'/blogadmin/images/'.$row['photo'];
			}
				 $seodesc= str_replace(["\r\n", "\r", "\n"], ' ',preg_replace('/\s+/', ' ',trim(substr(strip_tags($row['content']),0,250)))).'...'; 
				$seodesc = strlen($seodesc) > 150 ? substr($seodesc, 0, 150) : $seodesc;
				$seodesc .= "...";

				if (!isset($row['seo_title']) || trim($row['seo_title']) === '') {
						$seo_title= $row['title'];
					} else {
						$seo_title= $row['seo_title'];
				}
				if (!isset($row['seo_tags']) || trim($row['seo_tags']) === '') {
					if (empty($row['tags']) || $row['tags'] === null || $row['tags'] === 0) {
							$seo_tags= "Sithars Astrology Software, Best Astrology Software";
							} else {
							$seo_tags =$row['tags'];
							}
					} else {
						$seo_tags= $row['seo_tags'];
				}
				if (!isset($row['seo_desc']) || trim($row['seo_desc']) === '') {
						$seo_desc= $seodesc;
					} else {
						$seo_desc= $row['seo_desc'];
				}
	$seo_desc = htmlspecialchars($seo_desc, ENT_QUOTES, 'UTF-8');	


// --------------------------------
// 3. Language detection (based on category)
// --------------------------------
// Default language
$langCode = 'en';
$langName = 'English';

// Check for Tamil (safe multibyte check)
if (!empty($category_name)) {
    // Option 1: simple English word check
    if (preg_match('/tamil/i', $category_name)) {
        $langCode = 'ta';
        $langName = 'Tamil';
    }
    // Option 2: fallback — detect Tamil characters
    elseif (preg_match('/[\x{0B80}-\x{0BFF}]/u', $category_name)) {
        $langCode = 'ta';
        $langName = 'Tamil';
    }
}

	
?>
<!DOCTYPE html>
<html lang="<?php echo $langCode; ?>">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php if (file_exists("head.php")) {    include "head.php"; } 

$currentUrl = strtolower($currentUrl);
// Check if the current URL contains 'single.php?id='
if (strpos($currentUrl, 'single.php?id=') !== false) {
     $parsedUrl = parse_url($currentUrl);
    parse_str($parsedUrl['query'], $queryParams);
    
    // Check if 'id' is set in the query string
    if (isset($queryParams['id'])) {
        // Use the value of $row['url'] instead of the 'id' parameter
        $newUrl = rtrim(dirname($parsedUrl['path']), '/') . '/' . $row['url'];

        // Construct the final URL with 'https' and domain
        $currentUrl = 'https://' . $parsedUrl['host'] . $newUrl;
    }
}
 $is_kovaiyellowpages = (strpos($host, 'blog.kovaiyellowpages.com') !== false);
?> 
	<title><?php 
	 $host = parse_url("https://" . $_SERVER['HTTP_HOST'], PHP_URL_HOST);

// Extract site name (remove .com, .org, .net, etc.)
$site_name = preg_replace('/\.(com|org|net|in|co\.uk|edu)$/i', '', $host);

switch (strtolower($site_name)) {
	case "quicktechsupport":
        $formatted_site_name = "Quick Tech Support";
        break;
    case "sitharsastrology":
        $formatted_site_name = "Sithars Astrology";
        break;
    case "kovaiyellowpages":
        $formatted_site_name = "Kovai Yellow Pages";
        break;
		default:
        // Fallback: Convert to title case with spaces
        $formatted_site_name = ucwords(str_replace("-", " ", $site_name));
}

// Check if title already contains the site name (case-insensitive)
if (stripos($seo_title, $formatted_site_name) === false) { 
    $seo_title .= " | " . $formatted_site_name; 
}
echo (strlen($seo_title) > 60) ? substr($seo_title, 0, 60) . "..." : $seo_title;
	?></title>
		<meta name="description" content="<?php echo $seo_desc ?>">
	<meta name="keywords" content="<?php echo $seo_tags; ?>" />
	<meta name="robots" content="index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1">
		<link rel="canonical" href="<?php echo $currentUrl; ?>" />	
	<meta name="author" content="<?php echo $author; ?>">
	<meta name="publisher" content="<?php echo $author; ?>">
	<meta name="language" content="<?php echo $langName; ?>">
<meta http-equiv="content-language" content="<?php echo $langCode; ?>">
	<link id="browser_favicon" rel="shortcut icon" href="<?php echo $protocol . $host . ($is_kovaiyellowpages ? '/' : '/blog/') ?>/blogadmin/logo.jpg">
 <meta name="theme-color" content="#4a0c0c">
	<!-- Add structured data for better SEO -->
	
	<?php
	
$type_field = isset($row['jsonld']) ? trim($row['jsonld']) : '';

$types = ["Article"]; // Always include Article

if ($type_field !== '') {
    $extra_types = array_map('trim', explode(',', $type_field));
    $types = array_values(array_unique(array_merge($types, $extra_types)));
}

?>
<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": <?php echo json_encode($types, JSON_UNESCAPED_SLASHES); ?>,
  "mainEntityOfPage": "<?php echo $currentUrl; ?>",
  "url": "<?php echo $currentUrl; ?>",
  "headline": "<?php echo htmlspecialchars($seo_title, ENT_QUOTES); ?>",
  "description": "<?php echo htmlspecialchars($seo_desc, ENT_QUOTES); ?>",
  "image": {
  "@type": "ImageObject",
  "url":  "<?php   echo $image; ?>"
  },
  "author": {
    "@type": "Person",
    "name": "<?php echo htmlspecialchars($row['author'], ENT_QUOTES); ?>",
    "url": "<?php 
    $author_slug = strtolower(str_replace(' ', '-', $row['author']));
    echo $protocol . $host . ($is_kovaiyellowpages ? '/' : '/blog/') . $author_slug;
?>"
  },
  "publisher": {
    "@type": "Organization",
    "name": "<?php echo $formatted_site_name; ?>",
    "logo": {
      "@type": "ImageObject",
      "url": "<?php echo $protocol . $host . dirname($_SERVER['REQUEST_URI']); ?>/blogadmin/logo.jpg"
    }
  },
  "datePublished": "<?php $date = new DateTime($row['date']); echo $date->format(DateTime::ATOM); ?>",
  "dateModified": "<?php $date = new DateTime($row['datemodified']); echo $date->format(DateTime::ATOM); ?>"
}
</script>
<?php
 

// --- YouTube Schema ---
if (!empty($row['youtubelink'])) {
  $videoId = trim($row['youtubelink']);
  $apiKey = 'AIzaSyC7B47SElob56AqLdbnFvhogN9pmTe1pyI';
  include 'youtube_generator.php';
  include_once("database/db.php");//database config file
  generateVideoSchema($pdo_conn, $row, $apiKey, $protocol, $host);
}
// --- Optional FAQ Schema ---
if (!empty($row['faq'])) {
    include 'faq_generator.php';
    generateFAQ($row['faq']);
}

// --- Optional HowTo Schema ---

if (!empty($row['howto'])) {
    include 'howto_generator.php';
    echo generateHowTo($row['howto'], 10, $row['title']);
}
?>


<?php

$category_data = mysqli_query(
    $GLOBALS["___mysqli_ston"],
    "SELECT slug, name FROM blog_categories WHERE id = " . (int)$row['category'] . " LIMIT 1"
);

if ($category_data && mysqli_num_rows($category_data) > 0) {
    $cat = mysqli_fetch_assoc($category_data);
    $category_name = $cat['slug'];   // slug
    $category = $cat['name'];        // name
} else {
    $category_name = 'general';
    $category = 'General';
}


    // build slugs safely (simple slugify - lower, spaces -> hyphen, remove non-alnum/hyphen)
    function slugify($s){
        $s = strtolower(trim($s));
        $s = preg_replace('/\s+/', '-', $s);
        $s = preg_replace('/[^a-z0-9\-]/', '', $s);
        $s = preg_replace('/-+/', '-', $s);
        return $s;
    }

    $base_url = ( (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') || $_SERVER['SERVER_PORT']==443 ) ? 'https://' . $_SERVER['HTTP_HOST'] . '/' : 'http://' . $_SERVER['HTTP_HOST'] . '/';
    // if you prefer hard-coded base URL, replace above with: $base_url = 'https://sitharsastrology.com/';

 

$categoryPrefix = $is_kovaiyellowpages ? '/' : '/blog/';

// Build breadcrumb items
$items = [];

// Home
$items[] = [
    "@type" => "ListItem",
    "position" => 1,
    "item" => [
        "@id"  => rtrim($base_url, '/') . '/',
        "name" => "Home"
    ]
];

// Category (only if available)
if (!empty($category_name)) {
    $items[] = [
        "@type" => "ListItem",
        "position" => 2,
        "item" => [
            "@id"  => rtrim($base_url, '/') . $categoryPrefix . 'category/' . slugify($category_name),
            "name" => $category
        ]
    ];
}

// Current page (canonical)
$canonicalUrl = strtok($currentUrl, '?#');
$items[] = [
    "@type" => "ListItem",
    "position" => count($items) + 1,
    "item" => [
        "@id"  => $canonicalUrl,
        "name" => $row['title']
    ]
];

$breadcrumb = [
    "@context" => "https://schema.org",
    "@type" => "BreadcrumbList",
    "name" => "Breadcrumbs",
    "itemListElement" => $items
];
?>

<script type="application/ld+json">
<?= json_encode($breadcrumb, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES); ?>
</script>

 

		<!-- dss added -->
	
<!-- Schema.org markup for Google+ -->
<meta itemprop="name" content="<?php echo $seo_title;  // getwebname("titles"); ?>"> 
<meta itemprop="description" content="<?php echo $seo_desc; ?>">
<meta itemprop="image" content="<?php echo $image; ?>">

<!-- Twitter Card data -->
<meta name="twitter:card" content="summary_large_image">
<meta name="twitter:site" content="@publisher_handle">
<meta name="twitter:title" content="<?php echo $seo_title;  ?>">
<meta name="twitter:description" content="<?php echo $seo_desc; ?>">
<!-- Twitter summary card with large image must be at least 280x150px -->
<meta name="twitter:image:src" content="<?php echo $image; ?>">

<!-- Open Graph data -->
<meta property="og:title" content="<?php echo $seo_title;  ?>" />
<meta property="og:type" content="article" />
<meta property="og:url" content="<?php echo $currentUrl;?>" />
<meta property="og:image" content="<?php echo $image; ?>" />
<meta property="og:description" content="<?php echo $seo_desc; ?>" />
<meta property="og:site_name" content="<?php getwebname("titles"); ?>" />
	
		<!-- end of dss added -->
	<script>
		addEventListener("load", function () {
			setTimeout(hideURLbar, 0);
		}, false);

		function hideURLbar() {
			window.scrollTo(0, 1);
		}
	</script>
	<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
	<link rel="stylesheet" href="css/single.css">
	<link href="css/style.css" rel='stylesheet' type='text/css' />
	<link href="css/fontawesome-all.css" rel="stylesheet">
	<link href="//fonts.googleapis.com/css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800"
	rel="stylesheet">
	<!--additional javascripts will be placed here-->
	<?php getjavascripts("links"); ?>
	<?php  if (!empty($row['appendhead'])) {
    echo $row['appendhead']; // extra content only if it exists
} ?>
</head>

<body>
	<!--Header-->
	<?php include("header.php");?> 
	<!--//header-->
	<!--update database on page views-->
	<?php  require_once('adminstats/conn.php');
	require_once('counter.php');
	$pn=updateCounter(''.$row['title'].''); // Updates page hits
	echo $pn;
	updateInfo(); // Updates hit info ?>
	<div class="banner-inner">
	</div>
	<ol class="breadcrumb">
  <li class="breadcrumb-item">
    <a href="<?php echo rtrim($base_url, '/') . '/'?>">Home</a>
  </li>
  <li class="breadcrumb-item">
    <a href="<?php echo rtrim($base_url, '/') . $categoryPrefix . 'category/' . slugify($category_name)?>"><?php echo $category;?></a>
  </li>
  <li class="breadcrumb-item active">
    <?php echo $row['title']; ?>
  </li>
</ol>


	<!--//banner-->
	<section class="banner-bottom">
		<!--/blog-->
		<div class="container">
			<div class="row">
				<!--left-->
				<div class="col-lg-8 left-blog-info-w3layouts-agileits text-left">
					<div class="blog-grid-top">
						<div class="b-grid-top">
							<div class="blog_info_left_grid">
								
								<?php if (!empty($row['youtubelink'])) { ?>
								<iframe frameborder="0" height="315" src="<?php echo 'https://www.youtube.com/embed/'.$row['youtubelink']; ?>" title="YouTube video player" width="100%"></iframe>
								<?php } else { ?>
								<a href="#">
									<img src="<?php echo $image; ?>" class="img-fluid" alt="<?php echo getAltTag($row['title']); ?>" style="width:900px;height:300px">
								</a>
								<?php } ?>
							</div>
							<div class="blog-info-middle">
								<ul>
									<li>
										<a href="#">
											<i class="far fa-calendar-alt"></i><?php echo $row['date']; ?></a>
										</li>
										<li class="mx-2">
											<a href="#">
												<i class="far fa-user"></i><?php echo $row['author']; ?></a>
											</li>
											<li>
												<a href="#">
													<i class="far fa-tags"></i> <?php //echo generateindividualtags($row['tags']); //echo $row['tags']; ?></a>
												</li>
												<li>
													<a href="#">
														<i class="far fa-eye fa-x2"></i> <?php echo $roo['count']; ?></a>
													</li>

												</ul>
											</div>
										</div>

										<h1>
											<a href="<?php echo $currentUrl; ?>"><?php echo $row['title']; ?></a>
										</h1>
										<!--sharing script-->
										<?php getsharingscript("links"); ?>
										<?php echo $row['content']; 
										if (!empty($row['faq'])) {
    $lines = preg_split("/\r\n|\n|\r/", trim($row['faq']));
//echo '<section class="faq-section">';
echo('<hr />');
    echo '<h2><b>Frequently Asked Questions (FAQ)</b></h2>';
    foreach ($lines as $line) {  // ✅ This line
        if (strpos($line, '|') !== false) {
            list($q_part, $a_part) = explode('|', $line, 2);
            $question = trim(preg_replace('/^Q:\s*/i', '', $q_part));
            $answer   = trim(preg_replace('/^A:\s*/i', '', $a_part));
echo            '<div>';
                echo '<h3><b>'.htmlspecialchars($question, ENT_QUOTES).'</b></h3>';
                echo '<p>' . nl2br(strip_tags($answer, '<b><i><u><a>')) . '</p>';
            echo '</div>';
        }
    }
//	echo('<hr />');
//echo '</section>';
}

if (!empty($row['howto'])) {
    $lines = preg_split("/\r\n|\n|\r/", trim($row['howto']));
	echo('<hr />');
    echo '<h2><b>How To?</b></h2>';

    foreach ($lines as $line) {
        if (strpos($line, '|') !== false) {
            list($title_part, $desc_part) = explode('|', $line, 2);
            $step_title = trim(preg_replace('/^Step:\s*/i', '', $title_part));
            $step_desc  = trim($desc_part);

            echo '<div>';
            echo '<h3><b>' . htmlspecialchars($step_title, ENT_QUOTES) . '</b></h3>';
            echo '<p>' . nl2br(strip_tags($step_desc, ENT_QUOTES)) . '</p>';
            echo '</div>';
        }
    }
	echo('<hr />');
}


										
										if (!empty($row['appendbody'])) {
    echo '</br>'.$row['appendbody']; // extra content only if it exists
}
										echo '</br></br>Similar Posts : '.generatesimilarposts($row['tags'],5).'</br></br>'; 
										
										
										
										echo 'See Also:'.str_replace(['<li>', '</li>'], '',generateindividualtags($row['tags'])); ?>
										
									</div>
									<!--comments script will go here-->
									<?php // getcommentsscript("links"); ?>
								</div>

								<!--//left-->
								<!--right-->
								<aside class="col-lg-4 agileits-w3ls-right-blog-con text-right">
									<div class="right-blog-info text-left">
										<h4><strong>Categories</strong></h4>
										<ul class="list-group single">
											<?php countcategories();?>
										</ul>
										<div class="tech-btm widget_social">
											<h4>Stay Connected</h4>
											<ul>

												<li>
													<a class="twitter" href="<?php getlinks("links","twitter");?>">
														<i class="fab fa-twitter"></i>
														<span class="count"></span> Twitter</a>
													</li>
													<li>
														<a class="facebook" href="<?php getlinks("links","facebook");?>">
															<i class="fab fa-facebook-f"></i>
															<span class="count"></span> Facebook</a>
														</li>
														<li>
															<a class="dribble" href="<?php getlinks("links","dribble");?>">
																<i class="fab fa-dribbble"></i>

																<span class="count"></span> Dribble</a>
															</li>
															<li>
																<a class="pin" href="<?php getlinks("links","pinterest");?>">
																	<i class="fab fa-pinterest"></i>
																	<span class="count"></span> Pinterest</a>
																</li>

															</ul>
														</div>
														<div class="tech-btm">
															<h4>Editor's Choice</h4>
															<?php geteditorschoice("editors_choice"); ?>
															<?php if (strpos(strtolower($currentUrl), 'sithars') !== false) { ?>
															</br>
															<div class="col-md-15 blog-grid-left">
															<center><b>If you like us, Please Contribute</b></center>
															<a href="/blog/blogadmin/images/shasunder-pay-link.png" target="_blank" rel="noopener">
															  <img src="/blog/blogadmin/images/shasunder-pay-link.png"
																   class="img-fluid"
																   alt="Donate via Google Pay – QR Code for <?php echo $domain; ?>"
																   title="Donate via Google Pay – SitharsAstrology.com"
																   width="250" height="250">
															</a>
<center><b>Scan this QR code to support <strong><?php echo $domain; ?></strong>.</b></center>

														</div>
															<?php } ?>
															<!--olderpostsendhere-->
														</div>
													</div>
												</aside>
												<!--//right-->
											</div>
										</div>
									</section>
									<!--//main-->
									<!--footer-->
									<?php include("footer.php");?>
									<!---->
									<!-- js -->
									<script src="js/jquery-2.2.3.min.js"></script>
									<!-- //js -->
									<!--/ start-smoth-scrolling -->
									<script src="js/move-top.js"></script>
									<script src="js/easing.js"></script>
									<script>
										jQuery(document).ready(function ($) {
											$(".scroll").click(function (event) {
												event.preventDefault();
												$('html,body').animate({
													scrollTop: $(this.hash).offset().top
												}, 900);
											});
										});
									</script>
									<!--// end-smoth-scrolling -->

									<script>
										$(document).ready(function () {
			/*
									var defaults = {
							  			containerID: 'toTop', // fading element id
										containerHoverID: 'toTopHover', // fading element hover id
										scrollSpeed: 1200,
										easingType: 'linear' 
							 		};
							 		*/

							 		$().UItoTop({
							 			easingType: 'easeOutQuart'
							 		});

							 	});
							 </script>
							 <a href="#home" class="scroll" id="toTop" style="display: block;">
							 	<span id="toTopHover" style="opacity: 1;"> </span>
							 </a>

							 <!-- //Custom-JavaScript-File-Links -->
							 <script src="js/bootstrap.js"></script>




							</body>

							</html>