Php > Site Navigation

Page Scroller

Page Scroller

<? 
#database configuration 

  $db_user   = "root"; 
  $db_pass    = "pass"; 
  $db_name    = "phpMember"; 
  $db_host    = "localhost"; 

  mysql_pconnect($db_host, $db_user, $db_pass) or die("Unable to connect to SQL server"); 
  mysql_select_db($db_name) or die("Unable to select database"); 

#page scroller configuration 

  $offset+=0; 
  $item_perpage= 2;   #----change this to define how many item per page 
  $prev= $offset-$item_perpage; 
  $next= $offset+$item_perpage; 
  if ($prev <= 0) $prev=0; 

#query configuration 

  $tbl_search    = "country"; 
  $field="name "; 

  $query="SELECT $field FROM $tbl_search WHERE $field LIKE '%$keyword%' LIMIT $offset, $item_perpage"; 
  #----modify the where clause to fit your query need 

?> 

<html> 
<head><title>CyberGL Page Scroller</title></head> 
<body> 
Query: 
<?echo  $query;?> 
<hr> 
<? 
#query process 
        $data=mysql_query($query); 
        $no=1; 
        while ($result=mysql_fetch_array($data)) { 
?> 
            NO: <?echo $no+$offset;?>. <?echo $result[name]?><p> 
<?            $no++; 
        } 
#page scroller 
?> 
  <table width="100%" cellpadding=0 cellspacing=0 border=0> 
      <tr> 
          <td><a href="scroller.php3?offset=<?echo $prev?>&keyword=<?echo $keyword?>"><< PREV</a></td> 
          <td align=right><a href="scroller.php3?offset=<?echo $next?>&keyword=<?echo $keyword?>">NEXT >></a></td> 
      </tr> 
  </table> 


</body> 
</html>