post.php

<?php include 'inc/header.php' ?>

<?php 
$postid = mysqli_real_escape_string($db->link, $_GET['id']);
if (!isset($postid) || $postid == null) {
    header("Location:404.php");
} else {
    $id = $postid;
}

 ?>

	<div class="contentsection contemplete clear">
		<div class="maincontent clear">
			<div class="about">

				<?php 

                $query = "SELECT * FROM tbl_post WHERE id=$id";
                $post = $db->select($query);
                if ($post) {
                    while ($result = $post->fetch_assoc()) {
                        ?>

				<h2><?php echo $result['tittle']; ?></h2>
				<h4><?php echo $fm->formatDate($result['date']); ?>, By <a href="#"><?php echo $result['author']; ?></a></h4>
				<img src="admin/<?php echo $result['image']; ?>" alt="post image"/>
				<?php echo $result['body']; ?>
		
						
	
				
				
				<div class="relatedpost clear">
					<h2>Related articles</h2>
					<?php 

                    $catid= $result['cat'];
                        $queryrelated = "SELECT * FROM tbl_post WHERE cat='$catid' ORDER BY rand() LIMIT 6";
                        $relatedpost = $db->select($queryrelated);
                        if ($relatedpost) {
                            while ($rresult = $relatedpost->fetch_assoc()) {
                                ?>
					<a href="post.php?id=<?php echo $rresult['id']; ?>">
						<img src="admin/<?php echo $rresult['image'] ?>" alt="post image"/></a>
					<?php
                            }
                        } else {
                            echo "No Related Post Available";
                        } ?>					
				</div>

				<?php
                    }
                } else {
                    header("Location:404.php");
                } ?>
	</div>

		</div>
		   <?php include 'inc/sidebar.php'; ?>
    <?php include 'inc/footer.php'; ?>