Paging isnt working

nse111

I am trying to get some data and show it usig paging. my coding displays and also the paging is also visible on my web page. but it doesnt work. as in when i click next the next set of results aren't shown. Pls tell me wats wron wit my coding.

pls not that this is a jst a snippet from my coding.so ignore unclosed tags n all.

Expand|Select|Wrap|Line Numbers

 
$db_host = 'localhost';

$db_user = 'root';

$db_pwd = 'dba';
 
$database = 'mydb';

$table = 'user_groups';
 
$rowsPerPage = 3;

$pageNum = 1;

$offset = ($pageNum - 1) * $rowsPerPage;
 
if (!mysql_connect($db_host, $db_user, $db_pwd))

die("Can't connect to database");
 
if (!mysql_select_db($database))

die("Can't select database");
 
$result1 = mysql_query(" SELECT ug_name FROM user_groups "." LIMIT $offset, $rowsPerPage");

if (!$result1) {

die("Query to show fields from table failed");

}

if(isset($_GET['page']))

{

$pageNum = $_GET['page'];

}
 
?>

<table width="348" border="1" cellpadding="1" cellspacing="1" bordercolor="#1648AB" bgcolor="#EBE9ED">

<tr>

<td width="159" class="right"><strong class="right">User Group</strong></td>

<td width="63" class="right"><strong>Edit</strong></td>

<td width="108" class="right"><strong>Remove</strong></td>

</tr>

<?php while($row1 = mysql_fetch_row($result1)) { ?>

<tr><?php foreach($row1 as $cell){?>

<td><?php echo "$cell"; ?></td>

<td><a href="editusergroups.php?x=<?php echo"$cell";?>">Edit</a></td>

<td><a href="deleteusergroups.php?x=<?php echo"$cell";?>">Remove</a></td>

</tr>

<?php } }

$query = "SELECT COUNT(ug_name) AS numrows FROM user_groups";

$result = mysql_query($query) or die('Error, query failed');

$row = mysql_fetch_array($result, MYSQL_ASSOC);

$numrows = $row['numrows'];

$maxPage = ceil($numrows/$rowsPerPage);

$self = $_SERVER['PHP_SELF'];

$nav = '';

$fields_num = mysql_num_fields($result1);
 
for($page = 1; $page <= $maxPage; $page++)

{

if ($page == $pageNum)

{

$nav .= " $page "; // no need to create a link to current page

}

else

{

$nav .= " <a href=\"$self?page=$page\">$page</a> ";

}

}
 
if ($pageNum > 1)

{

$page = $pageNum - 1;

$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";

$first = " <a href=\"$self?page=1\">[First Page]</a> ";

}

else

{

$prev = '&nbsp;'; // we're on page one, don't print previous link

$first = '&nbsp;'; // nor the first page link

}
 
if ($pageNum < $maxPage)

{

$page = $pageNum + 1;

$next = " <a href=\"$self?page=$page\">[Next]</a> ";

$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";

}

else

{

$next = '&nbsp;'; // we're on the last page, don't print next link

$last = '&nbsp;'; // nor the last page link

}
 
// print the navigation link

echo $first . $prev . $nav . $next . $last;
 
mysql_free_result($result1);

?>

</table>

</div>

<br class="clearfloat" />

<?php @include_once("ui_footer.php");?>

</div>

</body>

</html>

rohypnol

First, replace:

Expand|Select|Wrap|Line Numbers

 $rowsPerPage = 3;

$pageNum = 1;

$offset = ($pageNum - 1) * $rowsPerPage;

with

Expand|Select|Wrap|Line Numbers

 $rowsPerPage = 3;

if(isset($_GET['page']))

{

    $pageNum = mysql_real_escape_string($_GET['page']);

}

else

{

    $pageNum = 1;

}

$offset = ($pageNum - 1) * $rowsPerPage;

Second, remove:

Expand|Select|Wrap|Line Numbers

 if(isset($_GET['page']))

{

$pageNum = $_GET['page'];

}

And here are some tips:
- ALWAYS sanitize user input before you put it into MYSQL. You are connecting to MYSQL using the root account and you are putting user strings into queries. A user could easily do something like www.site.com/page.php?page='; delete from user_groups; which would get you fired :( Use mysql_real_escape_string before pasting strings into queries.
- Use the [ code ] tags you have in the bytes.com message editor to paste code, that way it's easier to read your code and it's easier to tell you where the problem is because that tag will add line numbers.
- Break PHP from HTML because if in a month you need to change something in your page, you won't even know where to start! Use a templating system such as Smarty or at least don't output HTML using PHP variables.
- While in production, you should ALWAYS set PHP to report all errors, by setting error_reporting to "E_ALL | E_STRICT" and display_errors to "on" in your php.ini file (don't forget to restart APACHE after this). If you would have done that, you would have easily seen your error! It's on the first post in the PHP section of this website, it's a sticky post telling you to turn on error reporting. If you don't have access to php.ini check out this: http://bytes.com/forum/thread629295.html

nashruddin

my pagination function:

http://www.nashruddin.com/pagination...arge-data.html

Paging isnt working

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