[toray]

hello does any1 have a script for php paging from mysql

something like <<prev 1 2 3 Next>>

thanks

[Jaffizzle]

eeh here ya go i just wrote a script for ya.

PHP Code:

<?php

/* ALOT OF THE CONFIGS CAN BE CHANGED IN THE CONSTRUCTOR */



include ("pagination.inc.php");

/*db stuff goes here */

$pgtn = new pagination; 

$pgtn->sql="SELECT * FROM some_table";  //sql

$pgtn->per_page=5;  //number of listings per page

$pgtn->constructor($_GET['page'], "page");  //if you wish to change your var..ie [url]www.somesite.com?page=1[/url] to [url]www.somesite.com?id=1[/url]

$limit = $pgtn->limit();  //executes query and returns result

while ($row=mysql_fetch_assoc($limit)){  //displays the result

    echo $row['some_info']."<br>";

}

    

$pgtn->display_pages();  //displays the pagination

?>

heres the class file...
pagination.inc.php

PHP Code:

<?php

//pagination class

class pagination{

var $sql;

var $start;

var $page;

var $total_pages;

var $pagevar;

var $per_page;

var $limit_pages;





function constructor($getpage, $page_var){ //$page = $_GET['page'];

if(empty($getpage))

    $this->page=1;

else

    $this->page=$getpage;

if(empty($this->pagevar)) $this->pagevar = $page_var;

else

    $this->pagevar="page";

$this->start=$this->page*$this->per_page-$this->per_page;



$result=mysql_query($this->sql) or die(mysql_error());

$total_rows=mysql_num_rows($result);

if($total_rows%$this->per_page==0)

    $this->total_pages = $total_rows/$this->per_page;

else

    $this->total_pages = $total_rows/$this->per_page+1;



//$this->limit_pages=$this->page-$this->per_page;

//$this->limit_pages_end=$this->total_pages;

$this->limit_pages=$this->page-5;  //start  pages  start with current page - 5

$this->limit_pages_end=$this->page+5;  //end page  end with current page + 5

}



function limit()

{

    $result=mysql_query($this->sql." LIMIT ".$this->start.", ".$this->per_page);

    return $result;

}



function display_pages(){

if($this->page > 1)

    echo "<a href=\"".$_SERVER['PHP_SELF']."?".$this->pagevar."=".($this->page-1)."\"><< </a>";

else

    echo "<< ";

    

for($i = $this->limit_pages; $i <= $this->limit_pages_end; $i++){  //use to limit how many pages displayed

        if($i < 1){

            echo"";

        }elseif ($i > $this->total_pages){

            echo"";

        }elseif($i == $this->page){

            echo $i."&nbsp;";

        }else{

           echo "<a href=\"".$_SERVER['PHP_SELF']."?".$this->pagevar."=".$i."\">$i </a>";

        }

    } 

    

if($this->page <= $this->total_pages)

    echo "<a href=\"".$_SERVER['PHP_SELF']."?".$this->pagevar."=".($this->page+1)."\">>> </a>";

else

    echo ">> ";

     }

}



?>

sorry about the lack of comments..i hate commenting


but lemme know how it goes!

[wheezy360]

Originally Posted by toray

hello does any1 have a script for php paging from mysql

something like <<prev 1 2 3 Next>>

thanks

This one's a little more compact than the above, if you like..
It relies on the following query string variables: "page" (current page number), and "len" (the max number of records to display per page).

PHP Code:

/*****

This portion will handle calculating which records to get from the db

*****/



// If the query string variable is defined, use that.  Otherwise, default to page 1

$page = isset($_GET['page']) ? $_GET['page'] : 1;



// The number of records to display per page.  Defaults to 25 if not specified

$pagelength = isset($_GET['len']) ? $_GET['len'] : 25;



// The lowerbound record number to start from

$lowerbound = ($page - 1) * $pagelength;



$rs = mysql_query('SELECT * FROM mytable LIMIT '.$lowerbound.','.$pagelength) or die(mysql_error());





/****

This portion outputs the page numbers so make sure you put it where you want the text to be displayed.  Also note that it's relying on the $pagelength, and $page variables from above so make sure this is same scope level

****/



$numpages = ceil(mysql_num_rows(mysql_query('SELECT * FROM mytable'))/$pagelength);



// Output the "Previous" link if you are not on the first page

echo $page > 1 ? '<a href="'.$PHP_SELF.'?page='.($page-1).'&len='.$pagelength.'">Previous</a>' : '';



// Loop through the page numbers

// Do not link the page number you are currently viewing

for ($i=1; $i <= $numpages; $i++) echo $i == $page ? $i : '<a href="'.$PHP_SELF.'?page='.$i.'&len='.$pagelength.'">'.$i.'</a>';



// Output the "Next" link if you are not on the last page

echo $page < $numpages ? '<a href="'.$PHP_SELF.'?page='.($page+1).'&len='.$pagelength.'">Next</a>' : '';