Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Pagination limits

Posted on 2009-05-19
3
Medium Priority
?
347 Views
Last Modified: 2012-05-07
I have a functional pagination script I've hacked out from a variety of examples online. I just need it to do a couple more things. I need to eliminate the possibility of negatives on the Previous link (http://localhost/_maps/paginate.php?startrow=-10).

I would like to just hide the Previous link if ?startrow=0 but I'm not sure how to make that happen. My code is below if someone can help.
<?php
include_once("includes/db.php");
?>
<?PHP
//check if the starting row variable was passed in the URL or not
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
  //we give the value of the starting row to 0 because nothing was found in URL
  $startrow = 0;
//otherwise we take the value from the URL
} else {
  $startrow = (int)$_GET['startrow'];
}
?>
 
<?PHP
//this part goes after the checking of the $_GET var
$fetch = mysql_query("SELECT * 
					FROM markers 
					JOIN category ON category.cat_id = markers.cat_id
					LIMIT $startrow, 10")or
die(mysql_error());
?>
<?php
	$num=mysql_numrows($fetch);
	
	mysql_close();
?>
 
<table border="1" cellspacing="0" cellpadding="1" bordercolor="#000000" width="60%" align="center">
	<tr>
		<th align="left"><font face="verdana" size="2">Marker</font></th>
		<th align="left"><font face="verdana" size="2">Category</font></th>
		<th valign="top" width="60"><font face="verdana" size="2">Edit</font></th>
		<th valign="top" width="60"><font face="verdana" size="2">Delete</font></th>
	</tr>
 
<?php
	$i=0;
		while ($i < $num) {
			$marker_id=mysql_result($fetch,$i,"marker_id");
			$name=mysql_result($fetch,$i,"name");
			$street=mysql_result($fetch,$i,"street");
			$city=mysql_result($fetch,$i,"city");
			$state=mysql_result($fetch,$i,"state");
			$zip=mysql_result($fetch,$i,"zip");
			$url=mysql_result($fetch,$i,"url");
			$lat=mysql_result($fetch,$i,"lat");
			$lng=mysql_result($fetch,$i,"lng");
			$cat_name=mysql_result($fetch,$i,"cat_name");
?>
 
<tr>
	<td valign="top">
		<font face="verdana" size="2"><b><?php echo $name; ?></b></font><br/>
		<font face="verdana" size="1"><?php echo $street; ?></font>,&nbsp;
		<font face="verdana" size="1"><?php echo $city; ?></font>,&nbsp;
		<font face="verdana" size="1"><?php echo $state; ?></font>,&nbsp;
		<font face="verdana" size="1"><?php echo $zip; ?></font><br/>
		<font face="verdana" size="1"><a href="<?php echo $url; ?>"><?php echo $url; ?></a></font><br/>
		<font face="verdana" size="1"><b>Latitude:</b>&nbsp;<?php echo $lat; ?></font>&nbsp;
		<font face="verdana" size="1"><b>Longitude:</b>&nbsp;<?php echo $lng; ?></font></td>
	<td valign="top"><font face="verdana" size="2"><?php echo $cat_name; ?></font></td>
	<td valign="top" width="60"><a href="edit.php?marker_id=<?php echo $marker_id; ?>"><img src="../images/edit.png" alt="Edit" border="0"></a></td>
	<td valign="top" width="60"><a href="confirm_delete.php?marker_id=<?php echo $marker_id; ?>"><img src="../images/delete.png" alt="Delete" border="0"></a></td>
</tr>
<input type="hidden" name="marker_id" value="<?php echo $marker_id; ?>">
<?php
	$i++;
	}
?>
</table>
 
 
<?PHP
//now this is the link..
echo '<center><table><td><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow-10).'">Previous</a></td><td align="right"><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a></td></table></center>';
?>

Open in new window

0
Comment
Question by:webweever
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 11

Accepted Solution

by:
BrianMM earned 400 total points
ID: 24420191
there is nicer but you could always just check for a negative value in your else

//otherwise we take the value from the URL
} else {
  if($_GET['startrow'] <0) {
    $startrow = 0;
  } else {
    $startrow = (int)$_GET['startrow'];
  }
}

to hide if $startrow = 0 quckly do an if and display wink with or without previous.
0
 
