All pastes #811335 Raw Edit

Something

public text v1 · immutable
·published 2007-12-10 20:36 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 = '';

	for($page = 1; $page <= $maxPage; $page++)
	{ if ($page == $pageNum)
	{ $nav .= "<font color=\"#ffffff\">(</font><font class=\"large-white\"> $page </font><font color=\"#ffffff\">)</font>"; }

	else
	{ $nav .= "<a href=\"$self?page=$page\"><b> $page </b></a>"; }
	}

	if ($pageNum > 1)
	{ $page = $pageNum - 1;
	  $prev = " <a href=\"$self?page=$page\"><b><</b></a>&nbsp&nbsp&nbsp&nbsp";
	  $first = " <a href=\"$self?page=1\"><b><<</b></a>&nbsp&nbsp&nbsp&nbsp"; }

	else
	{ $prev  = "<font color=\"#AAAAAA\"><b><</b></font>&nbsp&nbsp&nbsp&nbsp";
	  $first = "<font color=\"#AAAAAA\"><b><<</b></font>&nbsp&nbsp&nbsp&nbsp"; }

	if ($pageNum < $maxPage)
	{ $page = $pageNum + 1;
	  $next = " <a href=\"$self?page=$page\">&nbsp&nbsp&nbsp&nbsp<b>></b></a> ";
	  $last = " <a href=\"$self?page=$maxPage\">&nbsp&nbsp&nbsp&nbsp<b>>></b></a> "; }

	else
	{ $next = "&nbsp&nbsp&nbsp&nbsp<font color=\"#AAAAAA\"><b>></b></font>";
	  $last = "&nbsp&nbsp&nbsp&nbsp<font color=\"#AAAAAA\"><b>>></b></font>"; }

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