paging problem for my gallery

gamesnthings

Hello every one

I have a gallery page where i only display 6 thumbnails per page.

I have been able to modify the code so that only 6 results are shown with their caption but can get a code for paging.

(1)what do i need to add to my code so that i get a previous or next link. :queasy:

(2) If u look at my code, if i click on a thumb nail it opens a big pic with caption on the same page. How can i modify it to open in another page. 😕

any help will be appreicated.

thanks

<?php
	include("conn.php");


// initialization
$result_array = array();
$counter = 0;
$images_dir = "photos";
$Start = 0;
$ByPage = 6;

$cid = (int)($_GET['cid']);
$pid = (int)($_GET['pid']);



// Thumbnail Listing

{
	$number_of_thumbs_in_row = 2;

	$result = mysql_query( "SELECT photo_id,photo_caption,photo_filename FROM gallery_photos $MyQuery $MyOrder limit $Start, $ByPage ");
	$nr = mysql_num_rows( $result );

	if( empty( $nr ) )
	{
		$result_final = "\t<tr><td>No Images found</td></tr>\n";
	}
	else
	{
		while( $row = mysql_fetch_array( $result ) )
		{
			$result_array[] = "<a href='viewgallery.php?cid=$cid&pid=".$row[0]."'><img src='".$images_dir."/tb_".$row[2]."' border='0' alt='".$row[1]."' /><br />".$row[1]."</a>"; 


		}
		mysql_free_result( $result );	

		$result_final = "<tr>\n";

		foreach($result_array as $thumbnail_link)
		{
			if($counter == $number_of_thumbs_in_row)
			{	
				$counter = 1;
				$result_final .= "\n</tr>\n<tr>\n";
			}
			else
			$counter++;

			$result_final .= "\t<td>".$thumbnail_link."</td>\n";
		}

		if($counter)
		{
			if($number_of_photos_in_row-$counter)
		$result_final .= "\t<td colspan='".($number_of_photos_in_row-$counter)."'>&nbsp;</td>\n";

			$result_final .= "</tr>";
		}
	}
}

// Full Size View of Photo
if( $pid )
{
	$result = mysql_query( "SELECT photo_caption,photo_filename FROM gallery_photos WHERE photo_id='".addslashes($pid)."'" );
	list($photo_caption, $photo_filename) = mysql_fetch_array( $result );
	$nr = mysql_num_rows( $result );
	mysql_free_result( $result );	

	if( empty( $nr ) )
	{
		$result_final = "\t<tr><td>No Photo found</td></tr>\n";
	}
	else
	{

		$result_final .= "<tr>\n\t<td align='center'>
				<br />
				<img src='".$images_dir."/".$photo_filename."' border='0' alt='".$photo_caption."' />
				<br />
				$photo_caption
				</td>
				</tr>";
	}
}

// Final Output
echo <<<__HTML_END

<html>
<head>
	<title>Gallery View</title>
</head>
<body>
<table width='100%' border='0' align='center' style='width: 100%;'>
$result_final		
</table>
</body>
</html>

__HTML_END;
?>

suntra

Here are some clue...

$total = (number of results;
$pp = 6; // number of results per page
$pages = floor($total / $pp) + (($total % $pp) ? 1 : 0); // number of pages
$page = (page number, let's say @$_REQUEST['page'])
$page = (($page < 1) ? 1 : (($page > $pages) ? $pages : $page)); // makes sure $page is valid, otherwise it corrects the value...
$offset = ($page - 1) * $pp; // returns the offset, so if page 1, offset will be 0, page 2, 6, etc.
$showPrevious = (($page > 1) ? true : false); // can the "Previous page" link be shown ?
$showNext = (($page < $pages) ? true : false); // can the "Next page" link be shown ?

For the second point, well you can set the target attribute to "_blank" or use javascript to open a pop-up window...

Roger_Ramjet

To open a new window you use target="_blank"

Up to you how you implement the back/next links:
you can pass the current page params in the link


$back_start = $start - $bypage;
$next_start = $start + $bypage;

echo '<a href="' . $_SERVER['PHP_SELF'] . '?start=' . $back_start . '" target="_blank">Back</a>';
echo '<a href="' . $_SERVER['PHP_SELF'] . '?start=' . $next_start . '" target="_blank">Next</a>';

Or you could just use buttons and calculate the back/next on the fly


if (isset($_POST['back'])) {
   $start = $start - $bypage;
}