LVL 5

Expert Comment

by:bored321
ID: 24420322
Another solution that hides the tag if start row <=0 would be
<?
//check if $startrow is less than or equal to 0 
$previoustag = ($startrow <=0) ?  "" : '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow-10).'">Previous</a>';
//now this is the link..
echo '<center><table><td>'.$previoustag.'</td><td align="right"><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a></td></table></center>';
?>

Open in new window

0
 
LVL 1

Author Comment

by:webweever
ID: 24420345
Below is how I did it and it appears to work. Thanks for the help
<?php
include_once("includes/db.php");
?>
<?PHP
//check if the starting row variable was passed in the URL or not
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow']) or ($_GET['startrow'] < 0)) {
  //we give the value of the starting row to 0 because nothing was found in URL
	$startrow = 0;
	// otherwise we take the value from the URL
	} else {
	$startrow = (int)$_GET['startrow'];
}
 
?>
 
<?PHP
//this part goes after the checking of the $_GET var
$fetch = mysql_query("SELECT * 
					FROM markers 
					JOIN category ON category.cat_id = markers.cat_id
					LIMIT $startrow, 10")or
die(mysql_error());
?>
<?php
	$num=mysql_numrows($fetch);
	
	mysql_close();
?>
 
<table border="1" cellspacing="0" cellpadding="1" bordercolor="#000000" width="60%" align="center">
	<tr>
		<th align="left"><font face="verdana" size="2">Marker</font></th>
		<th align="left"><font face="verdana" size="2">Category</font></th>
		<th valign="top" width="60"><font face="verdana" size="2">Edit</font></th>
		<th valign="top" width="60"><font face="verdana" size="2">Delete</font></th>
	</tr>
 
<?php
	$i=0;
		while ($i < $num) {
			$marker_id=mysql_result($fetch,$i,"marker_id");
			$name=mysql_result($fetch,$i,"name");
			$street=mysql_result($fetch,$i,"street");
			$city=mysql_result($fetch,$i,"city");
			$state=mysql_result($fetch,$i,"state");
			$zip=mysql_result($fetch,$i,"zip");
			$url=mysql_result($fetch,$i,"url");
			$lat=mysql_result($fetch,$i,"lat");
			$lng=mysql_result($fetch,$i,"lng");
			$cat_name=mysql_result($fetch,$i,"cat_name");
?>
 
<tr>
	<td valign="top">
		<font face="verdana" size="2"><b><?php echo $name; ?></b></font><br/>
		<font face="verdana" size="1"><?php echo $street; ?></font>,&nbsp;
		<font face="verdana" size="1"><?php echo $city; ?></font>,&nbsp;
		<font face="verdana" size="1"><?php echo $state; ?></font>,&nbsp;
		<font face="verdana" size="1"><?php echo $zip; ?></font><br/>
		<font face="verdana" size="1"><a href="<?php echo $url; ?>"><?php echo $url; ?></a></font><br/>
		<font face="verdana" size="1"><b>Latitude:</b>&nbsp;<?php echo $lat; ?></font>&nbsp;
		<font face="verdana" size="1"><b>Longitude:</b>&nbsp;<?php echo $lng; ?></font></td>
	<td valign="top"><font face="verdana" size="2"><?php echo $cat_name; ?></font></td>
	<td valign="top" width="60"><a href="edit.php?marker_id=<?php echo $marker_id; ?>"><img src="../images/edit.png" alt="Edit" border="0"></a></td>
	<td valign="top" width="60"><a href="confirm_delete.php?marker_id=<?php echo $marker_id; ?>"><img src="../images/delete.png" alt="Delete" border="0"></a></td>
</tr>
<input type="hidden" name="marker_id" value="<?php echo $marker_id; ?>">
<?php
	$i++;
	}
?>
</table>
 
 
<?PHP
//now this is the link..
if (!isset($_GET['startrow']) or ($_GET['startrow'] <= 0)) {
	echo '<center><table><td></td><td align="right"><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a></td></table></center>';
} else {
	echo '<center><table><td><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow-10).'">Previous</a></td><td align="right"><a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a></td></table></center>';
}
?>

Open in new window

0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to create an extensible mechanism for linked drop downs.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question