dhtml Grid serverseitig erstellen mit MySQL Datenquelle

title: “dhtml Grid serverseitig erstellen mit MySQL Datenquelle”
date: 2014-05-25T08:26:38
slug: dhtml-grid-serverseitig-erstellen-mit-mysql-datenquelle

HTML Code für das Grid:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 <script src="codebase/dhtmlxcommon.js"></script>
 <script src="codebase/dhtmlxgrid.js"></script>
 <script src="codebase/connector.js"></script>
 <link rel="STYLESHEET" type="text/css" href="codebase/dhtmlxgrid.css">
 <link rel="stylesheet" type="text/css" href="codebase/skins/dhtmlxgrid\_dhx\_black.css">

 <script type="text/javascript">

 function doOnLoad(){
 var mygrid = new dhtmlXGridObject('gridbox');
 mygrid.setImagePath("codebase/imgs/");
 mygrid.setSkin("dhx\_skyblue");
 mygrid.load("ajax.php?action=loadData");
 }
 </script>
</head>
<body onload="doOnLoad()">
 <div id="gridbox" style="width:350px;height:250px;border:1px solid #A4BED4;"></div>
</body>
</html>

griddata.php

<?php
require\_once("../codebase/connector/grid\_config.php");
require\_once("../codebase/connector/grid\_connector.php");

$res=mysql\_connect("localhost","root","");
mysql\_select\_db("tasks");
$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");

?>