[PHP] pobierz, plaintext 
  Ť Previous 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Next ť 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
	// Find all photos
	$photos = Photograph::find_all();
?>
<?php
 
	// 1. the current page number ($current_page)
	$page = !empty($_GET['page']) ? (int)$_GET['page'] : 1;
 
	// 2. records per page ($per_page)
	$per_page = 2;
 
	// 3. total record count ($total_count)
	$total_count = Photograph::count_all();
 
 
	// Find all photos
	//$photos = Photograph::find_all();
 
	$pagination = new Pagination($page, $per_page, $total_count);
 
	// Instead of finding all records, just find the records 
	// for this page
	$sql = "SELECT * FROM photographs ";
	$sql .= "LIMIT {$per_page} ";
	$sql .= "OFFSET {$pagination->offset()}";
	$photos = Photograph::find_by_sql($sql);
 
)
 
 
 
?>
--------------
nawigacja
<?php
	if($pagination->total_pages() > 1) {
 
		if($pagination->has_previous_page()) { 
    	echo "<a href=\"list_photos.php?page=";
      echo $pagination->previous_page();
      echo "\">&laquo; Previous</a> "; 
    }
 
		for($i=1; $i <= $pagination->total_pages(); $i++) {
			if($i == $page) {
				echo " <span class=\"selected\">{$i}</span> ";
			} else {
				echo " <a href=\"list_photos.php?page={$i}\">{$i}</a> "; 
			}
		}
 
		if($pagination->has_next_page()) { 
			echo " <a href=\"list_photos.php?page=";
			echo $pagination->next_page();
			echo "\">Next &raquo;</a> "; 
    }
 
	}
 
?>
 
 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
 
// This is a helper class to make paginating 
// records easy.
class Pagination {
 
  public $current_page;
  public $per_page;
  public $total_count;
 
  public function __construct($page=1, $per_page=20, $total_count=0){
  	$this->current_page = (int)$page;
    $this->per_page = (int)$per_page;
    $this->total_count = (int)$total_count;
  }
 
  public function offset() {
    // Assuming 20 items per page:
    // page 1 has an offset of 0    (1-1) * 20
    // page 2 has an offset of 20   (2-1) * 20
    //   in other words, page 2 starts with item 21
    return ($this->current_page - 1) * $this->per_page;
  }
 
  public function total_pages() {
    return ceil($this->total_count/$this->per_page);
	}
 
  public function previous_page() {
    return $this->current_page - 1;
  }
 
  public function next_page() {
    return $this->current_page + 1;
  }
 
	public function has_previous_page() {
		return $this->previous_page() >= 1 ? true : false;
	}
 
	public function has_next_page() {
		return $this->next_page() <= $this->total_pages() ? true : false;
	}
 
 
}
 
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
public static function count_all() {
	  global $database;
	  $sql = "SELECT COUNT(*) FROM ".self::$table_name;
    $result_set = $database->query($sql);
	  $row = $database->fetch_array($result_set);
    return array_shift($row);
	}
 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
for($i=1; $i <= $pagination->total_pages(); $i++) {
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
for($i=1; $i <= 10; $i++) {
[PHP] pobierz, plaintext 

Cytat(Turson @ 20.09.2013, 15:42:38 )

[PHP] pobierz, plaintext 
for($i=1; $i <= $pagination->total_pages(); $i++) {
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
for($i=1; $i <= 10; $i++) {
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$start = $page - 5;
if ($start < 1) $start = 1;
$end = $page+5;
if ($end > $pagination->total_pages()) $end = $pagination->total_pages();
 
for($i=$start; $i <= $end; $i++) {
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 1 2 3 4 5 6 Next ? 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 ? Previous 3 4 5 6 7 8 9 10 11 12 13 Next ? 
[PHP] pobierz, plaintext