Problem in Pagination... Help...!

[nadnakinam]

Now code looks like this... No links(page navigaton links) working...

i think(not sure) problem @ line no 55, 66 & 77...(query part of URL).

<?php 
//CONNECTION TO DATABASE!

$host="localhost";      // Host name 
$username="root";       // Mysql username 
$password="";           // Mysql password 
$db_name="accounts";    // Database name
$tbl_name="login";      // Table name
$tbl1_name="details";   // Table1 name

// Connect to server & select databse.
$con=mysql_connect("$host","$username","$password");
mysql_select_db("$db_name",$con);

$show_all=$_POST['rg01'];                     // Show All

//**EDIT TO YOUR TABLE NAME, ECT. 

$t = mysql_query(" SELECT username FROM $tbl1_name WHERE sex = '$show_all' "); 
if(!$t) die(mysql_error()); 
    
$a                = mysql_fetch_object($t); 
$total_items      = mysql_num_rows($t); 
$limit            = 3;                       //default 
$page             = 1;                       //default 
//$sex              = $show_all; 

//calcuate total pages 
$total_pages     = ceil($total_items / $limit); 
$set_limit       = $page * $limit - ($limit); 

//query: **EDIT TO YOUR TABLE NAME, ECT. 

$q = mysql_query("SELECT username FROM $tbl1_name WHERE sex = '$show_all' LIMIT $set_limit, $limit"); 
  if(!$q) die(mysql_error()); 
     $err = mysql_num_rows($q); 
       if($err == 0) die("No matches met your criteria."); 

echo "<br>";

//show data matching query: 
while($code = mysql_fetch_object($q)) { 
     echo("item: ".$code->username."<BR>"); 
} 

$sex = urlencode($show_all); //makes browser friendly 
//echo $show_all;
//echo $sex;
echo "<br>";

//prev. page: **EDIT LINK PATH** 
$prev_page = $page - 1; 

if($prev_page >= 1) { 
  echo("<b>&lt;&lt;</b> <a href=http://localhost/wamp/www/28_09_pm_new/new.php?sex=$sex&amp;limit=$limit&amp;page=$prev_page><b>Prev.</b></a>"); 
} 
//Display middle pages: **EDIT LINK PATH** 
for($a = 1; $a <= $total_pages; $a++) 
{ 
   if($a == $page) 
   { 
      echo("<b> $a</b> | "); //no link 
   }
   else 
   { 
    echo("  <a href=http://localhost/wamp/www/28_09_pm_new/new.php?sex=$sex&amp;limit=$limit&amp;page=$a> $a </a> | "); 
   }
} 


//next page: **EDIT THIS LINK PATH** 
if($page!=$total_pages)
{
  $next_page = $page + 1; 
  if($next_page <= $total_pages) 
  { 
   echo("<a href=http://localhost/wamp/www/28_09_pm_new/new.php?sex=$sex&amp;limit=$limit&amp;page=$next_page><b>Next</b></a> &gt; &gt;"); 
  } 
}
//all done 
?>

[praveen_dusari]

its bit complecating when you use database pagination in many pages
why dont you use function for pagination,here is the function i use for pagination

function Navigation($start,$total,$link){
global $len;$en = $start +$len;if($start==0){if($total>0){$start1=1;}else {$start1=0;}}else{$start1=$start+1;}if($en>$total)$en = $total;if($total!=0)$pagecount=($total % $len)?(intval($total / $len)+1):($total / $len); else{$pagecount=0;return;}print "<table  cellpading=0 cellspacing=0  width=100% nowrap><tr>";print "<td width=40% class='dlinks' valign=bottom height=25  align='left'>Showing $start1 to $en of $total</td>";print "<td width=54% align=right valign=bottom>";if($en>$len){$en1=$start-$len; print "<a href='$link&start=$en1' class='slinks'> Previous </a><span class='slinks'> | </span>" ; }else print "<span class='slinks'> Previous </span><span class='slinks'> | </span>" ;$numstr="";$curpage=intval(($start+1)/$len)+1;if($pagecount > 10){$istart=(intval($curpage/10) * 10)+1;if($istart + 10 > $pagecount)$istart=$pagecount - 9;$pagecount=10;}else $istart=1;for($i=$istart;$i<$pagecount+$istart;$i++){$ed=($i-1)*$len;if($start!=$ed){$numstr.= " <a href='$link&start=$ed' class='slinks'> $i </a><span class='slinks'> | </span>";}else {$numstr.= "<span class='slinks'><strong> $i </strong></span><span class='slinks'> | </span>";}}print $numstr;if($en<$total){$en2=$start+$len;print "<a href='$link&start=$en2' class='slinks'> Next </a>" ;}else print "<span class='slinks'> Next </span>" ;print "</td></tr></table>";
}

