CodeThatTable - Table Generation from the Database Example
<?php
require('code_html.php');
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 = mysql_query("select * from test_structure");
$coldef = "[";
$num_result2 = mysql_num_fields($result2);
for($i=0; $i<$num_result2; $i++)
{
if($i>0) $coldef .= ', ';
$coldef .= '{title: "' . @mysql_result($result2, $i, "title") .
'", titleClass: "", type: "' . @mysql_result($result2, $i, "col_type") .
'", width: ' . @mysql_result($result2, $i, "col_width") .
', alignment: "' . @mysql_result($result2, $i, "col_alignment") .
'", compareFunction: compare, isVisible: true, '.
' useAutoIndex: false, useAutoFilter: false } ';
}
$coldef .= ']';
$definition = "var gridDef={ amountPerPage:5, useMultiSort:false, data: $data, colDef: $coldef ";
$definition .= ', keyCol : "ID", rowStyle : { markClass: "mark", darkClass: "dark", ' .
' lightClass: "light", hoverClass: "hover"}};';
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="codethattablepro.js"></script>
<link rel="stylesheet" href="style.css">
<script language="javascript1.2"> <? echo create_definition(); ?> </script>
</head>
<body>
<script language="javascript">
var CodeThatTable = new CCodeThatTable("CodeThatTable");
CodeThatTable.loadData(gridDef);
CodeThatTable.doAction();
</script>
</body>
</html>