Check documentation for the latest version 6.0 of dhtmlxSuite Defining Grid Structure on Server Side DHTMLX Docs

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");
 
?>
Back to top