<?php
define(&#039;IN_VALID&#039;, true);
include ("include/header.php");
include ("modules/login.php");
include ("modules/stats.php");
echo (&#039;
<div id="rightbar">
<center><a href="addnote.php">Добави Бележка</a></center>
<table width="97%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="border1" valign="top">&#039;);
//$ns - номер страница
//$br - брой страница
//$one - първа
//$sl - следваща
//$pl - последна
//$pr - предишна
$br = 15;
$pageNum = 1;
if(isset($_GET[&#039;page&#039;])) {
$pageNum = $_GET[&#039;page&#039;];
}
$redove = ($pageNum - 1) * $br;
$query = " SELECT * FROM notes "." LIMIT $redove, $br";
$result = mysql_query($query) or die(&#039;Не си избрал страница!&#039;);
echo &#039;
<table border="1" width="100%" style="border: 1px solid #c0c0c0;border-collapse:collapse;" align="center">
<tr><td align="center"><b>Име</b></td><td align="center"><b>Създадена на</b></td></tr>
&#039;;
while($row = mysql_fetch_array($result)) {
echo (&#039;
<tr>
<td>
<a href="read_note.php?id=&#039;.$row[&#039;note_id&#039;].&#039;">&#039;.$row[&#039;note_title&#039;].&#039;</a>/<a href="edit_note.php?id=&#039;.$row[&#039;note_id&#039;].&#039;">Редактирай</a>
</td>
<td align="center">&#039;.$row[&#039;note_create&#039;].&#039;</td>
&#039;);
}
echo ("</tr>
</table>
<br /><center>");
$query = "SELECT COUNT(note_id) AS numrows FROM notes";
$result = mysql_query($query) or die(&#039;Не си избрал страница!&#039;);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row[&#039;numrows&#039;];
$maxPage = ceil($numrows/$br);
$self = $_SERVER[&#039;PHP_SELF&#039;];
$ns = &#039;&#039;;
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $pageNum) {
$ns .= " $page ";
}
else {
$ns .= " <a href=\"$self?page=$page\">$page</a> ";
}}
if ($pageNum > 1) {
$page = $pageNum - 1;
$pr = " <a href=\"$self?page=$page\"> [<] </a> ";
$one = " <a href=\"$self?page=1\">[първа]</a> ";
}
else {
$pr = &#039; &#039;;
$one = &#039; &#039;;
}
if ($pageNum < $maxPage) {
$page = $pageNum + 1;
$sl = (" <a href=\"$self?page=$page\"> [>] </a> ");
$pl = (" <a href=\"$self?page=$maxPage\">[последна]</a> ");
}
else {
$sl = &#039;&#039;;
$pl = &#039;&#039;;
}
echo $one . $pr . $ns . $sl . $pl;
echo (&#039;
</center></td>
</tr>
</table></div>
<div id="footer">
&#039;.$footer.&#039;
</div>
</div>
</center>
</body>
</html>&#039;);
?>