KoolGrid support data filtering feature. To enable this feature, you simply set AllowFiltering property to true. You can set this property in KoolGrid's instance, GridTableView's instance or in Column's instance.
- If you set the property in KoolGrid's instance, all columns in grid will enable filtering feature.
- If you set the property in GridTableView's instance, only columns in that table will enable filtering feature.
- If you set the property in Column's instance, only that column will enable filtering feature.
<?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->AjaxLoadingImage = $KoolControlsFolder."/KoolAjax/loading/5.gif";
$grid->AutoGenerateColumns = true;
$grid->AllowFiltering = true;//Enable filtering for all rows;
$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
$grid->Process();
?>
<form id="form1" method="post">
<?php echo $koolajax->Render();?>
<?php echo $grid->Render();?>
</form>
KoolGrid - Powerful PHP GridFullVersion 5.7.0.0 released on 25/11/2016