Changeset 47 for news.php

Timestamp:

Aug 19, 2007, 4:58:14 PM (17 years ago)

Author:

george

Message:

Listování stránek u aktualit.
Zjednodušení generování hlavního menu do funkcí.
Doplnění položek konfigurace.

File:

• news.php (modified) (1 diff)

news.php

@@ -6 +6 @@
 {
   global $Database;
-  echo('<strong>Aktuality:</strong>');
-  echo('<div style="NewsTable">');
+  $ItemPerPage = 6;
+  if(array_key_exists('Page', $_GET)) $Page = $Database->real_escape_string($_GET['Page']); else $Page = 0;
   $Database->select_db('wow');
-  $Result = $Database->query('SELECT news.*, user.User as username FROM news JOIN user ON user.ID=news.user WHERE 1 ORDER BY time DESC LIMIT 6');
-  while($Row = $Result->fetch_array())
+  $DbResult = $Database->query('SELECT COUNT(*) FROM news');
+  $Total = $DbResult->fetch_array();
+  $Total = $Total[0];
+  
+  $Result = '<strong>Aktuality:</strong>';
+  $Result .= '<div style="NewsTable">';
+  $DbResult = $Database->query('SELECT news.*, user.User as username FROM news JOIN user ON user.ID=news.user WHERE 1 ORDER BY time DESC LIMIT '.($Page * $ItemPerPage).','.$ItemPerPage);
+  while($Row = $DbResult->fetch_array())
   { 
-    echo('<div class="NewsItem">');
+    $Result .= '<div class="NewsItem">';
     if($Row['long_text'] != '') $Row['title'] = '<a href="?new_id='.$Row['id'].'">'.$Row['title'].'</a>';
-    echo('<div class="NewsItemTitle"><strong>'.$Row['title'].'</strong> ('.HumanDate($Row['time']).')</div>');  
-    echo($Row['short_text'].' ('.$Row['username'].')</div>');
+    $Result .= '<div class="NewsItemTitle"><strong>'.$Row['title'].'</strong> ('.HumanDate($Row['time']).')</div>';  
+    $Result .= $Row['short_text'].' ('.$Row['username'].')</div>';
   }
-  echo('</div>');
+  $Result .= '</div>';
+  $Result .= PagesList('?Page=', $Page, $Total, $ItemPerPage);
+  return($Result);
 }