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""/KoolChart/koolchart.php"//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = "select customerNumber,customerName from customers""grid");
$grid->scriptFolder = $KoolControlsFolder."/KoolGrid""215px""customerName""Customers""sunset";
$grid->ClientSettings->ClientEvents["OnRowSelect"] = "Handle_OnRowSelect""customerNumber""customerNumber""customerNumber""select productName, priceEach*quantityOrdered as spent from customers,orders,orderdetails,products where customers.customerNumber=orders.customerNumber and orders.orderNumber=orderdetails.orderNumber and orderdetails.productCode=products.productCode and customers.customerNumber=$customerNumber group by products.productCode limit 9""productName""spent""chart");
$chart->scriptFolder=$KoolControlsFolder."/KoolChart""Money spent per product""$ {0}""""#B94003""$ {0}""$ {0}""form1" method="post""padding-top:35px;float:left;">
<script type="text/javascript""Row""customerNumber""customerNumber""padding-left:5px;float:left""chart_panel""<?php echo $KoolControlsFolder;?>/KoolAjax/loading/5.gif""clear:both;"></div>
<div><i>* <u>Note</u>:</i>Generate your own chart with <a style="color:#B8305E;" target="_blank" href="http://codegen.koolphp.net/generate_koolchart.php"