Pagination

[klik]

Hi,

First of all, sorry for the long section of code I am about to post, but i feel it is all neccessary with reference to this question.

<?php	

/* PAGINATION */
	$limit = 25;     
	// Sets how many results shown per page

$query_count = "SELECT count(*) FROM cms_users";    
$totalrows = mysql_query($query_count);   



if(empty($page)){  // Checks if the $page variable is empty (not set)
	$page = 1;   // If it is empty, we're on page 1
}

    $limitvalue = $page * $limit - ($limit);

			if($_POST['mode'] == ''){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY user_id LIMIT $limitvalue, $limit"); 
			}
			elseif(($_POST['mode'] == 'join_date')  && ($_POST['order'] == 'ASC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY reg_date LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'join_date')  && ($_POST['order'] == 'DESC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY reg_date DESC LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'username')  && ($_POST['order'] == 'ASC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY username LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'username')  && ($_POST['order'] == 'DESC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY username DESC LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'points')  && ($_POST['order'] == 'ASC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY user_points LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'points')  && ($_POST['order'] == 'DESC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY user_points DESC LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'profile_views')  && ($_POST['order'] == 'ASC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY profile_views LIMIT $limitvalue, $limit");
			}
			elseif(($_POST['mode'] == 'profile_views')  && ($_POST['order'] == 'DESC')){
						 $result = mysql_query("SELECT * FROM cms_users ORDER BY profile_views DESC LIMIT $limitvalue, $limit");
			}


if(mysql_num_rows($result) == 0){
	echo("Nothing to Display!");
} 




/* Output our information! */

						$color1 = "#DADADA";
						$color2 = "#CCCCCC";
						$row_count = 0;

		while ($row = mysql_fetch_assoc($result)) {

			$row_color = ($row_count % 2) ? $color1 : $color2;

			echo '<tr><td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\"><span class=\"gen\">' . $row['user_id'] . '</span></td>
			<td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\"><a href="http://localhost/Hip%20Hop%20Reaction/profile.php?user_id=' .$row['user_id'] . '">' . $row['username'] . '</a></td>';

			$show_email = $row['show_email'];

				if ($show_email == 1){
					echo '<td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\" valign=\"middle\"><a href="mailto:' . $row['email'] . '"><img src="images/icon_email.gif" width="59" height="18" border = "0"></a></td>';
				}
				else{
					echo '<td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\" valign=\"middle\"></td>';
				}

			echo '
                    <td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\" valign=\"middle\">' . $row['location'] . '</td>
                    <td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\" valign=\"middle\">' . $row['reg_date'] . '</td>
                    <td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\" valign=\"middle\">' . $row['user_points'] . '</td>
                    <td class=\"row1\" bgcolor="' . $row_color . '" align=\"center\" valign=\"middle\">' . $row['profile_views'] . '</td>';

			$row_count ++;
		}

?>


<?php 

/* Pagination Links */

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

	echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a>&nbsp;");
}else{
	echo("PREV".$limit."&nbsp;");
}

$numofpages = ceil($totalrows / $limit);

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


if(($totalrows % $limit) != 0){
    if($i == $page){
        echo($i."&nbsp;");
    }else{
        echo("<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);
?>

The next and previous links, never actually appear as links.

Thanks.
-klik

[robert_w_ark]

This could possibobly be your problem =\

$limitvalue = $page * $limit - ($limit);

make that code be like this because you dont need to multiply it, etc, etc.. just do this...

$limitvalue = $page + $limit;

So for example:
$limit = 25
$page = 3 <- you're on page 3, starting from #75 to #100

$limitvalue = 3 + 25 <- show 25 more results..

[klik]

Thanks for your effort, but it didn't work. It now only shows 10 results with your ammendment.

Anyone else have any ideas?

[alexu_]

I don't know if this will entirely fix your problem but it is needed.

change the way you calculate the total number of pages to:

$numofpages = ceil($totalrows / $limit); 

and remove the useless division check:

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

I'll let you know if I find something else

[alexu_]

I found the problem
this code is wrong

$query_count = "SELECT count(*) FROM cms_users";    

$result_count = mysql_query($query_count);    

$totalrows = mysql_num_rows($result_count); 

the $result_count variable will contain the total number of rows and the $totalrows variable will always be 1.
change it to this:

$query_count = "SELECT count(*) FROM cms_users";    

$totalrows = mysql_query($query_count);    

and it will work

[klik]

Hello,

Thanks for your help.

I have edited my first post to how the current status of the code.

The ouput is as follows:

PREV25 1 2 NEXT25

The Prev25 is not a link, which is correct, since we're on first page. The number of pages (1 & 2) is correct. The next 25 is NOT a link where it should be. The '2' link when clicked just displays the first page again.

I think the problem is that when 2 is clicked this means the post variable will equal ''

meaning the following code will be executed

				if($_POST['mode'] == ''){
							 $result = mysql_query("SELECT * FROM cms_users ORDER BY user_id LIMIT $limitvalue, $limit"); 
				}