Hi, Wednesday, December 11, 2002, 2:05:25 AM, you wrote: LR> Hi,
LR> Just wondering if anybody knows a script to display a resultset over several pages using page numers & previous, next links. LR> So far I've only found such scripts for mysql using the the following sql syntax which is not odbc compliant: SELECT * from table LIMIT 0, 4 LR> I've looked at many sites to find such a script without luck so far... LR> Thanks in advance for your help, LR> -Luc Here is a paging class I wrote, it is using mysql but the example is not using the LIMIT feature so it should work with a little change for odbc. <? class page_class { var $count = 0; //total pages var $start = 0; //starting record var $pages = 0; //number of pages available var $page = 1; //current page var $maxpages; //shows up to 2 * this number and makes a sliding scale var $show; //number of results per page function page_class($count=0,$show=5,$max=9){ $this->count = $count; $this->show = $show; $this->maxpages = $max; ($this->count % $this->show == 0)? $this->pages = intval($this->count/$this->show) :$this->pages = intval($this->count/$this->show) +1; if(!empty($_GET['search_page'])){ $this->page = $_GET['search_page']; $this->start = $this->show * $this->page -$this->show; } } function get_limit(){ $limit = ''; if($this->count > $this->show) $limit = 'LIMIT'.$this->start.','.$this->show; return $limit; } function get_start(){ return $this->start; } function get_end(){ return ($this->start + $this->show); } function make_head_string($pre){ $r = $pre.' '; $end = $this->start + $this->show; if($end > $this->count) $end = $this->count; $r .= ($this->start +1).' - '.$end.' of '.$this->count; return $r; } function make_page_string($words,$pre='Result Page:'){ $r = $pre.' '; if($this->page > 1){ $y = $this->page - 1; $r .= '<a href="'.$_SERVER['PHP_SELF'].'?search_page='.$y.$words.'">Previous</a> '; } $end = $this->page + $this->maxpages-1; if($end > $this->pages) $end = $this->pages; $x = $this->page - $this->maxpages; $anchor = $this->pages - (2*$this->maxpages) +1; if($anchor < 1) $anchor = 1; if($x < 1) $x = 1; if($x > $anchor) $x = $anchor; while($x <= $end){ if($x == $this->page){ $r .= '<span class="s">'.$x.'</span> '; } else{ $r.= '<a href="'.$_SERVER['PHP_SELF'].'?search_page='.$x.$words.'">'.$x.'</a> '; } $x++; } if($this->page < $this->pages){ $y = $this->page + 1; $r .= '<a href="'.$_SERVER['PHP_SELF'].'?search_page='.$y.$words.'">Next</a> '; } return $r; } } //Usage $searchword = 'MSIE'; $whatever = 'user=me'; mysql_connect("localhost", "user", "pw......") or die (mysql_error()); $Query = "SELECT COUNT(*) AS cnt FROM db.table WHERE agent LIKE '%" .$searchword. "%'"; if(!$result = mysql_query($Query)){ echo 'oops: '.mysql_error(); exit; } $row = mysql_fetch_array($result); $count = $row['cnt']; if($count > 0){ //start class total number of results,number of results to show,max number of pages on a sliding scale (ends up as 2x this number..ie 20) $page = new page_class($count,5,10); $start = $page->get_start(); $end = $page->get_end(); $Query2= "SELECT * FROM db.table WHERE agent LIKE '%".$searchword. "%' ORDER BY time_stamp ASC "; $result = mysql_query($Query2) or die(mysql_error()); $hstring = $page->make_head_string('Results'); $pstring = $page->make_page_string("&searchword=".$searchword."&whatever=".$whatever);//add the other variables to pass to next page in a similar fashion echo "<table><tr><td>".$hstring."</td></tr>"; $x = 0; while($row = mysql_fetch_array($result)){ if($x >= $start){ echo '<tr><td>'.$x.' '.$row['agent'].' '.$row['time_stamp'].'</td></tr>'; } $x++; if($x > $end) break; } echo '<tr><td>'.$pstring.'</td></tr></table>'; } //Note: the search variables on subsequent pages will be passed by GET method ?> -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php