WHAT'S THIS ?

   It is a trivial yet effective (IMHO) web interface to an SQL server
   emulating a typical SQL client to issue SQL commands (what else ? ;-).

   Since first implementation WySQL evolved to be a DBMS independent driver
   to by used by other products (see http://www.franzoni.info/open for
   available modules) for database management, access and programming.

   Only MySQL and postgreSQL are currently supported, while msql is
   absolutely untested and unofficially implemented as well ( msql_*
   functions were so like the mysql_* ones that... why not )

   It supports history of previous commands (PHP4 sessions required for
   this to work) - just click on query to reload it in the input box.

   Commands are sent to the db server with no control (except for the
   "USE" statement that is denied because connections to databases are
   limited to the ones defined in database.php (if any) or the query
   form.

   As of V2, both OO and procedural interface are available, however the
   procedural version could be no longer be maintained in next releases.

   The browser must support frames (for web console access).
   WySQL has only been tested with Netscape and Mozilla under GNU/Linux
   so far (I also used M$IE but can not claim it as a test ;-).


COPYING

   This is free software, and you are welcome to redistribute it
   under certain conditions; see the file COPYING for details.

   This software is OSI Certified Open Source Software.
   OSI Certified is a certification mark of the Open Source Initiative.

   You may want to check http://www.franzoni.info/open for up to date
   version.


HISTORY

   V2.0.0-beta3 Previous "stable" version was some unstable indeed since it
                kept using the V1 console and the V2 console has never been
                tested.  And of course there was very stupid bugs in it, sorry!
                The constructor was mispelled, and no (property) initialization
                was performed indeed (this had no impact but the console).
                The session handling (used for query history) has been
                rearranged to conform the newest $_SESSION[] handling, it
                should now work despite the setting of session_autostart and
                register_globals... it probably won't work any longer under
                older versions of PHP.
                Fixed single-choice entries in database.php where not set nor
                loaded by do_connect() whose parameters, if set, *now* do
                override the database.php entries - they come from the dbform
                anyhow (pre-loaded from database.php), does this matter ?
                The console (dbms) prompt was no longer displayed.
   V2.0.0-pre1  Stable release and a few typos fixing. CANCELLED RELEASE
   V2.0.0-beta2	Minor bug-fix, adapted for WyCSV.
   V2.0.0-beta	WySQL has been reimplemented as Object Oriented;
                backward compatibility has been kept for procedural
                calling.
                Minor typos have been fixed in the driver.php file renamed
                to wysql_driver.php as well as almost all the V2 scripts have
                been prefixed with 'wysql_'.
                begin(), commit() and rollback() has been implemented
                as methods (and functions for the procedural mode) despite
                they are queries indeed.

   V1.4.0       This is mainly and indeed a version alignment release.
                However the plan for renaming global variables and
                functions (the driver) is introduced at this stage.
                This is also the first `production` release, still at
                YOUR OWN delightful RISK, after some time as beta testing.
                Last and perhaps least, some little aesthetics, and the new
                <connect db> button that just do what it means (it could also
                be done by <clear history> but this way history is kept.

   V1.3.?	Huh ? I missed to update this file for a while... sorry
                (CVS on sourceforge.net keeps all the logging)

   V1.2.0-beta: dmbs support release: the SQL engine has been revised for
                supporting multiple database interfaces. Other than MySQL
                now PostgreSQL support has been implemented. The msql
                interface has been implemented as well but is completely
                unsupported and untested (PHP interface to mSQL is so like
                to MySQL that I added it to the DB drivers, yet mSQL is NOT
                free software and since I have no need to buy it, I can't
                test (hence support) it at all.

   V1.1.0-beta: update release, includes support for scripting an fixes
                minor bug (introduced by reformatting the query form
                with visual tools :-( ) that prevented to import correctly
                host/db/user/password information from the config file
                (WySQL was usable but only defining all such info manually)

   V1.0.0-beta: initial release


INSTALLATION

   Unpack the compressed tarball and setup the database.php file
   properly.  It is suggested you also protect the installation directory
   for controlled access via your web server configuration file/program.

   Since V1.1.0-beta database.php is distributed as database.php_DIST to
   avoid to overwrite existing file. If you install from scratch you have
   to copy/rename this file to database.php.

   If upgrading from 1.1.0 to 1.2.0 or later please ensure the $DBms is
   properly added and set in the database.php file.

   NOTE: support for postgreSQL requires php > 4.2 as the pg_* interface has
   changed along with the V4.* versions. A version for php <= 4.0 could be
   implemented (if really required) with some limitation for the pg_fetch_row
   and using pg_exec instead of pg_query.

   NOTE: V2 only requires the following files:
     index.php, wysql.class.php, wysql_console.php, wysql_dbform.php,
     wysql_driver.php, wysql_query.php, database.php (database.php_DIST)
     and copyright.php.
   You may want to get rid of other *.php files if you don't mind
   about backward compability. Anyway I never tested the clean up !

   To use the procedural version use indexV1.php instead of index.php.


TODO

    The OO class and API should be documented (meantime please refer to
    the Wy* family modules/products).
    Support for new features of MySQL V4 and V5 should be implemented
    (by duplicating the current V3 driver and adding features).
    Support for Oracle is currently planned for next release


BUGS

    Please report any bug to the address below.  Suggestions and feature
    requests are also welcome.

    No known bugs so far :-)


CONTACT INFO:

    Mauro Franzoni
    Via Torbole 1
    I-21100 VARESE
    ITALY

    e-mail: info@franzoni.info