KoolGrid - Powerful PHP GridFullVersion 4.0.0.0 released on 04/16/2012

Paging - Pager Position

Select position:

First Prev 1 2 3 4 5 6 7 8 9 10 ... Next Last

Page 1 in 13, items 1 to 10 of 121.

customerNumber	customerName	phone	city
112	Signal Gift Stores	7025551838	Las Vegas
114	Australian Collectors, Co.	03 9520 4555	Melbourne
119	La Rochelle Gifts	40.67.8555	Nantes
121	Baane Mini Imports	07-98 9555	Stavern
124	Mini Gifts Distributors Ltd.	4155551450	San Rafael
125	Havel & Zbyszek Co	(26) 642-7555	Warszawa
128	Blauer See Auto, Co.	+49 69 66 90 2555	Frankfurt
129	Mini Wheels Co.	6505555787	San Francisco
131	Land of Toys Inc.	2125557818	NYC
141	Euro+ Shopping Channel	(91) 555 94 44	Madrid

Description & Sample code

Description Example.php Documentation

KoolGrid's pager can be shown at either top,bottom or both places of the grid.

$grid->MasterTable->Pager->Positon = "top";
$grid->MasterTable->Pager->Positon = "bottom";
$grid->MasterTable->Pager->Positon = "top+bottom";

<?php
	/*
	 * This file is ready to run as standalone example. However, please do:
	 * 1. Add tags <html><head><body> to make a complete page
	 * 2. Change relative path in $KoolControlFolder variable to correctly point to KoolControls folder 
	 */
 
	$KoolControlsFolder = "../../../../KoolControls";//Relative path to "KoolPHPSuite/KoolControls" folder
	
	require $KoolControlsFolder."/KoolAjax/koolajax.php";
	$koolajax->scriptFolder = $KoolControlsFolder."/KoolAjax";
 
	require $KoolControlsFolder."/KoolGrid/koolgrid.php";
	$ds = new MySQLDataSource($db_con);//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
	$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers";
 
	$grid = new KoolGrid("grid");
	$grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
	$grid->styleFolder="sunset";
	$grid->DataSource = $ds;
	$grid->Width = "655px";
 
	$grid->RowAlternative = true;
 
	$grid->AjaxEnabled = true;
	$grid->AutoGenerateColumns = true;
	
	if(isset($_POST["position_select"]))
	{
		$_SESSION["position_select"] = $_POST["position_select"];
	}
	else
	{
		if (!$koolajax->isCallback)
		{
			//Page Init: show default position as top
			$_SESSION["position_select"] = "top";
		}
	}
 
	//Pager settings
	$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
	$grid->MasterTable->Pager->Position = $_SESSION["position_select"];
 
 
	$grid->Process();
?>
 
<form id="form1" method="post">
	<?php echo $koolajax->Render();?>
 
	Select position:
	<select id="position_select" name="position_select" onchange="submit();">
		<option value="top"		<?php if ($_SESSION["position_select"]=="top") echo "selected" ?> >Top</option>
		<option value="bottom"		<?php if ($_SESSION["position_select"]=="bottom") echo "selected" ?> >Bottom</option>
		<option value="top+bottom"		<?php if ($_SESSION["position_select"]=="top+bottom") echo "selected" ?> >Top+Bottom</option>
	</select>
 
	<div style="padding-top:10px;">
		<?php echo $grid->Render();?>
	</div>
</form>

Spend Less, Code Few, Deliver HUGE !!!

Take your time to experience the power of KoolPHPSuite with full-functional & time-unlimited trial version.

Download your KoolPHPSuite trial and start your development with suite examples and the help of documentation and forums.

To acquire suite license, please visit our purchase page.

If you have any questions, do not hesitate to contact us at sales@koolphp.net.