<?
$host="localhost";
$user="root";
$pass="";
$dbase = "benutzer";
$db = mysql_connect($host, $user, $pass) OR die(mysql_error());
mysql_select_db($dbase, $db) OR die(mysql_error());
$_GET["pagenum"] = (!isset($_GET["pagenum"]) || $_GET["pagenum"] == 0 || empty($_GET["pagenum"])) ? 1 : $_GET["pagenum"];
$perpage = 4;
$limitlower = ($_GET["pagenum"]-1)*$perpage+1;
$limitupper = $_GET["pagenum"] * $perpage;
$sql = "select * from seminar limit ".($limitlower-1).",".$perpage;
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs);
$sql_hits = "select count(*) as hits from seminar";
$r_sql_hits = mysql_query($sql_hits,$db);
$r_sql = mysql_query($sql,$db);
if($r_sql){
$hits = mysql_fetch_row($r_sql_hits);
$hits = $hits[0];
$limitupper = ($limitupper > $hits) ? $hits : $limitupper;
$limitlower = ($limitlower > $hits) ? $hits - $perpage : $limitlower;
$limitlower = ($limitlower <= 0) ? $limitlower = 1 : $limitlower;
if($hits==0){
//FEHLERROUTINE
}else{
echo "<table border>";
$a = 0;
$b = 2; // Anzahl der Spalten
$i = 0;
do {
if($a == 0 && $i++ != 0) echo "<tr>\n";
echo "<td>".$row[0]."</td>\n";
$a++;
if($a >= $b) {
echo "</tr>\n";
$a = 0;
}
} while ($row=mysql_fetch_array($rs));
if($a != 0) {
while ($a < $b) {
echo("<td> </td>\n");
$a++;
}
echo("</tr>\n");
}
echo "</table>";
$page = ($hits<$perpage) ? 1 : ceil($hits/$perpage);
if($_GET["pagenum"] > 1):
$left_arrow = "<a href=\"paging.php?pagenum=".($_GET["pagenum"]-1)."\" class=\"searchlink\"> « </a>";
$firstpage = "<a href=\"paging.php?pagenum=1\" class=\"searchlink\"> «« </a>";
else:
$left_arrow = "<span class=\"diseablesearchlink\"> « </span>";
$firstpage = "<span class=\"diseablesearchlink\"> «« </span>";
endif;
if($_GET["pagenum"] < $page):
$right_arrow = "<a href=\"paging.php?pagenum=".($_GET["pagenum"]+1)."\" class=\"searchlink\"> » </a>";
$lastpage = "<a href=\"paging.php?pagenum=".$page."\" class=\"searchlink\"> »» </a>";
else:
$right_arrow = "<span class=\"diseablesearchlink\"> » </span>";
$lastpage = "<span class=\"diseablesearchlink\"> »» </span>";
endif;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" class="contentblack"><?php echo "Ergebnis: ".$limitlower." bis ".$limitupper." von ".$hits; ?></td>
<td align="right">
<?php
echo $firstpage." ".$left_arrow;
for($a=$_GET["pagenum"]-3;$a<=$_GET["pagenum"]+3;$a++){
if($a > 0 && $a <= $page){
if($a==$_GET["pagenum"]):
echo " <span class=\"thissite\">$a</span>";
else:
echo " <a href=\"paging.php?pagenum=".$a."\" class=\"searchlink\">".$a."</a>";
endif;
}
}
echo $right_arrow." ".$lastpage;
?>
</td>
</tr>
</table>
<?php
}
}
?>