时时商务社区

标题: 一个SQL管理员的web接口 [打印本页]

作者: 网络通达 时间: 2018-2-14 09:41

               *
   *************************************************************************************
   *    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);
      return  $result;
}
function  displayTuple  ($fieldsNumber,  $fieldNames,
                                                $fieldLengths,  $values,  $mode)
{
      $result  =  "";
      $result  .=  "

[TR]" .

"[TD]";

$result .= "

$fieldIndex = 0;

while ($fieldIndex " .

escapeforhtml ($values [$fieldIndex]) . "";

}

$result .= "[I]" .

"[/TD][/TR]";

$fieldIndex++;

}

$result .= "[TR][TD]";

if ($mode == "modify")

{

$result .= "[I]";

}

else

{ $result .= "[I]"; }

$result .= "

[/TD][/TR]

";
      return  $result;
}
function  fieldFromType  ($text,  $type)
{
      if  ($type  ==  "int"  ||  $type  ==  "uint"  ||  $type  == "real")
         {  $result  =  $text;  }
      else
         {  $result  =  "'"  .  AddSlashes  ($text)  .  "'";  }
      return  $result;
}
function  executeMsql  ($database,  $command)
{
      /*echo  ""  .  $command  .  "";*/
      msql  ($database,  $command);
}
function  handleRemove  ($database,  $table,  $fieldsNumber,
                                                $fieldNames,  $fieldLengths,  $fieldTypes)
{
      global  $remove;
      if  ($remove  !=  "")
      {
         $command  =  "DELETE  FROM  "  .  $table  .  "  WHERE  ";
         $fieldIndex  =  0;
         while  ($fieldIndex

欢迎光临时时商务社区 (http://bbs.4435.cn/)