SmartyPagine and mod_rewrite

**CFC4N** · Aug 27 '06, 11:35 AM

Re: SmartyPagine and mod_rewrite

Cosmin Chiru å†™é“ï¼š

Hello,
>
I'm using SmartyPaginate to paginate results. Thing is I'm also using
mod_rewrite for the entire site and the paginate link should look like
this: "/products/pages/1". How can I do that? Thanks in advance.

=============== =============== =============== =====
You can write a entire function or class !

E.G :

CLASS >>>>
class Pager{
//ç”Ÿæˆçš„é¡µç ï¼ˆäº‹å®žä¸Šä¸ ç”¨ä¹Ÿè¡Œï¼‰
var $pageNumber='';

//éœ€è¦åˆ†ç±»çš„ æ¡ç›®æ€»æ•°
var $totalItems=0;
//æ•°æ®è¿žæŽ¥ç›¸ å…³
var $conn;
var $sql;
//æ¯é¡µæ˜¾ç¤ºå‡ ä¸ªæ¡ç›®
var $itemsPerPage=3 ;

//æ€»é¡µæ•°
var $totalPageNumbe r=0;
//å½“å‰é¡µç ï¼
var $currentPageNum ber=1;

//ä¸€ä¸ªé¡µé¢æ˜¾ ç¤ºå‡ ä¸ªé¡µç
var $length=10;

//éœ€è¦åˆ†é¡µçš„ url
var $url='';
function
Pager($conn,$sq l,$currentPageN umber,$itemsPer Page,$length,$u rl){
$this->currentPageNum ber=$currentPag eNumber;
$this->conn=$conn;
$this->sql=$sql;
$this->itemsPerPage=$ itemsPerPage;
$this->length=$length ;
$this->url=$url;
$this->url.=(stristr( $this->url,'?')!=fals e)?'&':'?';
//Urlé‡Œæœ‰"?"å°± åŠ "&"æ²¡æœ‰å° ±åŠ "?"
$this->getTotalPageNu mber();
}
function getTotalItems() {
//for adodb
$rs=$this->conn->Execute($thi s->sql);
$this->totalItems=$ rs->RecordCount( );
return $this->totalItems;
}
function getTotalPageNum ber(){

$this->totalPageNumbe r=ceil($this->getTotalItems( )/$this->itemsPerPage );

return $this->totalPageNumbe r;
}

//SQLé‡Œ LIMIT startï¼Œlength ä¸çš„èµ·å§‹å€¼
function getLimitStart() {
$start=($this->currentPageNum ber-1)*$this->itemsPerPage ;
return $start;
}
//SQLé‡Œ LIMIT startï¼Œlength ä¸çš„length
function getLimitItems() {
return $this->itemsPerPage ;
}
function getRsPerPage(){
$modiSQL=$this->sql." limit ".$this->getLimitStart( )."
,".$this->getLimitItems( );
//å¶ç”¨çš„æ˜¯ado dbçš„è¯´
$modiRS=$this->conn->Execute($modiS QL);
$arr=$modiRS->GetArray();
return $arr;
}

//ä¸»å‡½æ•°.ä¸æ– ‡åˆ†é¡µ
function getPageNumber() {
if ($this->getTotalPageNu mber()>1){

$pageNumber='å½ “å‰ç¬¬'.$this->currentPageNum ber.'é¡µ/å…±'.$this->totalPageNumbe r.'é¡µ';

//æ˜¾ç¤ºç¬¬ä¸€é¡µ å’Œå‰ä¸€é¡µ
if ($this->currentPageNum ber>1){
//ç¬¬ä¸€é¡µ
//First Page
$pageNumber.="<A HREF=".$this->url."page=1>ç¬ ¬ä¸€é¡µ</A>
</B";
//å‰ä¸€é¡µ
//Previous Page
$pageNumber.="<A
HREF=".$this->url."page=".($ this->currentPageNum ber-1).">å‰ä¸€é¡µ </A>
";
}
//The start number is the first number of all pages which show
on the current page.

$startNumber=in tval($this->currentPageNum ber/$this->length)*$thi s->length;

//Prev N page
//äº¤ç•Œå¤„
if ($this->currentPageNum ber>=$this->length){
$pageNumber.="[<A
HREF=".$this->url."page=".($ startNumber-1).">".($startN umber-1)."</A>]...";

}

$leftPageNumber =0;
for ($i=$startNumbe r;$i<=$this->totalPageNumbe r;$i++){
if ($i==0)continue ;
if ($i-$startNumber<$t his->length){
if ($i==$this->currentPageNum ber){
$pageNumber.="[$i]";
}else{
$pageNumber.="[<A
HREF=".$this->url."page=".$i .">".$i."</A>]";
}
}else{
$leftPageNumber =$this->totalPageNumbe r-$i+1;
break;
}
}
//æ˜¾ç¤ºä¸‹ä¸€ä¸ª åˆ†é¡µåˆ—è¡¨
if ($leftPageNumbe r>=1){
$pageNumber.=". ..[<A
HREF=".$this->url."page=".($ startNumber+$th is->length).">".($ startNumber+$th is->length)."</A>]
";
}

