2 if (!isset ($_SESSION)) session_start();
\r
4 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
\r
7 <title>Rico-Table Detail</title>
\r
9 <link href="../demo.css" type="text/css" rel="stylesheet" />
\r
12 require "dbConnect.php";
\r
13 require "LoadRicoClient.php";
\r
19 if (isset($_GET["id"]) && OpenDB()) {
\r
20 $id=trim($_GET["id"]);
\r
21 $arColumns=$oDB->GetColumnInfo($id);
\r
22 for ($i=0; $i<count($arColumns); $i++) {
\r
23 $coltype=$arColumns[$i]->ColType;
\r
24 if ($coltype=='image' || $coltype=='text' || $coltype=='ntext') continue;
\r
25 if (!empty($columnlist)) {
\r
29 $columnlist.=$arColumns[$i]->ColName;
\r
30 //$colspecs.="{Hdg:'".$coltype."'"; // for debugging
\r
31 $colspecs.="{Hdg:'".$arColumns[$i]->ColName."'";
\r
32 if ($coltype == "DATETIME") {
\r
33 $colspecs.=",type:'datetime'";
\r
37 $_SESSION[$id]="select ".$columnlist." from ".$id." order by ".$arColumns[0]->ColName;
\r
43 <script type='text/javascript'>
\r
44 Rico.onLoad( function() {
\r
46 useUnformattedColWidth: false,
\r
48 highlightElem: 'cursorRow',
\r
55 var buffer=new Rico.Buffer.AjaxSQL('ricoQuery.php', {TimeOut:<?php print array_shift(session_get_cookie_params())/60 ?>});
\r
56 var grid=new Rico.LiveGrid ('<?php echo $id; ?>', buffer, opts);
\r
57 grid.menu = new Rico.GridMenu();
\r
61 <style type="text/css">
\r
62 html { border: none; }
\r
71 <p><strong><?php echo $id; ?></strong>
\r
72 <p class="ricoBookmark"><span id='<?php echo $id; ?>_timer' class='ricoSessionTimer'></span><span id="<?php echo $id; ?>_bookmark"> </span></p>
\r
73 <div id="<?php echo $id; ?>"></div>
\r