Skip to content

kurti-vdb/Paginator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 

Repository files navigation

##Pagination over collections Php paginator-class to manage collections.

###Typical Usage

<?php
	
	//Load our paginator-class
	require_once("paginator.class.php");
	
	//Make some database connection, in this case MySQL
	$connection = mysql_connect('url','password','');
	$database = mysql_select_db('Database_name',$connection);
	
	//Count your items
	$query ="SELECT COUNT(*) FROM table_name";
	$result = mysql_query($query, $connection);
	$r = mysql_fetch_row($result);
	
	//Get current page from url
	if (isset ($_GET['page']))
		$page = (int)$_GET['page'];
	else $page = 1;
	
	//Create Paginator-object and fill it
	$pages = new Paginator;
	$pages->setItemsPerPage=8;
	$pages->setMaxItems($r[0]);
	$pages->setMidRange = 3;
	$pages->setCurrentpage($page);
	
	//Print paginator to screen
	echo $pages->showPaginationMenu();
	
	//Load data
	$query = "SELECT * FROM table_name ORDER BY column_name DESC LIMIT " . $pages->getStartingIndex() . ", " . $pages->getItemsPerPage() . "";
	$result = mysql_query($query, $connection);
	$result = mysql_query($query);
	
	//Print data to screen
	$htmlcode ="";
	while ($r = mysql_fetch_array($result)){
		$htmlcode .= "<div class=\"someClass\" >" . $r['itemName'] . "</div>";
	}
	echo $htmlcode;
	
?>

###Gives you something like


		<< previous 1...678...13 next >>
		
				itemName 1
				itemName 2
				itemName 3
				itemName 4
				itemName 5
				itemName 6
				itemName 7
				itemName 8
				
				

###Demo

You can find this paginator class in action on www.cocktailplanet.org You can even style your paginator with some css.

About

php paginator class

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages