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

When you have a lot of horizontal columns and you hate to scroll back and forth to read information at last column and match them with the one at first column, the Frozen Columns feature will be the saver.

Simply set the number of first columns you want to be frozen with FrozenColumnsCount, you have turned on the feature:

$grid->MasterTable->FrozenColumnsCount = 2; // You want first 2 columns are frozen

<?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,addressLine1, city, country from customers";
 
	$grid = new KoolGrid("grid");
	$grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
	$grid->styleFolder="sunset";
	$grid->DataSource = $ds;
	$grid->AjaxEnabled = true;
	$grid->AllowFiltering = true;
 
	$grid->AllowResizing = true;
	$grid->Width = "655px";
	$grid->PageSize = 20;
	$grid->RowAlternative = true;
	$grid->AutoGenerateColumns = true;
	$grid->MasterTable->ColumnWidth = "180px";
 
	$grid->AllowScrolling = true;
	$grid->MasterTable->Height = "300px";
 
	$grid->MasterTable->FrozenColumnsCount = 2;
 
 
	$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();	
	$grid->Process();
?>
 
<form id="form1" method="post">
	<?php echo $koolajax->Render();?>
	<?php echo $grid->Render();?>
</form>

• • KoolGrid::AllowScrolling
• • GridTableView::AllowScrolling