Compu World

Contact

About Us Products Enquiry

Home

used computers, printers, servers, sun microsystems, cisco routers & switches

Call : 044 43327358, 09600019837

Product Brands

result); while($row = mysql_fetch_array($pager->result)) { $category1[]=$row; } ?>

show();?>

result=null; $this->sql = $sql; $this->getvar = $getvar; $this->rows = 0; $this->start = 0; $this->getvar_val = 1; $this->pager = null; $this->SetLength($length); $this->GetStart(); $this->doQuery(); } //Sets $length function SetLength($length) { $this->length = (int)$length; if($this->length<0) { $this->length = 0; } } function doQuery() { $sql = trim($this->sql); $sql = substr($sql,6); $sql = 'SELECT SQL_CALC_FOUND_ROWS '.$sql.' limit '.$this->start.', '.$this->length; $this->result = mysql_query($sql); $sql = "SELECT FOUND_ROWS()"; $result = mysql_query($sql); $this->rows = mysql_result($result,0); } //getvar_val() gets the //$getvar_val is a positive integer - > 0 function Set_Getvar_val() { $this->getvar_val = (int)$_GET[$this->getvar]; if($this->getvar_val<1) { $this->getvar_val = 1; } } //Gets the start of the data function GetStart() { $this->Set_Getvar_val(); $this->start = (($this->getvar_val-1)*$this->length); } function show($next="

",$last="

",$separator=" ") { $array = $this->pager(); $str = array(); foreach($array as $k => $v) { if($k!='next'&&$k!='last') { if($k==$this->getvar_val) { $str[] = $k; } else { $str[] = ''.$k.''; } } } $str = implode($separator, $str); $rt = $array['last']===null?"":''.$last.''.$separator; $rt .= $str.$separator; $rt .= $array['next']===null?"":''.$next.''; return $rt; } //Returns an array of the links arround the given point //['next'] => next page //['last'] => last page function pager($margin=10) { $path = $_GET; $newpath = $PHP_SELF."?"; foreach($path as $key => $value) { if($key!=$this->getvar) { $newpath .= $key."=".$value; $newpath .="&"; } } $newpath .= $this->getvar; $linkpaths = array(); $current = $this->start / $this->length + 1; $pages = ceil(($this->rows/$this->length)); $pagerstart = $current-$margin; $pagerstart = ($pagerstart<1)?1:$pagerstart; $pagerend = $current+$margin; $pagerend = ( $pagerend > $pages ) ? ( ceil( ( $this->rows / $this->length ) ) ): $pagerend; for($i=$pagerstart;$i < ($pagerend+1);$i++) { $linkpaths[$i] = $newpath."=".($i); } if($linkpaths[($current+1)]!=null) { $linkpaths['next']=$linkpaths[($current+1)]; } if($linkpaths[($current-1)]!=null) { $linkpaths['last']=$linkpaths[($current-1)]; } return $linkpaths; } } ?>