!--www--CodeThatGrid - Grid Generation from the Database Example!--www/--!--all--code that works!!--all/--

<?

function create_definition()
{
 global $db;

 $definition = "";

 $result = mysql_query("select * from test_data");
 
 $data = "[";

 $num_result = mysql_num_fields ($result);

 for($i=0; $i<$num_result; $i++)
 {
   if($i>0) $data .= ', ';
   $data .= '["' . @mysql_result($result, $i, "id") . '", ' . 
            '"' . @mysql_result($result, $i, "username") . '", ' . 
            '"' . @mysql_result($result, $i, "email") . '"]';
 }

 $data .= ']';

 $result2 = db_query("select * from test_structure");
 
 $coldef = "[";

 $num_result2 = db_numrows($result2);

 for($i=0; $i<$num_result2; $i++)
 {
   if($i>0) $coldef .= ', ';
   $coldef .= '{title: "' . db_result($result2, $i, "title") . 
              '", titleClass: "", type: "' . db_result($result2, $i, "col_type") . 
		      '", width: ' . db_result($result2, $i, "col_width") . 
	          ', alignment: "' . db_result($result2, $i, "col_alignment") . 
         	  '", compareFunction: compare, isVisible: true, '.
              ' useAutoIndex: false, useAutoFilter: false } ';
 }

 $coldef .= ']';

 $definition = "var gridDef={ useExportBar :false, useMultiSort:true, 
                useColTitle: true, data: $data, colDef: $coldef ";
  
 $definition .= ', rowStyle : {	markClass:  "mark",	darkClass:  "dark",	' .
                ' lightClass: "light", hoverClass: "hover"}, 
                  tablestyle : {tableClass:{borderwidth:"2",borderstyle:"solid",
                  bordercolor:"#bbbbbb",backgroundcolor:"#ffffff"},
                  thClass : {fontfamily:"Verdana", fontsize:"12px", color:"#000000", 
                  borderwidth:"1", borderstyle: "solid", bordercolor: "#cfcfcf", 
                  backgroundcolor:"#ececec"}, tdClass : {fontfamily:"Verdana", 
                  fontsize:"12px", color:"#000000"}, bgcolor : "#bbbbbb", 
                  x : 0, y : 0, width: 660, height: 480}};';
               	
 return $definition;
}

?>
       
<html>
 <head>
  <title>Grid Test</title>
  <script language="javascript" src="/codethatsdk.js"></script>  
  <script language="javascript" src="codethattype.js"></script>         
  <script language="javascript" src="codethatgridpro.js"></script>   
  <link rel="stylesheet" href="style.css">  
  <link href="/common_codethat.css" rel="stylesheet" type="text/css">
  <script language="javascript1.2">
   var DATE_FORMAT = "dd.mm.yyyy";
   var EMPTY_ROW = "...";
   var DEFAULT_COLDEF = {
   title: "",
   titleClass: "",
   type: "String", //the default type
   width: 0, //auto
   alignment: "", //auto
   compareFunction: compare,
   isVisible: true,
   useAutoIndex: true,
   useAutoFilter: false
  }; 

   <? echo create_definition(); ?> 
   
  </script> 
 </head>
 <body>
  
   <script language="javascript">
    var g = new CCodeThatGrid("g", 5, 6);            
    g.init(gridDef);      
    g.doAction();    
   </script>       
  
<pre>
</pre>

 </body>
</html>