Viewing file:  training-details.php (11.1 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
?>
<?php
include('admin/conn.php');
$settings = mysqli_query($con, "SELECT * FROM settings");
$setting = mysqli_fetch_array($settings);
$id = $_GET['id'];
$blog = mysqli_query($con, "SELECT * FROM blog where id=$id");
$blogg = mysqli_fetch_array($blog);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="keywords" content="Site keywords here">
<meta name="description" content="#">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title><?php echo $setting['site_name']; ?></title>
<link rel="icon" href="assets/img/favicon.png">
<link href="https://fonts.googleapis.com/css2?family=Barlow:ital,wght@0,400;0,500;0,600;0,700;0,900;1,500;1,700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="assets/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/css/cube-portfolio.min.css">
<link rel="stylesheet" href="assets/css/owl.carousel.min.css">
<link rel="stylesheet" href="assets/css/slicknav.min.css">
<link rel="stylesheet" href="assets/css/maginific-popup.min.css">
<link rel="stylesheet" href="assets/css/animate.min.css">
<link rel="stylesheet" href="assets/css/nice-select.css">
<link rel="stylesheet" href="assets/css/datepicker.css">
<link rel="stylesheet" href="assets/css/fontawesome.min.css">
<link rel="stylesheet" href="assets/css/icofont.css">
<link rel="stylesheet" href="assets/css/default.css">
<link rel="stylesheet" href="assets/css/style.css">
<link rel="stylesheet" href="assets/css/responsive.css">
</head>
<body>
<?php include('header.php'); ?>
<?php
$id = isset($_GET['id']) ? $_GET['id'] : '';
$_SESSION['id'] = $id;
if (!isset($_SESSION['views'])) {
$_SESSION['views'] = 1;
}
?>
<section class="blog-single-post section">
<div class="container">
<div class="row">
<div class="col-lg-10 offset-lg-1 col-12 wow fadeInUp" data-wow-delay="0.2s">
<div class="row">
<div class="col-12">
<div class="single-blog-area">
<div class="single-blog-head">
<div class="single-head-img">
<img src="admin/images/blog/<?php echo $blogg["img"]; ?>" alt="#">
</div>
<div class="blog-s-title">
<div class="blog-single-meta">
<!-- Blog date Area -->
<span><i class="far fa-calendar-alt"></i><?php echo $blogg["date"]; ?></span>
<!-- End Blog date Area -->
</div>
<!-- Blog Title Area -->
<h3><a href="#"><?php echo $blogg['title']; ?></a></h3>
</div>
<?php
include('admin/conn.php');
$id = $_GET['id'];
$query = "SELECT COUNT(*) as total_comments FROM comments WHERE blog_id = '$id'";
$result = mysqli_query($con, $query);
if ($result) {
$row = mysqli_fetch_assoc($result);
$totalComments = $row['total_comments'];
?>
<?php
include('admin/conn.php');
$id = $_GET['id'];
// Check if the user's session contains a flag for this blog post
if (!isset($_SESSION['viewed_'.$id])) {
// Increment the view count for the blog post
$query = "SELECT * FROM views WHERE id = $id";
$result = mysqli_query($con, $query);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$currentViews = $row['views_count'];
$newViews = $currentViews + 1;
$updateQuery = "UPDATE views SET views_count = $newViews WHERE id = $id";
mysqli_query($con, $updateQuery);
} else {
$insertQuery = "INSERT INTO views (id, views_count) VALUES ($id, 1)";
mysqli_query($con, $insertQuery);
}
// Set the flag in the user's session to indicate that the view count has been incremented for this blog post
$_SESSION['viewed_'.$id] = true;
}
?>
<!-- Blog description Area -->
<p><?php echo $blogg['descrip']; ?></p>
</div>
<!-- Blog sub title Area -->
<div class="single-content">
<blockquote>
<i class="far fa-quote-right"></i>
<p><?php echo $blogg['sub_title']; ?></p>
</blockquote>
<!-- End Blog sub title Area -->
<!-- sub image Area -->
<div class="col">
<div class="card">
<?php
$textt = $blogg['sub_image1'];
if (!empty($textt)) { ?>
<iframe width="auto" height="420" style="border-radius: 1.9%;" src="<?php echo $textt; ?>">
</iframe>
<?php } ?>
<div class="card-body">
<p class="card-text"><?php echo $blogg['sub_descrip']; ?></p>
</div>
</div>
</div>
<!-- End sub image Area -->
<!-- View and comment counter Area -->
<div class="blog-s-conunter">
<ul>
<?php
$V_id = $_GET['id'];
$v_q = mysqli_query($con,"SELECT * FROM views WHERE id = $V_id");
$v_r = mysqli_fetch_array($v_q);
?>
<li><i class="far fa-eye"></i>Views: <span><?php echo $v_r['views_count']; ?></span></li>
<li><i class="far fa-comments"></i>Comments: <span><?php echo $totalComments; ?></span></li>
</ul>
</div>
<!-- end View and comment counter Area -->
<!-- Blog Department Area -->
<div class="blog-post-tag">
<div class="row">
<div class="col-lg-8 col-md-6 col-12">
<div class="post-tag post-share-tag">
<h5>Department: </h5>
<ul>
<li><?php echo $blogg['blog_department']; ?></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<!-- End Blog Department Area -->
<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$name = mysqli_real_escape_string($con, $_POST['name']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$comment = mysqli_real_escape_string($con, $_POST['comment']);
$id = $_GET['id'];
$query = "INSERT INTO comments (name, email, comment, blog_id, created_at) VALUES ('$name', '$email', '$comment', '$id', NOW())";
mysqli_query($con, $query);
$name = "";
$email = "";
$comment = "";
echo '<script>alert("Your comment has been posted.");</script>';
echo '<script>window.location.href = window.location.href;</script>';
}
$id = $_GET['id'];
$query = "SELECT * FROM comments WHERE blog_id = '$id' ORDER BY created_at DESC";
$result = mysqli_query($con, $query);
$totalComments = mysqli_num_rows($result);
$displayedComments = 3;
?>
<!-- Comment Area -->
<div class="blog-comments">
<div class="comment-title">
<h3>Comments (<?php echo $totalComments; ?>)</h3>
</div>
<div class="comments-body">
<div class="single-comments">
<?php
if (mysqli_num_rows($result) > 0) {
$counter = 0;
while ($row = mysqli_fetch_assoc($result)) {
if ($counter < $displayedComments) { ?>
<div class="main">
<div class="head">
<img src="assets/img/login.png" style="height: 50px; width: 50px;" alt="#">
</div>
<div class="body">
<div class="body-top">
<h6><?php echo $row['name']; ?></h6>
<span class="date-meta"><?php echo $row['created_at'] ?></span>
</div>
<p><?php echo $row['comment'] ?></p>
</div>
</div>
<?php
$counter++;
} else {
?>
<div class="main additional-comment" style="display: none;">
<div class="head">
<img src="assets/img/login.png" style="height: 50px; width: 50px" alt="#">
</div>
<div class="body">
<div class="body-top">
<h6><?php echo $row['name']; ?></h6>
<span class="date-meta"><?php echo $row['created_at'] ?></span>
</div>
<p><?php echo $row['comment'] ?></p>
</div>
</div>
<?php
}
}
if ($totalComments > $displayedComments) { ?>
<a class="read-more-button">Read More</a>
<a class="read-less-button" style="display: none;">Read Less</a>
<?php
}
} else {
echo "<p>No comments yet!</p>";
}
}
?>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
$(".read-more-button").click(function() {
$(".additional-comment").show();
$(".read-less-button").show();
$(this).hide();
});
$(".read-less-button").click(function() {
$(".additional-comment").hide();
$(".read-more-button").show();
$(this).hide();
});
});
</script>
<!-- End Comment Area -->
<!-- beggining of comment form-->
<div class="post-comment">
<div class="comment-title">
<h3>Leave Your Comments</h3>
</div>
<?php if (isset($_SESSION['user_id'])) {?>
<form method="POST" action="<?php echo $_SERVER['PHP_SELF']."?id=".$id; ?>">
<div class="comment-form">
<div class="row">
<div class="col-lg-6 col-lg-6 col-12">
<div class="form-group">
<input type="text" name="name" id="name" placeholder="Your Name" required="required">
</div>
</div>
<div class="col-lg-6 col-lg-6 col-12">
<div class="form-group">
<input type="email" name="email" id="email" placeholder="Your Email" required="required">
</div>
</div>
<div class="col-12">
<div class="form-group">
<textarea name="comment" id="comment" placeholder="Your Comment" required="required"></textarea>
</div>
</div>
<div class="col-12">
<div class="post-comment-btn">
<button type="submit" value="Submit" class="theme-btn">Post Comment</button>
</div>
</div>
</div>
</div>
</form>
<?php }
else{?>
<a href="login">Login Here</a>
<?php
echo "Login First to leave a comment";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- End comment form -->
</section>
<!-- Footer Area -->
<?php include('footer.php'); ?>
<script data-cfasync="false" src="../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script><script src="assets/js/jquery-3.6.0.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/bootstrap-datepicker.js"></script>
<script src="assets/js/modernizer.min.js"></script>
<script src="assets/js/magnific-popup.min.js"></script>
<script src="assets/js/waypoints.min.js"></script>
<script src="assets/js/jquery.counterup.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/cube-portfolio.min.js"></script>
<script src="assets/js/nice-select.min.js"></script>
<script src="assets/js/wow.min.js"></script>
<script src="assets/js/jquery.slicknav.min.js"></script>
<script src="assets/js/steller.min.js"></script>
<script src="assets/js/easing.min.js"></script>
<script src="assets/js/jquery.scrollUp.min.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>
|