Simple (but powerful) paging function

Preview:
First page: http://i56.tinypic.com/ip2war.jpg
In the middle: http://i51.tinypic.com/14a9aoz.png
Last page: http://i51.tinypic.com/a5joyw.jpg

I am testing right now. If it works for me you are my god! Thank you so much for this!!! I have been working for hours trying to get a pagination script working and here you are just spilling out the answer right in front of me. THANK YOU!

Line 33 needs to be changed from:

echo "<a style=\"text-decoration: none;\" href=\"".$page_link."page=$previous_page\"<<</a>  ";

to this... you didn't close the link:

echo "<a style=\"text-decoration: none;\" href=\"".$page_link."page=$previous_page\"><</a>  ";

By the way, is there a way to limit the pagination if you have less than x amount of pages? Like if I want it to eventually display a max of 10 pages, but I only have 3 pages filled up right now, is there a way to make it only show the max if you have at least that many pages?

@epicrevolt: well I've looked hard for a script that can do what I wanted, I was only able to find the first part, but I have lots of rows.. so I ended up with 120 numbered links at the end of each page.. so I decided to write one from scratch.. the minute I added this to my project I posted it, so I'm glad it was useful to you.

About your question, put the leave everything the way you want it, max rows per page and max links per page.
After the line 62 add a new "for loop" for 7 more numbers and make them linkless (no "a" tag) and you're good to go.

