Php Programming Code Examples

Php > Site Navigation Code Examples

Page Scroller ver 3

Page Scroller ver 3

<? 
#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 

  $script="scroller3.php3"; 
  $offset+=0; 
  $item_perpage= 2;   #----change this to define how many item per page 
  $prev= $offset-$item_perpage; 
  $next= $offset+$item_perpage; 


#query configuration 

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

  $query="SELECT $field FROM $tbl_search WHERE $field LIKE '%$keyword%' LIMIT $offset, $item_perpage"; 
  $querytotal="SELECT count(*) FROM $tbl_search WHERE $field LIKE '%$keyword%'"; 
  $total=mysql_fetch_row(mysql_query($querytotal)); 

  #----modify the where clause to fit your query need 

#page map 

   $pages = (int) ($total[0] / $item_perpage); 
   if ($total[0] % $item_perpage) {$pages++;} 
   for ($a=1;$a<=$pages;$a++) { 
     $map[$a] =" <a href=\"$script?offset=$offset2&keyword=$keyword\">$a</a> "; 
     $offset2+=$item_perpage; 
   } 
   $pagemap=implode("|", $map); 

#prev next condition 
  if ($prev < 0) {$prev="";} 
  else {$prev="<a href=\"$script?offset=$prev&keyword=$keyword\"><< PREV</a>";} 
  if ($total[0] > $next) {$next="<a href=\"$script?offset=$next&keyword=$keyword\">NEXT >></a>";} 
  else {$next="";} 

?> 

<html> 
<head><title>CyberGL Page Scroller</title></head> 
<body> 
Query: 
<?echo  $query;?> 
<hr> 
<b><?echo $offset+1?> to <?echo $offset+$item_perpage?> of <?echo $total[0]?></b> 
<p> 
<? 
#-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 nowrap><?echo $prev?></td> 
          <td width="100%" align=center><?echo $pagemap?></td> 
          <td align=right  nowrap><?echo $next?></td> 
      </tr> 
  </table> 
</body> 
</html>