All pastes #811342 Raw Edit

Someone

public text v1 · immutable
·published 2007-12-10 20:42 UTC
rendered paste body
function list_5_photos($server, $db_user, $db_pass, $database, $photo_table, $siteurl, $photo_dir, $thumb_dir) {

	$rowsPerPage = 12;
	$pageNum = 1;

	if(isset($_GET['page'])) { $pageNum = $_GET['page']; }

	$pageNum = strip_tags($pageNum);
	$pageNum = htmlspecialchars($pageNum, ENT_QUOTES);
	$pageNum = trim($pageNum);

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


// Get photo file names and crap

	connect($server, $db_user, $db_pass, $database);
	$sql  = "SELECT * FROM $photo_table ORDER BY id DESC LIMIT $offset, $rowsPerPage";
	$result = mysql_query($sql) or die('Error, query failed @ 128!');

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

	$filename = $row['photo'];
	$text = $row['text'];
	$title = $row['title'];

	}

// Get number of pages based on $rowsPerPage

	$query   = "SELECT COUNT(photo) AS numrows FROM $photo_table WHERE cat <> 'main'";
	$result  = mysql_query($query) or die('Error, query failed @115');
	$row     = mysql_fetch_array($result, MYSQL_ASSOC);
	$numrows = $row['numrows'];

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

	$self = $_SERVER['PHP_SELF'];
	$nav = '';

// Logic is there a previous and next page available

	for($page = 1; $page <= $maxPage; $page++)
	{ if ($page == $pageNum)
	{ $nav .= "( $page )"; }

	else
	{ $nav .= "$page"; }
	}

	if ($pageNum > 1)
	{ $page = $pageNum - 1;
	  $prev = " cant go back";
	  $first = " cant go all the way back"; }

	else
	{ $prev  = "";
	  $first = "go back"; }

	if ($pageNum < $maxPage)
	{ $page = $pageNum + 1;
	  $next = " cant go forward ";
	  $last = " cant go all the way forward "; }

	else
	{ $next = "go forward";
	  $last = "go all the way forward"; }

// Print results

	echo "<center><table CLASS=\"pages\" CELLSPACING=\"1\">
	<tr>
	<td CLASS=\"pages-links\">";
	echo $first . $prev . $nav . $next . $last;
	echo "</td></tr></table></center>";
}