Changeset 451

Timestamp:

Mar 1, 2009, 2:13:07 PM (16 years ago)

Author:

amun

Message:

Stránkování novinek...

File:

• branches/beta/inc/html.php (modified) (2 diffs)

branches/beta/inc/html.php

@@ -223 +223 @@
         {
         // TODO !!
-          while ($row = $sql -> fetch_array())
+                
+  while ($row = $sql -> fetch_array())
           {
             switch ($row["category"]) 
@@ -267 +268 @@
             ";
           }
+                  
+mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_webu);
+  $limit = 5;
+$pocet = mysql_result(mysql_query(" SELECT FOUND_ROWS()"), 0);
+if ($_GET["offset"]) {
+    echo "<a href='$_SERVER[PHP_SELF]" . ($_GET["offset"] != $limit ? "?offset=" . ($_GET["offset"] - $limit) : "") . "'>zpět</a>\n";
+}
+if ($pocet > $_GET["offset"] + $limit) {
+    echo "<a href='$_SERVER[PHP_SELF]?offset=" . ($_GET["offset"] + $limit) . "'>vpřed</a>\n";
+}
+
+$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM tabulka ORDER BY datum DESC, id DESC LIMIT $limit OFFSET " . ($limit * $_GET["strana"]));
+$pocet = mysql_result(mysql_query(" SELECT FOUND_ROWS()"), 0);
+if ($_GET["strana"]) {
+    echo "<a href='$_SERVER[PHP_SELF]" . ($_GET["strana"] != 1 ? "?strana=" . ($_GET["strana"] - 1) : "") . "'>zpět</a>\n";
+}
+if ($pocet > $limit * ($_GET["strana"] + 1)) {
+    echo "<a href='$_SERVER[PHP_SELF]?strana=" . ($_GET["strana"] + 1) . "'>vpřed</a>\n";
+}
+        
         }
         else