<?php
$local = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "test";
$c = mysql_connect($local,$db_user,$db_pass) or die ("MySQL KLAIDA!");
mysql_select_db($db_name,$c) or die ("MySQL duomenu bazes!");
$eiluciu_psl = 2; // kiek naujienu parodyti puslapyje
$psl_num = 1; // skaiciavimas prasideda nuo pirmo puslapio
if (isset($_GET['puslapis']))
{
$psl_num = $_GET['puslapis'];
}
$offset = ($psl_num-1)* $eiluciu_psl;
$query = "SELECT * FROM news LIMIT $offset,$eiluciu_psl";
$result = mysql_query($query) or die (mysql_error());
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<link rel="stylesheet" href="pagination.css" type="text/css">
<meta http-equiv="Expires" content="Fri, Jan 01 1900 00:00:00 GMT">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="content-language" content="en">
<meta name="author" content="">
<meta http-equiv="Reply-to" content="@.com">
<meta name="generator" content="PhpED 5.2">
<meta name="description" content="">
<meta name="keywords" content="">
<meta name="creation-date" content="09/20/2007">
<meta name="revisit-after" content="15 days">
<title>Untitled</title>
<link rel="stylesheet" type="text/css" href="my.css">
</head>
<body>
<?php
while ($eilute = mysql_fetch_array($result))
{
echo $eilute['autorius'] .'<br>';
echo $eilute['tema'] .'<br>';
echo $eilute['tekstas'] .'<br><br>';
}
$query_count = "SELECT COUNT(id) AS numrows FROM news";
$result_count = mysql_query($query_count) or die (mysql_error());
$row = mysql_fetch_array($result_count,MYSQL_ASSOC);
$numrows = $row['numrows'];
$max_psl = ceil($numrows/$eiluciu_psl);
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($puslapis = 1; $puslapis <= $max_psl; $puslapis++)
{
if ($puslapis == $psl_num)
{
$nav .= " $puslapis "; // nereikia kurti puslapio kiekvienam
}
else
{
$nav .= " <a href=\"$self?puslapis=$puslapis\">$puslapis</a> ";
}
}
if ($psl_num > 1)
{
$puslapis = $psl_num - 1;
$prev = " <a href=\"$self?puslapis=$puslapis\" class=\"prevnext\">« Ankstesnis</a> ";
$first = " <a href=\"$self?puslapis=1\" class=\"currentpage\">1</a> ";
}
else
{
$prev = ' '; // pirmame puslapyje nerodyti ankstesnio puslapio
$first = ' '; // taip pat, nerodyti pirmo puslapio
}
if ($psl_num < $max_psl)
{
$puslapis = $psl_num + 1;
$next = " <a href=\"$self?puslapis=$puslapis\" class=\"prevnext\">Kitas »</a> ";
$last = " <a href=\"$self?puslapis=$max_psl\" class=\"currentpage\">$max_psl</a> ";
}
else
{
$next = ' '; // paskutiniame puslapyje, nerodyti nieko
$last = ' '; // taip pat, nebera paskutinio puslapio
}
// 1-4
$vienas = $psl_num + 1;
if($vienas < $max_psl)
{
$vienas_echo = "<a href=\"$self?puslapis=$vienas\">$vienas</a>";
} else {
$vienas_echo = " ";
}
$du = $psl_num + 2;
if($du < $max_psl)
{
$du_echo = "<a href=\"$self?puslapis=$du\">$du</a>";
} else {
$du_echo = " ";
}
$trys = $psl_num + 3;
if($trys < $max_psl)
{
$trys_echo = "<a href=\"$self?puslapis=$trys\">$trys</a>";
} else {
$trys_echo = " ";
}
$keturi = $psl_num + 4;
if($keturi < $max_psl)
{
$keturi_echo = "<a href=\"$self?puslapis=$keturi\">$keturi</a>";
} else {
$keturi_echo = " ";
}
// 10-40
$desimt = $psl_num + 10;
if($desimt < $max_psl)
{
$desimt_echo = "<a href=\"$self?puslapis=$desimt\">$desimt</a>";
} else {
$desimt_echo = " ";
}
$dvim = $psl_num + 20;
if($dvim < $max_psl)
{
$dvim_echo = "<a href=\"$self?puslapis=$dvim\">$dvim</a>";
} else {
$dvim_echo = " ";
}
$trim = $psl_num + 30;
if($trim < $max_psl)
{
$trim_echo = "<a href=\"$self?puslapis=$trim\">$trim</a>";
} else {
$trim_echo = " ";
}
$kiam = $psl_num + 40;
if($kiam < $max_psl)
{
$kiam_echo = "<a href=\"$self?puslapis=$kiam\">$kiam</a>";
} else {
$kiam_echo = " ";
}
$be = $puslapis -1;
$dabar = "<a href=\"$self?puslapis=$be\">" . $be . "</a>";
echo "<div class=\"pagination\" align=\"center\"><ul><li>" . $prev .
"</li><li>" . $first . "</li><li>$dabar</li><li> </li><li>" . $vienas_echo . "</li><li>" . $du_echo .
"</li><li>" . $trys_echo . "</li><li>" . $keturi_echo . "</li><li> <strong>...</strong> </li><li>" . $desimt_echo .
"</li><li>" . $dvim_echo . "</li><li>" . $trim_echo .
"</li><li>" . $kiam_echo . "</li><li>" . $last . "</li><li>" . $next . "</li></ul></div>";
?>
</body>
</html>