gallery options

keithface0

Hi Board,

I am trying to create a gallery that limits to 5, the number of thumbnails on each row, and only allows for 2 lines of thumbs.

i have more than 10 pictures per page though, but i don't know yet how to code those page numbers at the foot of the page to show that there are more pages 1 2 3 4 5 etc, with the page currently on being highlighted.

CAn anyone advise me on how this code might look?

Thanks k

my current code is:

<?php

$images = array();
$sql = mysql_query("SELECT * FROM news");

while($image = mysql_fetch_array($sql))
$images[] = $image;

$total = count($images);
for($i=0; $i<$total; $i++){
if($i % 5 == 0)
echo '<tr>';

echo '<td><img src="images/news/'.$images[$i]['newsimage'].'" border="2" width="150" height="150"></td>';

if($i % 5 == 1 || $i == $total - 1)
echo '</tr>';

	//this should SELECT * FROM `news`

}
?>

Matt_Kindig

EDIT: Silly mistake in my code. Fixed it now.

Basically, you need to determine the number of pages and create links to each of those pages. Something like this (untested). You should substitute PAGE NAME HERE with the name of your PHP script.

<?php
// gets page number
if (isset($_GET['page'])) { $page = $_GET['page']; }
else { $page = 1; }
$start = ($page-1)*10+1;
$images = array();
// gets the total number of images
$sql1 = mysql_query("SELECT COUNT(*) FROM news");
$num_images = $sql1[0];
$num_pages = ceil($num_images / 10);

// gets just the images for this page
$sql = mysql_query("SELECT * FROM news LIMIT $start, 10");

while($image = mysql_fetch_array($sql))
$images[] = $image;

$total = count($images);

for($i=0; $i<$total; $i++){
if($i % 5 == 0)
echo '<tr>';

echo '<td><img src="images/news/'.$images[$i]['newsimage'].'" border="2" width="150" height="150"></td>';

if($i % 5 == 1 || $i == $total - 1)
echo '</tr>';

//this should SELECT * FROM `news`
}

for($i=1; $i <= $num_pages; $i++) {
  if ($i == $page) {
     echo "<b>$i</b>";   // puts current page number in bold, no link
 } else {
     echo "<a href=\"PAGE NAME HERE.php?page=$i\">$i</a>";  // makes link for other pages
 }
}
?>

keithface0

thank Matt,

Thanks for replying so quickly 🙂 I'm off to print out your edited code now so i can check it out at a safe distance from my computer!

it'll probs take me a few hours before i can have anything more to say, but i'm excited about checking this code out.
thanks again, '
k

keithface0

Hi Board,

I have still been trying to create my gallery of thumbs that open in the same page to the right of the thumbs, but don't want to use tables.

Can i tweak my code here to output the thumbs, 5 per row, and 2 rows per page, [total of 10per page] , into an unordered list?

I have been successful with the pagination thanks to Matt Kindig's previous post, but am stuck on how to output the thumbs into <ul> tags.

any suggestions would be a relief,
thanks
k

<?php
include "dbconnect.php";

// how many rows to show per page
$rowsPerPage = 2;

// by default we show first page
$pageNum = 1;

// if $GET['page'] defined, use it as page number
if(isset($GET['page']))
{
$pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$query = "SELECT menimage FROM men LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');

// print the random numbers
// show the thumbnails in galleries
while($row = mysql_fetch_array($result))
{
//echo $row['menimage'] . '<br>';

	//this will 
	//echo "<td><a href='images/men/{$row['menimage']}'

	//<img src ='images/men/{$row['menimage']}' border='5'
	//width='100' height='100'></a></td>\n";


	//show all data from database with images
	//$accid=$row['menid'];
		//$mendescription=$row['mendescr'];
		$menimage=$row['menimage'];
		//$imageheight=$row['imageheight'];
		//$imagewidth=$row['imagewidth'];

			echo "<ul>";
//echo "<tr><td valign=’top’>\n";

//echo "<td>{$row['menid']}</td>\n";
//echo "<td>{$row['mendescr']}</td>\n";
echo "<li>{$row['menimage']}";

			echo "<a href='images/men/{$row['menimage']}'
			border='3' alt='images joeyd'>
			<img src ='images/men/thumb/{$row['menimage']}' border='1'
			width='57' height='75'></a>";

	//echo '<img src="images/men/'.$images[$i]['menimage'].'" border="2" width="150" height="150">';

}
echo '<br>';

// how many rows we have in database
// image database has fieldname of menimage, accimage, menimage
$query = "SELECT COUNT(menimage) AS numrows FROM men";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

// how many pages we have when using paging?
//The mathematical function ceil() is used to round up the value of $numrows/$rowsPerPage.
$maxPage = ceil($numrows/$rowsPerPage);

// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
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>";
}

}

// creating previous and next link
// plus the link to go straight to
// the first and last page

if ($pageNum > 1)
{
$page = $pageNum - 1;
// i've put [Prev] here but we can change this to joeyD home or something after.
$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";
//same here - this could read 1st Page ro something.
$first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // don't print 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 = ' '; // we're on the last page, don't print next link
$last = ' '; // don't print the last page link
}

// print the navigation link
echo $first . $prev . $nav . $next . $last;

// and close the database connection here