gitlab_medici/old/html/multidic/classes/db.php @ 5d106402

<?php
/*
 *
 * Copyright (c) 1998-2000 NetUSE AG
 *                    Boris Erdmann, Kristian Koehntopp
 *
 * $Id: db_pgsql.inc,v 1.9 2002/08/26 08:27:43 richardarcher Exp $
 *
 */

class DB_Sql {
  var $Host     = "Filek.cz";
  var $Database = "aswi-dictionary";
  var $User     = "dbowner";
  var $Password = "";

  /** @var mysqli_result  */
  var $result = null;

  var $row = null;

  /** @var mysqli */
  var $connection = null;
  var $Debug = 0;

  /* public: constructor */
  function __construct($query = "") {
      $this->query($query);
  }

  function connect() {
    $this->connection = new mysqli($this->Host, $this->User, $this->Password, $this->Database);
    $this->connection->set_charset("utf8");

    if ($this->connection->connect_error) {
      $this->halt("Connection failed: " . $this->connection->connect_error);
    }
  }

    function escape_string($string)
    {
        if ($this->connection == null)
        {
            $this->connection = new mysqli($this->Host, $this->User, $this->Password, $this->Database);
            $this->connection->set_charset("utf8");
        }
        return $this->connection->real_escape_string($string);
    }

  function query(string $Query_String) {
    /* No empty queries, please, since PHP4 chokes on them. */
    if ($Query_String == "")
      /* The empty query string is passed on from the constructor,
       * when calling the class without a query, e.g. in situations
       * like these: '$db = new DB_Sql_Subclass;'
       */
      return 0;

    $this->connect();

    if ($this->Debug)
      printf("<br>Debug: query = %s<br>\n", $Query_String);

    $this->result = $this->connection->query($Query_String);

//    if ($this->result) {
//      $this->halt("Invalid SQL: ".$Query_String);
//    }

    return $this->result;
  }

  function next_record() {
    $this->row = mysqli_fetch_row($this->result);
    return $this->row;
  }

  function metadata($table="") {
    $count = 0;
    $id    = 0;
    $res   = array();

    if (!empty($table)) {
       $this->connect();
       $id = pg_exec($this->Link_ID, "select * from $table");
       if ($id < 0) {
          $this->Error = pg_ErrorMessage($id);
          $this->Errno = 1;
          $this->halt("Metadata query failed.");
       }
    } else {
      $id = $this->Query_ID;
      if (!$id) {
        $this->halt("No query specified.");
      }
    }

    $count = pg_NumFields($id);

    for ($i=0; $i<$count; $i++) {
      $res[$i]["table"] = $table;
      $res[$i]["name"]  = pg_FieldName  ($id, $i);
      $res[$i]["type"]  = pg_FieldType  ($id, $i);
      $res[$i]["len"]   = pg_FieldSize  ($id, $i);
      $res[$i]["flags"] = "";
    }

    if ($table) {
      pg_FreeResult($id);
    }

    return $res;
  }

  function affected_rows() {
    return $this->connection->affected_rows;
  }

  function num_rows() {
    return $this->result->num_rows;
  }

  function num_fields() {
    return $this->result->field_count;
  }

  function f($Name) {
    return $this->result[$Name];
  }

  function halt($msg) {
    printf("</td></tr></table><b>Database error:</b> %s<br>\n", $msg);
    printf("<b>PostgreSQL Error</b>: %s (%s)<br>\n",
      $this->connection->errno,
      $this->connection->error);
//    die("Session halted."); // potřebuju vidět errory v logu
  }

  function table_names() {
    $this->query("select relname from pg_class where relkind = 'r' and not relname like 'pg_%'");
    $i=0;
    while ($this->next_record())
     {
      $return[$i]["table_name"]= $this->f(0);
      $return[$i]["tablespace_name"]=$this->Database;
      $return[$i]["database"]=$this->Database;
      $i++;
     }
    return $return;
  }
}
?>