I have a page displaying blog posts (latest_posts.php) and another page that display single blog posts (blog.php) . I intend to link the image title in latest_posts.php so that it redirects to blog.php where it would display the particular post that was clicked.
latest_posts.php:
<!-- Header -->
<h2 class="underline">
<span>What's new</span>
<span></span>
</h2>
<!-- /Header -->
<!-- Posts list -->
<ul class="post-list post-list-1">
<?php
/* Fetches Date/Time, Post Content and title */
include 'dbconnect.php';
$sql = "SELECT * FROM wp_posts";
$res = mysql_query($sql);
while ( $row = mysql_fetch_array($res) ) {
?>
<!-- Post #1 -->
<li class="clear-fix">
<!-- Date -->
<div class="post-list-date">
<div class="post-date-box">
<?php
//Timestamp broken
down to show accordingly
$timestamp = $row['post_date'];
$datetime = new DateTime($timestamp);
$date = $datetime->format("d");
$month = $datetime->format("M");
?>
<h3> <?php echo $date; ?> </h3>
<span> <?php echo $month; ?> </span>
</div>
</div>
<!-- /Date -->
<!-- Image + comments count -->
<div class="post-list-image">
<!-- Image -->
<div class="image image-overlay-url image-fancybox-url">
<a href="post.php" class="preloader-image">
<?php
echo '<img src="', $row['image'], '" alt="' , $row['post_title'] , '\'s Blog Image" />';
?>
</a>
</div>
<!-- /Image -->
</div>
<!-- /Image + comments count -->
<!-- Content -->
<div class="post-list-content">
<div>
<!-- Header -->
<h4> <a href="post.php? . $row['ID'] . "> <?php echo $row['post_title']; ?> </a> </h4>
<!-- /Header -->
<!-- Excerpt -->
<p>
<?php echo $row ['post_content']; }?>
</p>
<!-- /Excerpt -->
</div>
</div>
<!-- /Content -->
</li>
<!-- /Post #1 -->
</ul>
<!-- /Posts list -->
<a href="blog.php" class="button-browse">Browse All Posts</a>
</div>
<?php require_once('include/twitter_user_timeline.php'); ?>
blog.php:
<?php require_once('include/header.php'); ?>
<body class="blog">
<?php require_once('include/navigation_bar_blog.php'); ?>
<div class="blog">
<div class="main">
<!-- Header -->
<h2 class="underline">
<span>What's new</span>
<span></span>
</h2>
<!-- /Header -->
<!-- Layout 66x33 -->
<div class="layout-p-66x33 clear-fix">
<!-- Left column -->
<!-- <div class="column-left"> -->
<!-- Posts list -->
<ul class="post-list post-list-2">
<?php
/* Fetches Date/Time, Post Content and title with Pagination */
include 'dbconnect.php';
//sets to default page
if(empty($_GET['pn'])){
$page=1;
} else {
$page = $_GET['pn'];
}
// Index of the page
$index = ($page-1)*3;
$sql = "SELECT * FROM `wp_posts` ORDER BY `post_date` DESC LIMIT " . $index . " ,3";
$res = mysql_query($sql);
//Loops through the values
while ( $row = mysql_fetch_array($res) ) {
?>
<!-- Post #1 -->
<li class="clear-fix">
<!-- Date -->
<div class="post-list-date">
<div class="post-date-box">
<?php
//Timestamp broken
down to show accordingly
$timestamp = $row['post_date'];
$datetime = new DateTime($timestamp);
$date = $datetime->format("d");
$month = $datetime->format("M");
?>
<h3> <?php echo $date; ?> </h3>
<span> <?php echo $month; ?> </span>
</div>
</div>
<!-- /Date -->
<!-- Image + comments count -->
<div class="post-list-image">
<!-- Image -->
<div class="image image-overlay-url image-fancybox-url">
<a href="post.php" class="preloader-image">
<?php echo '<img src="', $row['image'], '" alt="' , $row['post_title'] , '\'s Blog Image" />'; ?>
</a>
</div>
<!-- /Image -->
</div>
<!-- /Image + comments count -->
<!-- Content -->
<div class="post-list-content">
<div>
<?php
$id = $_GET['ID'];
$post = lookup_post_somehow($id);
if($post) {
// render post
} else {
echo 'blog post not found..';
}
?>
<!-- Header -->
<h4> <a href="post.php"> <?php echo $row['post_title']; ?> </a> </h4>
<!-- /Header -->
<!-- Excerpt -->
<p> <?php echo $row ['post_content']; ?> </p>
<!-- /Excerpt -->
</div>
</div>
<!-- /Content -->
</li>
<!-- /Post #1 -->
<?php } // close while loop ?>
</ul>
<!-- /Posts list -->
<div><!-- Pagination -->
<ul class="blog-pagination clear-fix">
<?php
//Count the number of rows
$numberofrows = mysql_query("SELECT COUNT(ID) FROM `wp_posts`");
//Do ciel() to round the result according to number of posts
$postsperpage = 4;
$numOfPages = ceil($numberofrows / $postsperpage);
for($i=1; $i < $numOfPages; $i++) {
//echos links for each page
$paginationDisplay = '<li><a href="blog.php?pn=' . $i . '">' . $i . '</a></li>';
echo $paginationDisplay;
}
?>
<!--
<li><a href="#" class="selected">1</a></li>
<li><a href="#">2</a></li>
<li><a href="#">3</a></li>
<li><a href="#">4</a></li>
-->
</ul>
</div><!-- /Pagination -->
<!-- /div> -->
<!-- Left column -->
</div>
<!-- /Layout 66x33 -->
</div>
</div>
<?php require_once('include/twitter_user_timeline.php'); ?>
<?php require_once('include/footer_blog.php'); ?>
How do I render?
