<?php require_once('Connections/Database.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_Blog = 5;
$pageNum_Blog = 0;
if (isset($_GET['pageNum_Blog'])) {
$pageNum_Blog = $_GET['pageNum_Blog'];
}
$startRow_Blog = $pageNum_Blog * $maxRows_Blog;
mysql_select_db($database_Database, $Database);
$query_Blog = "SELECT * FROM blog ORDER BY uid DESC";
$query_limit_Blog = sprintf("%s LIMIT %d, %d", $query_Blog, $startRow_Blog, $maxRows_Blog);
$Blog = mysql_query($query_limit_Blog, $Database) or die(mysql_error());
$row_Blog = mysql_fetch_assoc($Blog);
if (isset($_GET['totalRows_Blog'])) {
$totalRows_Blog = $_GET['totalRows_Blog'];
} else {
$all_Blog = mysql_query($query_Blog);
$totalRows_Blog = mysql_num_rows($all_Blog);
}
$totalPages_Blog = ceil($totalRows_Blog/$maxRows_Blog)-1;
$queryString_Blog = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Blog") == false &&
stristr($param, "totalRows_Blog") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Blog = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Blog = sprintf("&totalRows_Blog=%d%s", $totalRows_Blog, $queryString_Blog);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 12px}
-->
</style>
</head>
<body>
<table align="center" width="400">
<tr>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, 0, $queryString_Blog); ?>">First</a></div></td>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, max(0, $pageNum_Blog - 1), $queryString_Blog); ?>">Previous</a></div></td>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, min($totalPages_Blog, $pageNum_Blog + 1), $queryString_Blog); ?>">Next</a></div></td>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, $totalPages_Blog, $queryString_Blog); ?>">Last</a></div></td>
</tr></table><br><hr>
<?php do { ?>
<table width="650" align="center">
<tr>
<td width="500"><strong><?php echo $row_Blog['title']; ?></strong></td>
<td><div align="right"><?php echo $row_Blog['timestamp']; ?></div></td>
</tr>
<tr>
<td colspan="2"><?php echo $row_Blog['text']; ?></td>
</tr>
<td>
<?php
$uid = $row_Blog['uid']
$query = mysql_query("SELECT COUNT(*) FROM blogcomments WHERE bid = $uid", $Database) or die(mysql_error());
$CRows = mysql_num_rows($query);
?>
<span class="style1">(<?php echo $CRows ?>) Comments - Click <a href="index.php?page=blog2&post=<?php echo $row_Blog['uid']; ?>">Here</a> To View Comments</span></td>
<td><div align="right" class="style1">Add Comment</div></td>
</tr>
<tr><td colspan="2"><hr></td></tr>
</table>
<?php } while ($row_Blog = mysql_fetch_assoc($Blog)); ?>
<table align="center" width="400">
<tr>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, 0, $queryString_Blog); ?>">First</a></div></td>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, max(0, $pageNum_Blog - 1), $queryString_Blog); ?>">Previous</a></div></td>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, min($totalPages_Blog, $pageNum_Blog + 1), $queryString_Blog); ?>">Next</a></div></td>
<td width="100"><div align="center"><a href="<?php printf("%s?pageNum_Blog=%d%s", $currentPage, $totalPages_Blog, $queryString_Blog); ?>">Last</a></div></td>
</tr></table>
</body>
</html>
<?php
mysql_free_result($Blog);
?>