[RESOLVED] solve my error in the following pagination page= not getting value

[thread_PHP]

solve my error in the following pagination page= not getting value . i am attaching the centers.txt centers table

<?php
//pagination.php
mysql_connect("localhost","root","root") or die(mysql_error());
mysql_select_db("nac92_nacoas") or die(mysql_error());
/*if(!isset($pagenum))
{
	$pagenum=1;
}
$data=mysql_query("select * from centers") or die(mysql_error());
$rows=mysql_num_rows($data);
$page_rows=10;

$last=ceil($rows/$page_rows);
if($pagenum <1)
{
	$pagenum=1;
}
elseif($pagenum>$last)
{
	$pagenum=$last;
}
$max='limit'.($pagenum - 1) * $page_rows.','.$page_rows;
*/
$limit=25;
$query_count = "SELECT count(*) from centers";
$result_count = mysql_query($query_count);
$totalrows=mysql_num_rows($result_count);

if(empty($page)){
	$page=1;
}
$limitvalue=$page * $limit -($limit);
$query="SELECT * from centers LIMIT $limitvalue,$limit";
$result=mysql_query($query) or die("Error: ".mysql_error());
//$totalrows=mysql_num_rows($result);
if(mysql_num_rows($result) == 0)
{
	echo ("Nothing to display!");
}
$bgcolor="#E0E0E0";
echo ("<table>");
while($row=mysql_fetch_array($result)){
if($bgcolor=="#E0E0E0") {
	$bgcolor="#FFFFFF";
}
else
{
	$bgcolor="#E0E0E0";
}
echo ("<tr bgcolor=".$bgcolor."><td>");
echo ($row["location"]);
echo ("</td>");
echo ("<td>".$row["address"]);
echo ("</td></tr>");
}
echo ("</table>");

if($page !=1) {
	$pageprev = $page--;
	echo ("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a>");
}else{
	echo ("PREV".$limit." ");
}
$numofpages=$totalrows/$limit;
for($i=1;$i<=$numofpages; $i++){
	if($i == $page) {
		echo ($i." ");
	}else{
		echo ("<a href=\"$PHP_SELF?page=$i\">$i</a>");
	}
}
if(($totalrows % $limit) != 0) {
	if($i == $page) {
		echo ($i." ");
	}else{
		echo ("<a href=\"$PHP_SELF?page=$i\">$i</a>");
	}	
}

if(($totalrows - ($limit * $page)) > 0) {
	$pagenext = $page++;
	echo ("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>");

}else{
	echo ("NEXT".$limit);
}
#mysql_free_result($result);	
?>

[ragedigital]

Might be: $page = $_GET['page'];

Not sure that the variable can be pulled from the URL without the $_GET[''].

You might also want to make sure that $page does not equal 0 (zero).

[ragedigital]

$query_count = "SELECT count(*) from centers"; 
$result_count = mysql_query($query_count); 
$totalrows=mysql_num_rows($result_count); 

I'm not confident that COUNT(*) works like that.

Try this:

$result_count = mysql_query("SELECT sno FROM centers"); 
$totalrows=mysql_num_rows($result_count); 

[thread_PHP]

hi ragedigital
i changed the code like this but as per my attached picture like this the page is still remaining in the firstpage itself how can i solve that problem please correct this code

//$query_count = "SELECT count(*) from centers"; 
//$result_count = mysql_query($query_count); 
//$totalrows=mysql_num_rows($result_count); 
$result_count = mysql_query("SELECT sno FROM centers"); 
$totalrows=mysql_num_rows($result_count); 
if(empty($page)){ 
    $page=1; 
} 
$limitvalue=$page * $limit -($limit); 
$query="SELECT * from centers LIMIT $limitvalue,$limit"; 
$result=mysql_query($query) or die("Error: ".mysql_error()); 
//$totalrows=mysql_num_rows($result); 
if(mysql_num_rows($result) == 0) 
{ 
    echo ("Nothing to display!"); 
} 
$bgcolor="#E0E0E0"; 
echo ("<table>"); 
while($row=mysql_fetch_array($result)){ 
if($bgcolor=="#E0E0E0") { 
    $bgcolor="#FFFFFF"; 
} 
else 
{ 
    $bgcolor="#E0E0E0"; 
} 
echo ("<tr bgcolor=".$bgcolor."><td>"); 
echo ($row["location"]); 
echo ("</td>"); 
echo ("<td>".$row["address"]); 
echo ("</td></tr>"); 
} 
echo ("</table>"); 

if($page !=1) { 
    $pageprev = $page--; 
    echo ("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a>"); 
}else{ 
    echo ("PREV".$limit." "); 
} 
$numofpages=$totalrows/$limit; 
for($i=1;$i<=$numofpages; $i++){ 
    if($i == $page) { 
        echo ($i." "); 
    }else{ 
        echo ("<a href=\"$PHP_SELF?page=$i\"> $i </a>&nbsp;"); 
    } 
} 
if(($totalrows % $limit) != 0) { 
    if($i == $page) { 
        echo ($i." "); 
    }else{ 
        echo ("&nbsp;<a href=\"$PHP_SELF?page=$i\"> $i </a>&nbsp;"); 
    }     

} 
$page = $_GET['page'];
if(($totalrows - ($limit * $page)) > 0) { 
    $pagenext = $page++; 
    echo ("<a href=\"$PHP_SELF?page=$pagenext\">  NEXT".$limit."</a>"); 

}else{ 
    echo (" NEXT ".$limit); 
} 
#mysql_free_result($result);     

?> 

[ragedigital]

Put this:

