<?php require_once('Connections/connect_db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
mysql_select_db($database_connect_db, $connect_db);
$query_config = "SELECT * FROM config_setings";
$config = mysql_query($query_config, $connect_db) or die(mysql_error());
$row_config = mysql_fetch_assoc($config);
$totalRows_config = mysql_num_rows($config);
mysql_select_db($database_connect_db, $connect_db);
$query_category_list = "SELECT id, category_name FROM categories WHERE visible = 1";
$category_list = mysql_query($query_category_list, $connect_db) or die(mysql_error());
$row_category_list = mysql_fetch_assoc($category_list);
$totalRows_category_list = mysql_num_rows($category_list);
$maxRows_AllCategoryList = $row_config['site_num_news'];
$pageNum_AllCategoryList = 0;
if (isset($_GET['pageNum_AllCategoryList'])) {
$pageNum_AllCategoryList = $_GET['pageNum_AllCategoryList'];
}
$startRow_AllCategoryList = $pageNum_AllCategoryList * $maxRows_AllCategoryList;
mysql_select_db($database_connect_db, $connect_db);
$query_AllCategoryList = "SELECT id, title, `date`, `description` FROM post ORDER BY id DESC";
$query_limit_AllCategoryList = sprintf("%s LIMIT %d, %d", $query_AllCategoryList, $startRow_AllCategoryList, $maxRows_AllCategoryList);
$AllCategoryList = mysql_query($query_limit_AllCategoryList, $connect_db) or die(mysql_error());
$row_AllCategoryList = mysql_fetch_assoc($AllCategoryList);
if (isset($_GET['totalRows_AllCategoryList'])) {
$totalRows_AllCategoryList = $_GET['totalRows_AllCategoryList'];
} else {
$all_AllCategoryList = mysql_query($query_AllCategoryList);
$totalRows_AllCategoryList = mysql_num_rows($all_AllCategoryList);
}
$totalPages_AllCategoryList = ceil($totalRows_AllCategoryList/$maxRows_AllCategoryList)-1;
$queryString_AllCategoryList = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_AllCategoryList") == false &&
stristr($param, "totalRows_AllCategoryList") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_AllCategoryList = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_AllCategoryList = sprintf("&totalRows_AllCategoryList=%d%s", $totalRows_AllCategoryList, $queryString_AllCategoryList);
?>
<!doctype html>
<!--[if lt IE 7]> <html class="ie6 oldie"> <![endif]-->
<!--[if IE 7]> <html class="ie7 oldie"> <![endif]-->
<!--[if IE 8]> <html class="ie8 oldie"> <![endif]-->
<!--[if gt IE 8]><!-->
<html class="">
<!--<![endif]-->
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="keywords" content="<?php echo $row_config['site_keyword']; ?>">
<meta name="description" content="<?php echo $row_config['site_description']; ?>">
<title><?php echo $row_config['site_name']; ?></title>
<link href="boilerplate.css" rel="stylesheet" type="text/css">
<link href="style.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="kube.css">
<!--[if lt IE 9]>
<script src="//html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<script src="respond.min.js"></script>
</head>
<body>
<div class="gridContainer clearfix">
<div id="header">
<h1><?php echo $row_config['site_name']; ?></h1>
<p><?php echo $row_config['site_slogan']; ?></p>
</div>
<div id="sidebar">
<h3>навигация</h3>
<div class="nav">
<ul>
<li><a href="/">Главная</a></li>
<?php do { ?>
<li><a href="category.php?catid=<?php echo $row_category_list['id']; ?>"><?php echo $row_category_list['category_name']; ?></a></li>
<?php } while ($row_category_list = mysql_fetch_assoc($category_list)); ?>
</ul>
</div>
</div>
<div id="content">
<?php do { ?>
<div class="post">
<h2><a href="post.php?postid=<?php echo $row_AllCategoryList['id']; ?>"><?php echo $row_AllCategoryList['title']; ?></a></h2>
<div class="post-info"><span><strong>опубликовано: </strong><?php echo $row_AllCategoryList['date']; ?></span></div>
<p><?php echo $row_AllCategoryList['description']; ?></p>
<a href="post.php?postid=<?php echo $row_AllCategoryList['id']; ?>">читать дальше ››</a>
</div>
<hr>
<?php } while ($row_AllCategoryList = mysql_fetch_assoc($AllCategoryList)); ?>
<table border="0">
<tr>
<td><?php if ($pageNum_AllCategoryList > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_AllCategoryList=%d%s", $currentPage, 0, $queryString_AllCategoryList); ?>">Первый</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_AllCategoryList > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_AllCategoryList=%d%s", $currentPage, max(0, $pageNum_AllCategoryList - 1), $queryString_AllCategoryList); ?>">Вернуть</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_AllCategoryList < $totalPages_AllCategoryList) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_AllCategoryList=%d%s", $currentPage, min($totalPages_AllCategoryList, $pageNum_AllCategoryList + 1), $queryString_AllCategoryList); ?>">Далее</a>
<?php } // Show if not last page ?></td>
<td><?php if ($pageNum_AllCategoryList < $totalPages_AllCategoryList) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_AllCategoryList=%d%s", $currentPage, $totalPages_AllCategoryList, $queryString_AllCategoryList); ?>">Последний</a>
<?php } // Show if not last page ?></td>
</tr>
</table>
</div>
<div id="footer">(c)2012 все права защищены <a style="color:#FFF;" href="/"><?php echo $row_config['site_name']; ?></a></div>
</div>
</body>
</html>
<?php
mysql_free_result($config);
mysql_free_result($category_list);
mysql_free_result($AllCategoryList);
?>
обоим плюсы поставлю если смогу) за ваши советы, спасибо!)
Причем тут это? Ты не отличаешь абстрактные вещи от реальных?