一个SQL管理员的web接口

来源:www.phpres.com 作者：Angelover 出处：www.phpres.com 2007-7-8 09:50:00 进入讨论组

关键词：一个SQL管理员的web接口

<?
    /*************************************************************************************
     *        SQLAdmin v2.0 - An SQL Administration User Interface for the Web *
     *            Copyright (C) 1997-98    Alessandro Vernet <avernet@scdi.org>      *
     *************************************************************************************
     *      This library is free software; you can redistribute it and/or       *
     *      modify it under the terms of the GNU Library General Public        *
     *      License as published by the Free Software Foundation; either         *
     *      version 2 of the License, or (at your option) any later version. *
     *                                                                                   *
     *      This library 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 *
     *      Library General Public License for more details.                       *
     *                                                                                   *
     *      You should have received a copy of the GNU Library General Public *
     *      License along with this library; if not, write to the               *
     *      Free Software Foundation, Inc., 59 Temple Place - Suite 330,        *
     *      Boston, MA    02111-1307, USA.                                             *
     *************************************************************************************/

    /* TODO:
      * - Add sort order.
      * - Add simple view.
      * - Add some documentation.
      */

    /* LIMITATIONS:
      * - Works only with mSQL.
      */

    /* HISTORY:
      * - 97-11-05 (avernet) Corrected a bug with quote.
      * - 98-01-01 (avernet) Added a sortColumn parameter to
      *      administrationTable function.
      * - 98-03-14 (avernet) Added function addTable to enable users to
      *      add (but not modify) en entry to the database.
      * - 98-05-19 (avernet) Submitted to PX.
      * - 98-10-11 (avernet) Now SQLAdmin works with PHP3. The PHP2 version
      *      will not be mainteained anymore.
      * - 98-10-11 (avernet) SQLAdmin is now distributed under the LGPL
      *      instead of MPL.
      */

    function escapeforhtml ($string)
    {
        $result = $string;
        //$result = ereg_replace ("\"", """, $result);
        $result = ereg_replace ("<", "<", $result);
        $result = ereg_replace (">", ">", $result);
        return $result;
    }

    function executeMsql ($database, $command)
    {
        /*echo "<TT>" . $command . "</TT><HR>";*/
        msql ($database, $command);
    }

    function displayAdd ($fieldsNumber, $fieldNames, $fieldLengths)
    {
        $result = "";
        $fieldIndex = 0;
        while ($fieldIndex < $fieldsNumber)
        {
            $values [$fieldIndex] = "";
            $fieldIndex++;
        }
        $result .= displayTuple ($fieldsNumber, $fieldNames,
            $fieldLengths, $values, "add");
        msql_close ();
        return $result;
    }

    function administrationTable ($database, $table, $sortColumn)
    {
        $result = "";
        msql_connect ( "localhost");
        $msqlresult = msql ($database, "SELECT * FROM " . $table);
        $fieldsNumber = msql_numfields ($msqlresult);
        $msqlresult = msql_listfields ($database, $table);
        $fieldIndex = 0;
        while ($fieldIndex < $fieldsNumber)
        {
            $fieldNames [$fieldIndex] = msql_fieldname ($msqlresult, $fieldIndex);
            $fieldLengths [$fieldIndex] = msql_fieldlen ($msqlresult, $fieldIndex);
            $fieldTypes [$fieldIndex] = msql_fieldtype ($msqlresult, $fieldIndex);
            $fieldIndex++;
        }
        handleRemove ($database, $table, $fieldsNumber, $fieldNames, $fieldLengths, $fieldTypes);
        handleUpdate ($database, $table, $fieldsNumber, $fieldNames, $fieldLengths, $fieldTypes);
        handleAdd ($database, $table, $fieldsNumber, $fieldNames, $fieldLengths, $fieldTypes);
        $result .= displayRemoveUpdate ($database, $table, $sortColumn, $fieldsNumber, $fieldNames,
$fieldLengths);
        $result .= displayAdd ($fieldsNumber, $fieldNames, $fieldLengths);
        return $result;
    }

    function addTable ($database, $table)
    {
        $result = "";
        msql_connect ( "localhost");
        $msqlresult = msql ($database, "SELECT * FROM " . $table);
        $fieldsNumber = msql_numfields ($msqlresult);
        $msqlresult = msql_listfields ($database, $table);
        $fieldIndex = 0;
        while ($fieldIndex < $fieldsNumber)
        {
            $fieldNames [$fieldIndex] = msql_fieldname ($msqlresult, $fieldIndex);
            $fieldLengths [$fieldIndex] = msql_fieldlen ($msqlresult, $fieldIndex);
            $fieldTypes [$fieldIndex] = msql_fieldtype ($msqlresult, $fieldIndex);
            $fieldIndex++;
        }
        handleAdd ($database, $table, $fieldsNumber, $fieldNames, $fieldLengths, $fieldTypes);
        $result .= displayAdd ($fieldsNumber, $fieldNames, $fieldLengths);
        return $result;
    }
?>