asked on

Complicated pagination and data listing

I need to display the column on the right with pagination.

Every company has an listid like, http://www.website.com/getbranch.php?listid=12345 and to check whether this company have a branch I:

SELECT * FROM customer_branch WHERE Branch='1' AND LISTING_ID = $listid

OmniUnlimited

I use the following code for pagination:

function show_pages($pages, $link_url, $curpage, $show_word=true) {
    // shows page numbers
    $output = "<div class='page_numbers'>\n\r";
    $output .= "<span class='flatview'>\n\r";
	if ($curpage > 1) {
	  	$prev = $curpage - 1;
	    $output .= "<a href='".$link_url."&page_number=$prev' >&laquo;";
		if ($show_word) { $output .= " Prev"; }
		$output .= "</a>\n\r";
	}
    for($i=1;$i<=$pages;++$i) {
      if ($curpage == $i) {
        if($_GET['view_all'] != 'true') {
          $selected = "class='selected'";
		} else {
    	  $selected = "class='notselected'";
	  	}
	  } else {
         $selected = "class='notselected'";
	  }
	  if ($i > 1) {
		 if ($pages > 13) {
				if ($curpage > 7) {
					if ($i == 3) {
						$output .= '...&nbsp;';
						continue;
					}
					if ($curpage < $pages - 7) {
						if ($i < 3) {
							$output .= "  <a href='".$link_url."&page_number=$i' $selected >$i</a>\n\r";
							continue;
						}
						if ($i < $curpage - 3) {
							continue;
						}
						if (($i > $curpage + 3) && ($i < $pages - 2)) { 
							continue; 
						}
						if ($i == $pages - 2) {
							$output .= '...&nbsp;';
							continue;
						}
					} else {
						if ($i < 3) {
							$output .= "  <a href='".$link_url."&page_number=$i' $selected >$i</a>\n\r";
							continue;
						}
						if ($i < $pages - 9) {
							continue;
						}
					}
				} else {
					if (($i > 10) && ($i < $pages - 2)) { 
						continue; 
					}
					if ($i == $pages - 2) {
						$output .= '...&nbsp;';
						continue;
					}
				}
			}
		}
      $output .= "  <a href='".$link_url."&page_number=$i' $selected >$i</a>\n\r";
	}    
	if ($curpage < $pages) {
	  	$next = $curpage + 1;
	    $output .= "<a href='".$link_url."&page_number=$next' >";
		if ($show_word) { $output .= "Next "; }
		$output .= "&raquo;</a>\n\r";
	}
    $output .= "</span>\n\r";
    $output .= "</div>\n\r";
	return $output;
}

Open in new window

To utilize it, simply define some of the following variables:

$url = "http://www.website.com/getbranch.php?listid=12345";
         $sql = "SELECT * FROM customer_branch WHERE Branch='1' AND LISTING_ID = $listid";
         if (!$tbl = mysql_query($sql))
         {
             $errmsg = mysql_errno() . ' ' . mysql_error();
             echo "<br/>QUERY FAIL: ";
             echo "<br/>$sql <br/>";
             die($errmsg);
         }
 	$max_lines = 20;
	$total_rec = count($tbl);
	$pages = ceil($total_rec / $max_lines);
	$item_no = 0;
	$line_no = 0;
	if(isset($_GET['page_number'])) {	
		$curpage = $_GET['page_number'];
	} else {
		$curpage = 1;
	}
	$start = (($curpage - 1) * $max_lines) + 1;
	if ($pages > 1) {
		$end = $start + $max_lines - 1;
		if ($end > $total_rec) { $end = $total_rec; }
		echo "<div class='tablenav-pages'>";
		echo "<span class='displaying-num'>";
		echo "Displaying " . $start . "-" . $end . " of " . $total_rec;
		echo "</span>";
		echo show_pages($pages, $url, $curpage, false);
		echo "</div>";
	}
	foreach($tbl as $row) {
		$item_no++;
		if ($item_no < $start) { continue; }
		$line_no++;
		if ($line_no > $max_lines) { break; }
                  // your code to display the list
         }