Changeset 464 for branches/beta/inc

Timestamp:

Mar 1, 2009, 3:45:55 PM (16 years ago)

Author:

amun

Message:

 

File:

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

branches/beta/inc/html.php

@@ -62 +62 @@
   <meta name=\"keywords\" content=\"".$this->CfgChck("keywords")."\" />
   <link rel=\"stylesheet\" type=\"text/css\" href=\"styles/style.css\" />
+  <script type=\"text/javascript\" src=\"styles/global.js\"></script>
   <!--[if IE]><link rel=\"stylesheet\" type=\"text/css\" href=\"styles/ie.css\" /><![endif]-->
   </head>
@@ -208 +209 @@
       {
           include("db.php");
+                global $db_webu;
+                
         if ($kategorie == "all")
         {
@@ -216 +219 @@
           $where = "WHERE `category` = '".$kategorie."'";
         }
-        $this -> db -> select_db($db_webu);
-        $sql = $this -> db -> query("SELECT * FROM `articles`".$where."ORDER BY `date` DESC;");
-        if ($sql -> num_rows > 0)
-        {
-        // TODO !!
-          while ($row = $sql -> fetch_array())
-          {
-            switch ($row["category"]) 
+ mysql_connect($db_server, $db_user, $db_pass);
+  mysql_select_db($db_webu);
+  $limit = 5;
+    
+        
+$pocet = mysql_num_rows(mysql_query("SELECT id FROM `articles`".$where."ORDER BY `date` DESC;"));
+$offset = ($_GET["offset"] ? $_GET["offset"] : $pocet);
+
+if ($pocet != 0)
+        {
+                  mysql_query("SET NAMES 'utf8'");
+$result = mysql_query("SELECT * FROM articles $where ORDER BY date DESC, id DESC LIMIT $limit OFFSET " . ($pocet - $offset));
+while($row = mysql_fetch_array($result)){
+ switch ($row["category"]) 
             {
               case 1:
@@ -259 +268 @@
               <tr>
                 <td>Sekce : <a href=\"?page=".$link."\">".$cat."</a></td>
-                <td>Zork</td>
+                <td>".$row["autor"]."</td>
               </tr>
             </table>
             <br />
             ";
-          }
+}
+if ($offset < $pocet) {
+    echo "<a href='$_SERVER[PHP_SELF]" . ($offset + $limit < $pocet ? "?offset=" . ($offset + $limit) : "") . "'>zpět</a>\n";
+}
+if ($offset > $limit) {
+    echo "<a href='$_SERVER[PHP_SELF]?offset=" . ($offset - $limit) . "'>vpřed</a>\n";
+}
+
+
+
+
+  
+        
         }
         else