MSQL Web Browser Interface

----------------------------------------------------------------------------

WEBSQL Version 0.92

(C) Universal Access Inc., 1995  Henry Minsky
     All rights reserved.

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

----------------------------------------------------------------------------

MSQL Table Web Browser Interface

This is a C web CGI script to examine and modify rows in tables of an MSQL
database. You should use Netscape or another browser which supports HTML 3.0
tables. Source available at http://www.ua.com/websql/websql.tar.gz.

Bugs Fixed in V 0.92

   *  Only 10 records are displayed at a time, with an option to move
     forward or back to the next screen of records. Prevents the lossage of
     selecting all records of a large database.

Usage Options

You can directly access a given database by passing the db_name arg in the
QUERY_ STRING, i.e.

     http://www.your.site/cgi-bin/websql?db_name=test

Assuming the cgi-script is installed as /cgi-bin/websql on your web server.

This should display a set of HTML tables which correspond to your database's
tables. You can click on a table to examine or modify records in that table.

Since the script runs as uid 'www' (or whatever your web server's effective
uid is), your database will have to be accessible by a client running with
that uid.

© Universal Access Inc., 1995, Henry Minsky (hqm@ua.com)
----------------------------------------------------------------------------

Sample Table Browser Output

Database test Tables

           Table Name: ship
 Field  Type  Size     Key     Non Null
 name  string 32   Ê           NOT_NULL
 weightint    Ê    Ê           Ê
 id    int    Ê    PRIMARY_KEY NOT_NULL
 owner string 32   Ê           Ê

           Table Name: crew
 Field Type  Size     Key     Non Null
 name string 32   Ê           NOT_NULL
 id   int    Ê    PRIMARY_KEY NOT_NULL
 ship int    Ê    Ê           Ê
 sex  string 1    Ê           Ê

  Table Name: assignments
 FieldType Size Key Non Null
 ship int  Ê    Ê   Ê
 crew int  Ê    Ê   Ê

       Table Name: foo
 Field Type  Size Key Non Null
 bar  int    Ê    Ê   Ê
 Bar  string 10   Ê   Ê

----------------------------------------------------------------------------
© Universal Access Inc., 1995, Henry Minsky (hqm@ua.com)
----------------------------------------------------------------------------

Sample Record Browser Output

Search query: SELECT name,weight,id,owner FROM ship WHERE id=1

Database: test Table: ship

You can do a simple SELECT of a record from this table by doing the
following:

  1.  Click in the checkbox of any fields you want to match on, and setting
     a value in that field.
  2.  Click on the Select button.

A null value for a checked field indicates you want records which match on
any value for that field.


 UseType Size  Name   Value
    char   32   name:
    int     4 weight:
    int     4     id:
    char   32  owner:

----------------------------------------------------------------------------
----------------------------------------------------------------------------
© Universal Access Inc., 1995, Henry Minsky (hqm@ua.com)