Php > Site Navigation

Page lister

Page lister

<html> 
<head> 
<title>Page Lister</title> 
<style type="text/css"> 
a { text-decoration: none } 
body {  color: #000; background-color: #fff} 
</style> 
</head> 
<body bgcolor="#ffffff"> 
<?PHP 
$PAGE = (isset($page)) ? $page : 1;  #We hope that page, not PAGE is in the querystring,    
                                     #if not we set it here 
$dbhost = "localhost"; # These are fairly self explanatory.... 
$dbname = "fillmein"; # You can remove these if you've already connected to a DB... 
$dbuser = "fillmein"; 
$dbpass = "fillmein"; 

$dc = mysql_connect($dbhost,$dbuser,$dbpass);  #Use $dc for debugging. 
mysql_select_db($dbname,$dc);  # Connect now, forget about it later. 

$QUERY = "SELECT * FROM table"; ## You MUST change this :)! 
$QRETURN= @mysql_query($QUERY);   
$QNUM = @mysql_num_rows($QRETURN);   

$DISPPAGE = 10;  #DISPPAGE is the number of items displayed per page. 
$NUMPAGES = ceil($QNUM / $DISPPAGE);  #NUMPAGES to show how many pages you WILL get. 

if($QRETURN):  #Sanity check on query, only runs if valid query. 
  if($QNUM > 0):  #We actually got some rows. 
    echo "<div align=\"right\">\n<font face=\"Tahoma, Geneva, sans-serif\" size=\"1\">\n";   

    for($i = 1; $i <= $NUMPAGES; $i++):  #loop to print << 1 2 3... $NUMPAGES >> 
      if($i == 1 && $PAGE > 1)  #Prints the << first to goto the previous page (not on page 1) 
        echo "<a href=\"$PHP_SELF?page=".($PAGE - 1)."\" onMouseOver=\"status='Go to the Previous Page';return true;\" onMouseOut=\"status=' ';return true;\">« </a>";   
      if($i == $PAGE)  #Doesn't print a link itself, just prints page number 
        echo "<font color=\"#ff3333\"> $i </font>";   
      if($i != $PAGE)  #Other links that aren't this page go here 
        echo "<a href=\"$PHP_SELF?page=$i\" onMouseOver=\"status='Go to Page $i';return true;\" onMouseOut=\"status=' ';return true;\"> $i </a>";   
      if($i == $NUMPAGES && $PAGE != $NUMPAGES)  #  Link for next page >>  (not on last page) 
        echo "<a href=\"$PHP_SELF?page=".($PAGE + 1)."\" onMouseOver=\"status='Go to the Next Page';return true;\" onMouseOut=\"status=' ';return true;\"> »</a>";   
    endfor;   
       
    echo "</font>\n</div>\n";   
    echo "<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">\n";   
    $START = ($PAGE - 1) * $DISPPAGE;   
    mysql_data_seek($QRETURN,$START);  #Moves the pointer to right row 
    #This loop will go until you a) reach $DISPPAGE or b) there aren't anymore entries 
    for($i = 1; $i <= $DISPPAGE && $ARET = @mysql_fetch_array($QRETURN); $i++):   
      $VAR = $ARET["col"]; #******** Here's the bit you should update! ********# 
      echo "$VAR\n<br><br>\n\n"; #echoes the field... 
      # Alternately, if you feel like numbering.  I haven't tested this. 
      #echo "<b>".$START + ($i - 1)."</b>: $VAR\n<br><br>\n\n"; 
    endfor;   
       
    echo "</font>\n";   
  endif;   

  if($QNUM == 0)  #if we get no rows 
    echo "<div align=\"center\">The database is empty</div>\n";   
endif;   

if(!$QRETURN):   # Bogus Query, or mysqld isn't running... 
  echo "<div align=\"center\">\n";   
  echo "<font face=\"Arial, Verdana, Helvetica, sans-serif\" color=\"#ff3333\" size=\"3\">\n";   
  echo "Either the database is down, or the query was invalid\n";   
  echo "</font>\n</div>\n";   
endif;   
?>   
</body> 
</html>