root/sovereignty/db_mysql.php @ 247

<?php
class mysql
{
    var $handle;
        var $host;
        var $user;
        var $password;
    var $database;
    var $rid;
    var $cur_row;
    var $used_time;

    // constructor, diese funktion wird aufgerufen beim instantieren eines neuen objekts
    function mysql ($host = "localhost", $user = "root", $pass = "", $database = "vng")
    {
        if ($host)
        {
            $this->connect($host, $user, $pass, $database);
        }
    }

        function connect ($host = "localhost", $user = "root", $pass = "", $database = "vng")
        {
        if ($host)
        {
            $this->setup($host, $user, $pass, $database);
        }

        $this->handle = mysql_connect($this->host, $this->user, $this->password, $this->database);

        if (!is_resource($this->handle))
        {
            $this->error("connection to '".$this->host."' failed.");
        }

        if (!mysql_select_db($this->database, $this->handle))
        {
            $this->error("selecting database '".$this->database."' failed.");
        }
        }

    function setup ($host, $user, $pass, $db)
        {
        $this->host = $host;
        $this->user = $user;
        $this->password = $pass;
        $this->database = $db;
    }

        function query ($query)
        {
        $result = mysql_query($query, $this->handle);
        if ($result != true)
        {
            $this->error("executing statement '".$query."' failed.");
            return false;
        }

        $this->cur_row = 0;
        $this->rid = $result;
        return $result;
        }

        function fetch_array ($rid = null, $max_rows = 0)
        {
        if ($rid == null)
        {
            $rid = $this->rid;
        }
        if (!is_resource($rid))
        {
            $this->error("invalid resource id supplied to fetch_array()");
            return false;
        }
        $tmp = mysql_fetch_assoc($rid);
        if (!$tmp)
        {
            return false;
        }
        $this->cur_row++;

        if ($max_rows)
        {
            if ($this->cur_row > $max_rows)
            {
                // limit exceeded
                return false;
            }
        }

        return $tmp;
        }

    function num_rows($rid = null)
    {
        if ($rid == null)
        {
            $rid = $this->rid;
        }
        if (!is_resource($rid))
        {
            $this->error("invalid resource id supplied to num_rows()");
            return false;
        }
        return mysql_num_rows($rid);
    }

    function _gethandle ()
    {
        return $this->handle;
    }

        function error ($text)
    {
        echo "<br><b>mysql::error:</b> <i>$text</i>\n";
#        echo "<br><b>ads::debug:</b> <i>".ads_error().ads_errormsg()."</i>\n";
    }
}
?>