in page you pass link="Your page.php?a=a";
$len=25;
and in query

mysql_query("select * from name limit $start,$len");

in page bottom you can call function

if you have any doubts post it here

[PravinBhat]

Try removing the "(" at the beginning and end of echo !! just go on typing the one you wanted and close with "

[SoN9ne]

PravinBhat is correct, try removing the parenthesis.

Other issues you may want to address when you get this working:
When using a variable in a function you don't need to include the "". See below for changes

$con=mysql_connect($host, $username, $password);
mysql_select_db($db_name, $con);

Use single quotes over double unless you need them. If you are going to escape then don't bother with double quotes...

On a side note, don't use deprecated code; change <b> to <strong>.

If you still have problems, let us know what error are you getting, if any.

[poojamakhija]

Instead of $show_all=$_POST;

Use below one

$show_all=$_REQUEST;

[poojamakhija]

use below code change the query use whtever u want for that and retrieve those columns related to that table, also changes locvalhost path for previous and next page:

<?
$host="localhost";      // Host name 
$username="root";       // Mysql username 
$password="";           // Mysql password 
$db_name="accounts";    // Database name


$tbl_name="login";      // Table name
$tbl1_name="details";   // Table1 name

$con=mysql_connect("$host","$username","$password");
mysql_select_db("$db_name",$con);


$show_all=$_REQUEST['rg01'];    


        $items_per_row = 5;
        $items_per_page =5;
        $chunk=5;
        $page = empty($_REQUEST['page']) ? 0 : $_REQUEST['page'];

        if ($page==-1)
        {
         $items_per_page=9999999;
         $xpage=$page;
         $page=0;
        }


        $query6="select SQL_CALC_FOUND_ROWS * from $tbl1_name WHERE sex = '$show_all'";
        $result6=mysql_query($query6);
        $nr = mysql_num_rows($result6);
        $z = ceil($nr / $items_per_page);
        if($nr!=0)
        {
            ?>
            <table border="1" align="center">
            <tr><th>Username</th><th>Sex</th></tr>
            <?   
                $lmt=$page * $chunk;
                $query="select SQL_CALC_FOUND_ROWS * from $tbl1_name WHERE sex = '$show_all' LIMIT " . $lmt . ", $chunk";
                $result=mysql_query($query);

                $maxlevel = ($page*$items_per_page)+$chunk;
                if ($maxlevel > $nr) $maxlevel=$nr; 

                while($row = mysql_fetch_array($result))
                        {   
            ?>
            <tr>
            <td><? echo $row['username']; ?></td>
            <td><? echo $row['sex']; ?></td>
            </tr>
            <?

        }

            ?>
    </table>
    <table cellpadding="0" cellspacing="0" align="center" border="0">
    <tr><td><br /></td></tr>
    <tr>
        <td>
            <?php if ($page > 1) { ?><a href="http://localhost/pooja/pooja_practice3/index.php?rg01=<?=$show_all?>&lmt=<?echo $lmt?>&amp;page=<?=$page-1?>">Previous<?php }  ?>
                <?php if ($page == 1) { ?><a href="http://localhost/pooja/pooja_practice3/index.php?rg01=<?=$show_all?>&lmt=<?echo $lmt?>">Previous</a><?php }  ?>

                 <?php  for($i = 0; $i < $z; $i++) { ?>
                  <?php if ($page == $i) { ?>
                   <span class="color-new"><?=$i+1?></span>
                  <?php } else if ($i==0) { ?>
                   <a href="http://localhost/pooja/pooja_practice3/index.php?rg01=<?=$show_all?>"><?=$i+1?></a>
                  <?php } else  { ?>
                   <a href="http://localhost/pooja/pooja_practice3/index.php?rg01=<?=$show_all?>&lmt=<?echo $lmt?>&amp;page=<?=$i?>"><?=$i+1?></a>
                  <?php } ?>
                 <?php } ?>

                <?php if ($page < ($z-1)) {?><a href="http://localhost/pooja/pooja_practice3/index.php?rg01=<?=$show_all?>&lmt=<?echo $lmt?>&amp;page=<?=$page+1?>">Next</a><?php }  ?>

                <p class="displaying"><span class="color"><?=($page*$items_per_page)+1?>-<?=$maxlevel?></span> of <?=$nr?> items</p>
        </td>
    </tr>
    </table>
<?
        }
        else
        {
            ?>
            <h3 align="center">There are no records.</h3>
            <?
        }
mysql_close($con);

?>

[nadnakinam]

thanks to all those who replied...