One Hat Cyber Team

Edit File: blog-details.php

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$servername = "localhost";
$username = "u322583024_pkpanda";
$password = "PKpandit@2025";
$dbname = "u322583024_pkpanda";

// Establish database connection
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

ini_set('display_errors', 1); // Enable error display
error_reporting(E_ALL); // Report all errors

// Get the current URL path
$currentUrlPath = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH);
$customPath = basename($currentUrlPath);
$decodedPath = urldecode($customPath);
$decodedName = str_replace('-', ' ', pathinfo($decodedPath, PATHINFO_FILENAME)); // Removes extensions

// Default values to avoid errors
$blog_name = "Blog Not Found";
$blog_description = "Description not available.";
$image = "default.jpg";
$meta_tittle = "";
$meta_keywords = "";
$meta_description = "";
$formatted_date = "N/A";
$url_slug = "";

// Prepare and execute SQL statement
$stmt = $conn->prepare("SELECT * FROM `blog` WHERE REPLACE(url_name, ' ', '-') = ?");
if (!$stmt) {
    die("SQL Error: " . $conn->error);
}

$stmt->bind_param("s", $decodedName);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $blog_name = $row['blog_name'] ?? $blog_name;
    $blog_description = $row['blog_description'] ?? $blog_description;
    $image = $row['image'] ?? $image;
    $meta_tittle = $row['meta_tittle'] ?? $meta_tittle;
    $meta_keywords = $row['meta_keywords'] ?? $meta_keywords;
    $meta_description = $row['meta_description'] ?? $meta_description;
    $formatted_date = isset($row['created_at']) ? date("M d, Y", strtotime($row['created_at'])) : $formatted_date;
    $url_slug = str_replace(' ', '-', strtolower($row['url_name'] ?? ''));
} else {
    echo "<p style='color: red;'>No blog found for: " . htmlspecialchars($decodedName) . "</p>";
}

$stmt->close();
$conn->close();
?>

<!DOCTYPE html>




<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>Blog Single</title>
    <meta content="width=device-width, initial-scale=1.0" name="viewport" />
    <meta name="description" content="Horoscope" />
    <meta name="keywords" content="Horoscope" />
    <meta name="author" content="" />
    <meta name="MobileOptimized" content="320" />
    
    <link rel="stylesheet" type="text/css" href="../css/animate.css" />
    <link rel="stylesheet" type="text/css" href="../css/bootstrap.css" />
    <link rel="stylesheet" type="text/css" href="../css/font-awesome.css" />
    <link rel="stylesheet" type="text/css" href="../css/fonts.css" />
    <link rel="stylesheet" type="text/css" href="../css/flaticon.css" />
    <link rel="stylesheet" type="text/css" href="../css/owl.carousel.css" />
    <link rel="stylesheet" type="text/css" href="../css/owl.theme.default.css" />
    <link rel="stylesheet" type="text/css" href="../css/magnific-popup.css" />
    <link rel="stylesheet" type="text/css" href="../css/reset.css" />
    <link rel="stylesheet" type="text/css" href="../css/style2.css" />
    <link rel="stylesheet" type="text/css" href="../css/responsive.css" />
    
    <link rel="shortcut icon" type="image/png" href="../images/header/favicon.ico" />
</head>

<body>
    
    <div id="preloader">
        <div id="status"><img src="../images/header/horoscope.gif" id="preloader_image" alt="loader">
        </div>
    </div>
	
			<?php

include 'header.php';

?>
	
    
    <div class="hs_indx_title_main_wrapper">
        <div class="hs_title_img_overlay"></div>
        <div class="container">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 full_width">
                    <div class="hs_indx_title_left_wrapper">
                        <h2>Blog Single</h2>
                    </div>
                </div>
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12  full_width">
                    <div class="hs_indx_title_right_wrapper">
                        <ul>
                            <li><a href="#">Home</a> &nbsp;&nbsp;&nbsp;> </li>
                            <li>Blog Single</li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    
    <div class="hs_blog_categories_main_wrapper">
        <div class="container">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="hs_blog_left_sidebar_main_wrapper">
                        <div class="row">
                            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                                <div class="hs_blog_box1_main_wrapper">
                                    <div class="hs_blog_box1_img_wrapper">
                                        <img src="images/content/blog/bc1.jpg" alt="blog_img">
                                        <ul>
											<li><?php echo $formatted_date; ?></li>
										</ul>
                                    </div>
                                    <div class="hs_blog_box1_cont_main_wrapper">
									
                                        <div class="hs_blog_cont_heading_wrapper">
                                     <h2><?php echo $blog_name; ?></h2>
                                            <h4><span>&nbsp;</span></h4>
                                            <p><?php echo $blog_description?></p>

</div>
                                        
                                    </div>
                                </div>
                            </div>
                           
                     
                      
                           
                        </div>
                    </div>
                </div>
           
            </div>
        </div>
    </div>

<?php
include 'footer.php';

?>
    
    
    <script src="../js/jquery_min.js"></script>
    <script src="../js/bootstrap.js"></script>
    <script src="../js/modernizr.js"></script>
    <script src="../js/jquery.menu-aim.js"></script>
    <script src="../js/parallax.min.js"></script>
	<script src="../js/owl.carousel.js"></script>
	
    <script src="../js/datepicker.js"></script>
    <script src="../js/jquery.shuffle.min.js"></script>
    <script src="../js/jquery.countTo.js"></script>
    <script src="../js/jquery.inview.min.js"></script>
    <script src="../js/jquery.magnific-popup.js"></script>
    <script src="../js/custom.js"></script>
    
</body>

</html>