KoolGrid supports auto-generating columns from your database. This feature is extremely useful in saving your time.
- - $AutoGenerateColumns : Create columns base on the sql query
- - $AutoGenerateRowSelectColumn : Create Row Select Column
- - $AutoGenerateDeleteColumn : Create Delete button column
- - $AutoGenerateEditColumn : Create Edit button column
- - $AutoGenerateExpandColumn : Create DetailTable Expand Column
span style="color: #ff0000;">"/KoolAjax/koolajax.php";
$koolajax->scriptFolder = $KoolControlsFolder."/KoolAjax""/KoolGrid/koolgrid.php"//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = "select customerNumber as pk, customerNumber,customerName,phone,city from customers""update customers set customerNumber=@customerNumber, customerName='@customerName', phone='@phone', city='@city' where customerNumber=@pk";
$ds->DeleteCommand = "delete from customers where customerNumber=@pk";
$ds->InsertCommand = "insert into customers (customerNumber,customerName,phone,city) values (@customerNumber,'@customerName','@phone','@city');""grid");
$grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
$grid->styleFolder="default""655px""pk""form1" method="post"