Entry

How do I break up the item listing into multiple pages of n items each?

Jul 21st, 2000 04:42
C Walker,

In my case I am splitting it into 10 items per 
page, in 2 columns, but you can change that to whatever you want 
by changing the vars $NumItemsPerPage, $Rows, and $Cols.
This goes in modules/screens/department, overwriting everything 
from the line "//show items in this department" til the end....the 
stuff I added is highlighted with comments starting with CW
Enjoy!
------------
	//show items in this department
	/* CW - Only show 10 items per screen in a 2x5 table */
	$NumItemsPerPage = 10;
	$Rows = 5;
	$Cols = 2;
	if (!isset($StartItem)) {
		$StartItem = 0;
	}
	/* CW - made 3 query strings so I didn't have to rewrite the
		query for the count :) */
	$Query = "SELECT i.ID, i.Name, i.Thumbnail ";
	$Query2 = "FROM item i, department_item di ";
	$Query2 .= "WHERE di.Department = $department ";
	$Query2 .= "AND i.ID = di.Item ";
	$Query3 = "ORDER BY i.DisplayPrecedence, i.Name ";
	/* CW - add limit */
	$Query3 .= "LIMIT $StartItem, $NumItemsPerPage";
	$DatabaseResult = mysql_query($Query . $Query2 . $Query3, 
$DatabaseLink);
	/* CW - If there are no items in this department don't bother */
	if (mysql_numrows($DatabaseResult)>0) { 
		/* CW - get total number of items */
		$Query = "SELECT count(i.ID) AS Number " . $Query2;
		$Result = mysql_query($Query, $DatabaseLink);
		$TotalNumber = mysql_result($Result, 0, "Number");
		/* CW - print Numbers, and Next/Prev Links */
		/* todo: make this a function so I can do it at the top 
and 
the bottom of the items table */
		print("<BR>\n<TABLE ROWS=1 COLS=3 WIDTH=100% 
BORDER=0>\n");
		print("\t<TR><TD WIDTH=33% ALIGN=\"left\">");
		/* CW - Prev Link if necessary */
		if ($StartItem>0) {
			print("<A 
HREF=\"".ScreenURL("department")."&department=$department&S
tartItem=" . ($StartItem-$NumItemsPerPage) . "\">Prev</A>");
		}
		print("</TD>\n\t<TD WIDTH=33% ALIGN=\"center\">");
		print("Items " . ($StartItem + 1) . " - ");
		if (($StartItem + $NumItemsPerPage) > $TotalNumber) {
			print($TotalNumber);
		} else {
			print($StartItem + $NumItemsPerPage);
		}
		print(" of $TotalNumber");      
		print("</TD><TD WIDTH=33% ALIGN=\"right\">");
		/* CW - Next link if necessary */
		if ($TotalNumber>($StartItem+$NumItemsPerPage) ) {
			print("<A 
HREF=\"".ScreenURL("department")."&department=$department&S
tartItem=" . ($StartItem+$NumItemsPerPage) . "\">Next</a>");
		}
		print("</TD></TR>\n</TABLE>\n<BR>\n");
		/* CW - print a table 2x5 */	
		print("<TABLE ROWS=$Rows COLS=$Cols WIDTH=100% 
BORDER=0>\n");
		$i = 1;	
	/* CW - I was too lazy to indent all this too :)  */	
	while($DatabaseRow = mysql_fetch_object($DatabaseResult))
	{
	    	if (($i % $Cols) == 1 ) {
			/* CW - first item, left columm, start a new 
row */
			print("\t<TR>\n");
	    	}
	    	print("\t\t<TD VALIGN=\"top\">");
		print("<A 
HREF=\"".ScreenURL("item")."&item=$DatabaseRow->ID\">");
		if(($DatabaseRow->Thumbnail) AND 
			file_exists(ITEM_IMAGES_DIR . "/" . 
$DatabaseRow-
>Thumbnail))
		{
			$Thumbnail_Graphic_size = 
getimagesize(ITEM_IMAGES_DIR . "/" . $DatabaseRow-
>Thumbnail);
			print("<IMG SRC=\"" . ITEM_IMAGES_DIR . "/" . 
$DatabaseRow->Thumbnail . "\"");
			print(" $Thumbnail_Graphic_size[3] BORDER=\"0\" 
ALIGN=\"left\">\n");
		} else {
			/* CW - print NoImage holder */
			print("<IMG SRC=\"" . ITEM_IMAGES_DIR . 
"/NoImage.gif\" WIDTH=100 HEIGHT=99 BORDER=0 
ALIGN=\"left\">\n" );
		}
		print("<B>$DatabaseRow->Name</B>");
		print("</A>");
		print("<BR CLEAR=\"all\">\n");
		print("<BR>\n");
		print("</TD>\n");
	 	if (($i % $Cols) == 0 ) {
                        /* CW - even-numbered item, right columm, end 
row */
                        print("\t</TR>\n");
                }    		
		$i++;
	} //end while
	print("</TABLE>");
	} //end if
?>