Could you please elaborate on the for loop? I am kinda new to PHP and I suck at for and foreach loops :(

just after the line 62

<?php
for ($i=3;$i<8;$i++){
echo "<a class=\"link\" href=\"#\">".$i."</a>  |  "
}
?>

I guess it's easy

i think so u made this script quiet complicated for php beginners....
I will soon post the easier solution to this ...might be in tomorrow evening....
i have worked many times in this type of pagings...

this is the solution to ur problem...if u want elaboration then i will explain u in another post....waiting for ur reply whether it was helpful.....

<?php
$page=1;
$nor=5;
$a=1;
if(isset($_GET['page']))
{
}
else
{
$_GET['page']=1;
}
echo $_GET['page'];
$con=mysql_connect("localhost","root","")
or die ("error");
$db=mysql_select_db("check",$con)
or die("database not found");
$result=mysql_query("SELECT * FROM comment")
or die ("query error");
echo "<table border='1'><tr><th>name</th><th>Comment</th></tr>";
$r=mysql_num_rows($result);
echo $r."<br/>";
$p=ceil($r/$nor);
//echo $p;
while($rows=mysql_fetch_array($result))
{
if($a>($_GET['page']-1)*$nor)
{
echo "<tr><td>".$rows['user']."</td><td>".$rows['comment']."</td></tr>";
}
$a=$a+1;
}
echo "</table>";
for($i=1;$i<=$p;$i++)
{
if($i==$_GET['page'])
{
echo $i;
}
else
{
echo "<a href='check.php?page=".$i."'>".$i."</a>";
}
}

?>

if u want a more advanced paging system then i will make it for u within an hour.....just waiting what else u want frm this post.....

hello

if you use this function to paginate mysql results you'll find it good in all cases but if your query results will be shorter than the maximum page links which is '$max_page_links' you'll have useless page links which appointed in line 46 '$end_counter=$max_page_links;//Show only enough links' so you'll need to fix it by changing '$end_counter=$max_page_links;//Show only enough links' to '$end_counter = ceil($total/$max);', but this will cause mass-error it will make all of your links appear if you have more pages than the '$max_page_links' variable so..

which is

else{//Still in the first pages?
$start_counter=1;//Start with page one
$end_counter=$max_page_links;//Show only enough links
}

else { //Still in the first pages?
    $start_counter = 1; //Start with page one

    if(ceil($num_stuff/$max)-$current_page < (($max_page_links/2)+1)){
        $end_counter = ceil($num_stuff/$max); //Show only enough links
    } else {
        $end_counter = $max_page_links; //Show only enough links
    }
}

also I've modified the 'echo' function for the links output to push it into '$nav' variable and then return it which make it more stronger if don't wish to use this as a function and want to put it any place in your code then print out the '$nav' variable where you want to render your links.

Important Note: I've fully changed alot of variable names so if you want to use part of my function to replace it with a part of the orignal function it won't work so you must use any of them not to mix them.

//Preparing --Start--
//comment the following function link to avoid using it as a function and don't forget to comment the closing of it--
function pageThis($max, $max_page_links, $query, $page_link){
    // -- and Uncomment the next 4 lines if don't wish to use this as a function
    //$page_link = "paged.php";
    //$max = 30;//Maximum items per page (rows)
    //$max_page_links = 10;//Maximum links number in the page
    //$sql .= "select * from some_table";//Your query

    //Getting the total possible rows
    $total = mysql_num_rows(mysql_query($sql));
    if(isset($_GET['page'])&&$_GET['page']>0){
        //Now the page number make more sense (page=1 is actually the first page)
        $start = intval($_GET['page'])-1;
        //Some cleaning (SQL Injection prevention, and get rid of negative numbers)
        $current = intval($_GET['page']);
    //If no parameters passed.. just give the first page
    } else {
        $current = 1;
        $start = 0;
    }
    //If a large page numbre passed (more than there actually is) just give the last page
    if($current > ceil($total/$max)){
        $current = ceil($total/$max);
        $start = ceil($total/$max)-1;
    }
    //Which row to start with
    $start *= $max;
    //Adding the limit
    //$sql .= " LIMIT '".$start."', '".$max;
    //Preparing --End--

    //Actual paging --Start--
    //Is there any need for pagin?
    if($total > $max){
        //Making previous page & first page links when needed
        if($current > 1){
            //previousious means -1
            $prev = $current-1;
            //First page is the page number.. you guessed it right.. 1
            $nav .="<a href='".$page_link."?page=1'>first</a>  ";
            $nav .="<a href='".$page_link."?page=".$prev."'> << </a>  ";
        }
        //Are we going far away from the first viewed page link?
        if($current > $max_page_links/2){
            //Are we getting closer to last viewed page link?
            if(ceil($total/$max)-$current < (($max_page_links/2)+1)){
                //Yes, Then we need to view more page links
                $start_counter = $current-($max_page_links-(ceil($total/$max)-$current));
                //And no need to view page links more than the query can bring
                $end_counter = ceil($total/$max);
                //echo "case: 1";
            } else {
                //No, then just view some links before the currentrent page
                //echo "case: 2";
                $start_counter = $current-(($max_page_links/2)-1);
                //And some links after
                $end_counter = $current+($max_page_links/2);
            }
            //Still in the first pages?
        } else {
            //Start with page one
            $start_counter = 1;
            if(ceil($total/$max)-$current < (($max_page_links/2)+1)){
                //echo "case: 4";
                //Show only enough links
                $end_counter = ceil($total/$max);
            } else {
                //echo "case: 5";
                //Show only enough links
                $end_counter = $max_page_links;             
            }
        }
        //A loop for viewing the links
        for($i=$start_counter;$i<=$end_counter;$i++){
            //Is this the last link?
            if($i == $end_counter){
                //Are we actually on the last page? Because we don't need the | after the link
                if($i == $current){
                    //Then make it look like we're on that page
                    $nav .= "<a style='background:#3399CC;'>".$i."</a>";
                } else {
                    //Well yeah, it's the last link.. but we're not there yet.
                    $nav .= "<a href='".$page_link."?page=".$i."'>".$i."</a>";
                }
            //Not the last page you say.. mmm.. then print normally (with | after the link)
            } else {
                //Are we vewing this page?
                if($i == $current){
                    //Make us know it
                    $nav .= "<a style='background:#3399CC;'>".$i."</a>";
                //Not viewing.. just a normal link (the most common case here)
                } else {
                    //Nothing to say
                    $nav .= "<a href='".$page_link."?page=".$i."'>".$i."</a>";
                }
            }
        } // Loop Ending
        //Making the next and last page links
        if($current<ceil($total/$max)){
            //Next means +1
            $next_page = $current+1;
            //and the last page is the page.. whell.. it's the last one the query can bring
            $last_page=ceil($total/$max);
            $nav .= "  <a href='".$page_link."?page=".$next_page."'> >> </a>";
            $nav .= "  <a href='".$page_link."?page=".$last_page."'>last</a>";
        }
    }
    // comment the follwing 2 lines if you commented the function line at the top
   return $nav;
}

now I add some CSS staff to make it looks better

//Preparing --Start--
//comment the following function link to avoid using it as a function and don't forget to comment the closing of it--
function pageThis($max, $max_page_links, $query, $page_link){
    // -- and Uncomment the next 4 lines if don't wish to use this as a function
    //$page_link = "paged.php";
    //$max = 30;//Maximum items per page (rows)
    //$max_page_links = 10;//Maximum links number in the page
    //$sql .= "select * from some_table";//Your query

    //Getting the total possible rows
    $total = mysql_num_rows(mysql_query($sql));
    if(isset($_GET['page'])&&$_GET['page']>0){
        //Now the page number make more sense (page=1 is actually the first page)
        $start = intval($_GET['page'])-1;
        //Some cleaning (SQL Injection prevention, and get rid of negative numbers)
        $current = intval($_GET['page']);
    //If no parameters passed.. just give the first page
    } else {
        $current = 1;
        $start = 0;
    }
    //If a large page numbre passed (more than there actually is) just give the last page
    if($current > ceil($total/$max)){
        $current = ceil($total/$max);
        $start = ceil($total/$max)-1;
    }
    //Which row to start with
    $start *= $max;
    //Adding the limit
    //$sql .= " LIMIT '".$start."', '".$max;
    //Preparing --End--

    //Actual paging --Start--
    //Is there any need for pagin?
    if($total > $max){
        //Making previous page & first page links when needed
        if($current > 1){
            //previousious means -1
            $prev = $current-1;
            //First page is the page number.. you guessed it right.. 1
            $nav .="<a href='".$page_link."?page=1'>first</a>  ";
            $nav .="<a href='".$page_link."?page=".$prev."'> << </a>  ";
        }
        //Are we going far away from the first viewed page link?
        if($current > $max_page_links/2){
            //Are we getting closer to last viewed page link?
            if(ceil($total/$max)-$current < (($max_page_links/2)+1)){
                //Yes, Then we need to view more page links
                $start_counter = $current-($max_page_links-(ceil($total/$max)-$current));
                //And no need to view page links more than the query can bring
                $end_counter = ceil($total/$max);
                //echo "case: 1";
            } else {
                //No, then just view some links before the currentrent page
                //echo "case: 2";
                $start_counter = $current-(($max_page_links/2)-1);
                //And some links after
                $end_counter = $current+($max_page_links/2);
            }
            //Still in the first pages?
        } else {
            //Start with page one
            $start_counter = 1;
            if(ceil($total/$max)-$current < (($max_page_links/2)+1)){
                //echo "case: 4";
                //Show only enough links
                $end_counter = ceil($total/$max);
            } else {
                //echo "case: 5";
                //Show only enough links
                $end_counter = $max_page_links;             
            }
        }
        //A loop for viewing the links
        for($i=$start_counter;$i<=$end_counter;$i++){
            //Is this the last link?
            if($i == $end_counter){
                //Are we actually on the last page? Because we don't need the | after the link
                if($i == $current){
                    //Then make it look like we're on that page
                    $nav .= "<a class='current'>".$i."</a>";
                } else {
                    //Well yeah, it's the last link.. but we're not there yet.
                    $nav .= "<a href='".$page_link."?page=".$i."'>".$i."</a>";
                }
            //Not the last page you say.. mmm.. then print normally (with | after the link)
            } else {
                //Are we vewing this page?
                if($i == $current){
                    //Make us know it
                    $nav .= "<a class='current'>".$i."</a>";
                //Not viewing.. just a normal link (the most common case here)
                } else {
                    //Nothing to say
                    $nav .= "<a href='".$page_link."?page=".$i."'>".$i."</a>";
                }
            }
        } // Loop Ending
        //Making the next and last page links
        if($current<ceil($total/$max)){
            //Next means +1
            $next_page = $current+1;
            //and the last page is the page.. whell.. it's the last one the query can bring
            $last_page=ceil($total/$max);
            $nav .= "  <a href='".$page_link."?page=".$next_page."'> >> </a>";
            $nav .= "  <a href='".$page_link."?page=".$last_page."'>last</a>";
        }
    }
    // comment the follwing 2 lines if you commented the function line at the top
   return $nav;
}

.pagination a{
    float:left; /* Change this to right if arabic sites */
    color:#0A7EC5;
    display:block;
    min-width:18px;
    text-align:center;
    border:solid 1px #8DC5E6;
    border-radius:3px; 
    -moz-border-radius:3px;
    -webkit-border-radius:3px;
    padding:6px 4px 6px 4px;
    margin-right: 2px;
    background:#F8FCFF;
}


.pagination a:hover, .pagination a.current, .pagination a:active, .pagination a:focus{  
  color:#FFFFFF;
  border-color:#3390CA;
  text-decoration:none;
  box-shadow:0px 1px #EDEDED;
  -moz-box-shadow:0px 1px #EDEDED;
  -webkit-box-shadow:0px 1px #EDEDED;
  text-shadow:0px 1px #388DBE;
  background:#58B0E7;
  background:-moz-linear-gradient(top,#B4F6FF 1px,#63D0FE 1px,#58B0E7);
  background:-webkit-gradient(linear,0 0,0100%,color-stop(0.02,#B4F6FF),color-stop(0.02,#63D0FE),color-stop(1,#58B0E7));}

Sorry I forgot to define $nav in the beginning so please edit my two posts and put this code after line 9

$nav = "";

How about correcting it and re-posting?

better if you allow me to edit my posts or just let as it is .. not bad and just let the people fix it as i said by adding $nav = ""; after line 9
thanks

leave it then. ok.

please help me to cull a function wich is function.php
Thank you

Don't hijack a dead thread and please supply all the information required to help you. Start a new thread if you can't find what you need from the search facility.