The example shows you how to color the row according to values given in databases.
span style="color: #808080; font-style: italic;">/*
* This file is ready to run as standalone example. However, please do:
* 1. Add tags <html><head><body> to make a complete page
* 2. Change relative path in $KoolControlFolder variable to correctly point to KoolControls folder
*/
$KoolControlsFolder = "../../../../KoolControls";//Relative path to "KoolPHPSuite/KoolControls" folder
"/KoolAjax/koolajax.php";
$koolajax->scriptFolder = $KoolControlsFolder."/KoolAjax""/KoolGrid/koolgrid.php""/KoolGrid/ext/datasources/MySQLiDataSource.php""/KoolCalendar/koolcalendar.php"//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = "select orderNumber,orderDate,status,comments from orders""update orders set orderDate='@orderDate', status='@status', comments='@comments' where orderNumber=@orderNumber";
$ds->DeleteCommand = "delete from orders where orderNumber=@orderNumber""grid");
$grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
$grid->styleFolder="sunset""655px""orderNumber""orderDate""orderDate""M d, Y";
//Assign datepicker for GridDateTimeColumn, this is optional.
"/KoolCalendar""sunset""M d, Y""status""Status";
$column->AddItem("In Process");
$column->AddItem("On Hold");
$column->AddItem("Disputed");
$column->AddItem("Cancelled");
$column->AddItem("Resolved");
$column->AddItem("Shipped""status""comments""Comments";
$column->Width = "200px""center""Inline";//"Inline" is default value;
"status""In Process""css_inprocess""On Hold""css_onhold""Disputed""css_disputed""Cancelled""css_cancelled""Resolved""css_resolved""Shipped""css_shipped""form1" method="post">
<style type="text/css"#A6D8F0;
#9BFF9B;
#9BFF9B;
#FFE88C;
#FF9D9D;
#E0E0E0;
KoolGrid - Powerful PHP GridFullVersion 5.7.0.1 released on 05/19/2017