Get KoolPHP UI with 30% OFF!

Get started with KoolGrid

Peter
Assume you have a customers table in your database called mydata
Here is the code to get started with KoolGrid:
<?php
	//Step 1: Register KoolGrid component to your page
	require "KoolControls/KoolGrid/koolgrid.php";
	require "KoolControls/KoolAjax/koolajax.php";
	$koolajax->scriptFolder = "KoolControls/KoolAjax";
	
	//Step 2: Create datasource
	$db_con = mysql_connect('localhost','root','root');
	mysql_select_db('mydata',$db_con);
	$ds = new MySQLDataSource($db_con);
	$ds->SelectCommand = "select customerNumber,customerName,phone,city from customers";
 
	//Step 3: Init KoolGrid and settings
	$grid = new KoolGrid("grid");
	$grid->scriptFolder = "KoolControls/KoolGrid";
	$grid->styleFolder="default";
	$grid->DataSource = $ds;
	$grid->AjaxEnabled = true;
	$grid->Width = "655px";
	$grid->AllowInserting = true;
	$grid->AllowSorting = true;
	$grid->AutoGenerateColumns = true;
	$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
	
	
	//Step 4: Process Grid
	$grid->Process();
?>
 
<html>
    <head>
        <title></title>
        <?php echo $koolajax->Render();?>
    </head>
    <body>
        <form id="form1" method="post">
            <!-- Step 5: Get KoolGrid render -->
            <?php echo $grid->Render();?>
        </form>
    </body>
</html>
Posted Dec 3, 2015 Kool -
Devaraj
Greetings Mr.Peter,
I am using Koolphp 8.9 and deployed KoolGrid on Prod which doesn't seem have performance as in local env.Yes,have used column filters as well.Are there recommended settings for KoolGrid which improves performance?
Posted May 6, 2020 Kool -
Anthony Amolochitis
I have really good performance with mine. How many records are in your query?
Just curious.
I use MariaDB with mysqli.
Posted Jul 24, 2020 Kool