if ($this->currentPageNum ber!=$this->totalPageNumbe r){
//Next page
$pageNumber.="<A
HREF=".$this->url."page=".($ this->currentPageNum ber+1).">ä¸‹ä¸€ é¡µ</A>
";
//Last page
$pageNumber.="<A
HREF=".$this->url."page=".$t his->totalPageNumbe r.">æœ€åŽé¡µ </A";

}

$this->pageNumber=$pa geNumber;
return $this->pageNumber;

}

}

//è‹±æ–‡åˆ†é¡µ
function getPageNumber2( ){
if ($this->getTotalPageNu mber()>1){

$pageNumber='P' .$this->currentPageNum ber.'/'.$this->totalPageNumbe r.'';

//æ˜¾ç¤ºç¬¬ä¸€é¡µ å’Œå‰ä¸€é¡µ
if ($this->currentPageNum ber>1){
//ç¬¬ä¸€é¡µ
//First Page
$pageNumber.="<A HREF=".$this->url."page=1>FI RST</A>
</B";
//å‰ä¸€é¡µ
//Previous Page
$pageNumber.="<A
HREF=".$this->url."page=".($ this->currentPageNum ber-1).">PREV</A>
";
}
//The start number is the first number of all pages which show
on the current page.

$startNumber=in tval($this->currentPageNum ber/$this->length)*$thi s->length;

//Prev N page
//äº¤ç•Œå¤„
if ($this->currentPageNum ber>=$this->length){
$pageNumber.="[<A
HREF=".$this->url."page=".($ startNumber-1).">".($startN umber-1)."</A>]...";

}

$leftPageNumber =0;
for ($i=$startNumbe r;$i<=$this->totalPageNumbe r;$i++){
if ($i==0)continue ;
if ($i-$startNumber<$t his->length){
if ($i==$this->currentPageNum ber){
$pageNumber.="[$i]";
}else{
$pageNumber.="[<A
HREF=".$this->url."page=".$i .">".$i."</A>]";
}
}else{
$leftPageNumber =$this->totalPageNumbe r-$i+1;
break;
}
}
//æ˜¾ç¤ºä¸‹ä¸€ä¸ª åˆ†é¡µåˆ—è¡¨
if ($leftPageNumbe r>=1){
$pageNumber.=". ..[<A
HREF=".$this->url."page=".($ startNumber+$th is->length).">".($ startNumber+$th is->length)."</A>]
";
}

if ($this->currentPageNum ber!=$this->totalPageNumbe r){
//Next page
$pageNumber.="<A
HREF=".$this->url."page=".($ this->currentPageNum ber+1).">NEXT</A>
";
//Last page
$pageNumber.="<A
HREF=".$this->url."page=".$t his->totalPageNumbe r.">LAST</A ";
}

$this->pageNumber=$pa geNumber;
return $this->pageNumber;

}

}

}
//$currentPageNum ber=( isset($_GET['page']) ) ? intval($_GET['page']) :
1;
//include("PAGENU MBER/class.pagenumbe r.php");
//$pageNumber= new
PageNumber($ado dbConn,$sql,$cu rrentPageNumber ,10,3,3,"test.p hp");
//echo $pageNumber->getPageNumber2 ();
//echo " ";
//echo $pageNumber->getPageNumber( );
?>

FUNCTION >>>
function page($num, $perpage, $curr_page, $mpurl) {
$multipage = '';
if($num $perpage) {
$page = 10;
$offset = 2;

$pages = ceil($num / $perpage);
$from = $curr_page - $offset;
$to = $curr_page + $page - $offset - 1;
if($page $pages) {
$from = 1;
$to = $pages;
} else {
if($from < 1) {
$to = $curr_page + 1 - $from;
$from = 1;
if(($to - $from) < $page && ($to - $from) < $pages) {
$to = $page;
}
} elseif($to $pages) {
$from = $curr_page - $pages + $to;
$to = $pages;
if(($to - $from) < $page && ($to - $from) < $pages) {
$from = $pages - $page + 1;
}
}
}
$multipage .= "<a href=\"$mpurl&p age=1\">9 </a ";
for($i = $from; $i <= $to; $i++) {
if($i != $curr_page) {
$multipage .= "<a href=\"$mpurl&p age=$i\">$i</a";
} else {
$multipage .= ''.$i.'</u';
}
}
$multipage .= $pages $page ? " ... <a
href=\"$mpurl&p age=$pages\">$p ages</a<a
href=\"$mpurl&p age=$pages\"><F ont face=webdings>: </a>" : " <a
href=\"$mpurl&p age=$pages\"><F ont face=webdings>: </a>";
}
//echo $multipage;
return $multipage;
}

SmartyPagine and mod_rewrite

SmartyPagine and mod_rewrite

Comment