<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<!-- ------------------------------------------------------------ -->
<!--  Run Time Access                                             -->
<!--  Copyright (C) 2004 Robert W Smith (bsmith@linuxtoys.org)    -->
<!--                                                              -->
<!--   This program is distributed under the terms of the GNU     -->
<!--   LGPL.  See the file COPYING file.                          -->
<!-- ------------------------------------------------------------ -->
<head>
<title>rta Table Editor</title>
</head>
<body>
<center><h3>rta Table Editor</h3></center>
<?php
    // comment this line out if your PHP is compiled with postgresql client library
    dl("pgsql.so");
    // Suppress Postgres error messages
    // error_reporting(error_reporting() & 0xFFFD);

    // connect to the database Change the username, password here to match your configuraiton 
    $conn = pg_connect("host=localhost port=8888 user=blah password=blah");
    if ($conn == "") { 
        printf("$s%s%s", "Unable to connect to application.<br>",
            "Please verify that the application is running and ",
            "listening on port 8888.<br>");
        exit();
    }

    // Headings
    print("<table border=3 cellpadding=4 align=center width=65%>\n");
    print("<tr><th>Table Name</th><th>Description</th></tr>\n");

    // execute query 
    $command = "SELECT name, help, nrows FROM rta_tables";
    $result = pg_exec($conn, $command);
    if ($result == "") { 
        print("<p><font color=\"red\" size=+1>SQL Command failed!</p>");
        print("<p>Command: $command</p>\n");
        exit();
    }
    for($row = 0; $row < pg_NumRows($result); $row++)
    {
        $tblname  = pg_result($result, $row, 0);
        $tblhelp  = pg_result($result, $row, 1);
        $tblrows  = pg_result($result, $row, 2);
        print("<tr>\n<td><a href=rta_view.php?table=$tblname&offset=0");
        print("&nrows=$tblrows>$tblname</a></td>\n");
        print("<td>$tblhelp</td></tr>\n");
    }

    print("</table>\n");

    // free the result and close the connection 
    pg_freeresult($result);
    pg_close($conn);
?>
</body>
</html>
