Defining Grid Structure on Server Side

connector/php/grid_structure.png

Client side

index.html

<!DOCTYPE HTML>
<html>
   <head>
    <script src="codebase/dhtmlx.js" type="text/javascript"></script>
    <link rel="STYLESHEET" type="text/css" href="codebase/dhtmlx.css">
    <div id="gridbox" style="width:350px;height:250px";border:1px solid #A4BED4;></div>
 
    <script type="text/javascript"> 
     function doOnLoad(){
         var mygrid = new dhtmlXGridObject('gridbox');
         mygrid.setImagePath("codebase/imgs/");
         mygrid.setSkin("dhx_skyblue");
         mygrid.load("griddata.php");
     }
    </script>
   </head>
   <body onload="doOnLoad()">
   </body>
</html>

Server side

griddata.php

<?php 
require_once("../codebase/connector/grid_config.php");
require_once("../codebase/connector/grid_connector.php");
 
$res=new PDO("mysql:dbname=tasks;host=localhost","root","");
$conn = new GridConnector($res);
    $config = new GridConfiguration();
 
    $config->setHeader("Item Name,Item CD");
    $config->attachHeader("Item Name Test,#rspan");
    $config->attachFooter("Item Name,Item CD",
        Array("background: #ff0000;", "background: #00ff00;"));
    $config->attachFooter("Item Name Test,#rspan", "background: #0000ff;color:white;");
    $config->setColIds("col1,col2");
    $config->setInitWidths('120,*');
    $config->setColSorting("connector,connector");
    $config->setColColor("null,#dddddd");
    $config->setColHidden("false,false");
    $config->setColTypes("ro,ed");
    $config->setColAlign('center,center');
 
$conn->set_config($config);
$conn->render_table("grid50000","id","item_nm,item_cd");
 
?>