$page = $_GET['page'];

before this:

$result_count = mysql_query("SELECT sno FROM centers"); 

[thread_PHP]

it is still not working properly please see this . After pressing next button is also not working when i press the 2 number or 3 number or 4 number it is not showing correct results

<?php 
//pagination.php 
mysql_connect("localhost","root","") or die(mysql_error()); 
mysql_select_db("mysql") or die(mysql_error()); 

$limit=25; 

$page = $_GET['page']; 

$result_count = mysql_query("SELECT sno FROM centers"); 
$totalrows=mysql_num_rows($result_count); 
if(empty($page)){ 
    $page=1; 
} 
$limitvalue=$page * $limit -($limit); 
$query="SELECT * from centers LIMIT $limitvalue,$limit"; 
$result=mysql_query($query) or die("Error: ".mysql_error()); 

if(mysql_num_rows($result) == 0) 
{ 
    echo ("Nothing to display!"); 
} 
$bgcolor="#E0E0E0"; 
echo ("<table>"); 
while($row=mysql_fetch_array($result)){ 
if($bgcolor=="#E0E0E0") { 
    $bgcolor="#FFFFFF"; 
} 
else 
{ 
    $bgcolor="#E0E0E0"; 
} 
echo ("<tr bgcolor=".$bgcolor."><td>"); 
echo ($row["location"]); 
echo ("</td>"); 
echo ("<td>".$row["address"]); 
echo ("</td></tr>"); 
} 
echo ("</table>"); 

if($page !=1) { 
    $pageprev = $page--; 
    echo ("<a href=\"$PHP_SELF?page=$pageprev\"> PREV ".$limit."  </a>"); 
}else{ 
    echo (" PREV ".$limit." "); 
} 
$numofpages=$totalrows/$limit; 
for($i=1;$i<=$numofpages; $i++){ 
    if($i == $page) { 
        echo ($i." "); 
    }else{ 
        echo ("<a href=\"$PHP_SELF?page=$i\"> $i </a>&nbsp;"); 
    } 
} 
if(($totalrows % $limit) != 0) { 
    if($i == $page) { 
        echo ($i." "); 
    }else{ 
        echo ("&nbsp;<a href=\"$PHP_SELF?page=$i\"> $i </a>&nbsp;"); 
    }     

} 

if(($totalrows - ($limit * $page)) > 0) { 
    $pagenext = $page++; 
    echo ("<a href=\"$PHP_SELF?page=$pagenext\">  NEXT".$limit."</a>"); 

}else{ 
    echo (" NEXT ".$limit); 
} 
#mysql_free_result($result);     

?> 

[ragedigital]

At least it gave you the correct result. That "BHIM..." is number 50.

I'll take a look at your code again in a bit.

What happens if you put "http://localhost/pagnination.php?page=3" in the address bar?

Do you get the next results?

I just want to make sure that the 'number' system is the issue and not the database statements.

darrin

[ragedigital]

I just ran it on my own fake data table and it works fine: http://www.seasl.org/thread_PHP_10350614_2.php?page=8

However, for the bottom line to work proerly you have to correct 2 things:

if($page !=1)  {
    $pageprev = $page--;

should be:

if($page !=1)  {
    $pageprev = $page-1;

AND

if(($totalrows - ($limit * $page)) > 0) {
    $pagenext = $page++;

if(($totalrows - ($limit * $page)) > 0) {
    $pagenext = $page+1;

By incrementing $page the way you are, you're getting the wrong number selection at the botom.

[ragedigital]

Full Code:

<?php
//pagination.php
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("mysql") or die(mysql_error());

$limit=25;

$page = $_GET['page'];

if(empty($page))
    $page=1;

$result_count = mysql_query("SELECT sno FROM centers");
$totalrows=mysql_num_rows($result_count);

$limitvalue=$page * $limit -($limit);
$result=mysql_query("SELECT * from centers LIMIT $limitvalue,$limit") or die("Error: ".mysql_error());

if(mysql_num_rows($result) == 0)
    echo ("Nothing to display!");
else
    {
    $bgcolor="#E0E0E0";
    echo ("<table>");

while($row=mysql_fetch_array($result))
    {
    if($bgcolor=="#E0E0E0")
        $bgcolor="#FFFFFF";
    else
        $bgcolor="#E0E0E0";

    echo ("<tr bgcolor=".$bgcolor."><td>");
    echo ($row["firstName"]);
    echo ("</td>");
    echo ("<td>".$row["address"]);
    echo ("</td></tr>");
    }

    echo ("</table>");

if($page !=1)
    {
    $pageprev = $page-1;
    echo ("<a href=\"$PHP_SELF?page=$pageprev\"> PREV ".$limit."  </a>");
    }
else
    echo (" PREV ".$limit." ");

$numofpages=$totalrows/$limit;
for($i=1;$i<=$numofpages; $i++)
    {
    if($i == $page)
        echo ($i." ");
    else
        echo ("<a href=\"$PHP_SELF?page=$i\"> $i </a>&nbsp;");
    }


if(($totalrows % $limit) != 0)
    {
    if($i == $page)
        echo ($i." ");
    else
        echo ("&nbsp;<a href=\"$PHP_SELF?page=$i\"> $i </a>&nbsp;");
    }


if(($totalrows - ($limit * $page)) > 0)
    {
    $pagenext = $page+1;
    echo ("<a href=\"$PHP_SELF?page=$pagenext\">  NEXT".$limit."</a>");
    }
else
    echo (" NEXT ".$limit);
}

?>

[thread_PHP]

hi ragedigital

thank you