KoolGrid - Powerful PHP GridFullVersion 5.7.0.0 released on 25/11/2016

KoolGrid support various type of pagers which you can choose. To use PrevNextAndNumeric pager in MasterTable, you set:

<?php
	require $KoolControlsFolder."/KoolAjax/koolajax.php";
	$koolajax->scriptFolder = $KoolControlsFolder."/KoolAjax";
 
	require $KoolControlsFolder."/KoolGrid/koolgrid.php";
	require $KoolControlsFolder."/KoolGrid/ext/datasources/MySQLiDataSource.php";
	$ds = new MySQLiDataSource($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="default";
	$grid->DataSource = $ds;
	$grid->Width = "655px";
 
	$grid->RowAlternative = true;
 
	$grid->AjaxEnabled = true;
	$grid->AutoGenerateColumns = true;
 
	//Pager settings
	$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
	$grid->MasterTable->Pager->ShowPageSize = true;	
	$grid->MasterTable->Pager->ShowPageOverlap = true;	
    $grid->MasterTable->Pager->PageOverlap = 2;
	$grid->MasterTable->Pager->PageOverlapOptions = "0,1,2,3,4,5";
 
	$grid->Process();
?>
 
<form id="form1" method="post">
	<?php echo $koolajax->Render();?>
	<?php echo $grid->Render();?>
</form>

• • GridPager
• • GridPrevNextAndNumericPager