PHP MySQL Database Driver

A simple PHP MySQL database driver class from 2010, using the legacy mysql_* functions.

<?php
/*
 *  Datenbank Treiber - MySQL
 *
 *  lastedit: 09.02.2010 - pg@deg.net
 *  fast version -> kein fetch_assoc notwendig
 *  affected rows & error hinzugefuegt
 */

class database_mysql
{
    var $sqlLink;
    var $affected_rows;
    var $error;
    var $errno;

    function database_mysql(&$dbLink)
    {
        $this->sqlLink = &$dbLink;
    }

    function query($sqlString)
    {
        $qry = @mysql_query($sqlString,$this->sqlLink);
        $res = $this->fetch_assoc($qry);

        if (mysql_error() || mysql_errno())
        {
            $this->oops("<b>MySQL Query fail:</b> ".$sqlString);
            return 0;
        }

        $this->affected_rows = @mysql_affected_rows($this->sqlLink);
        return $res;
    }

    function query_only($sqlString)
    {
        @mysql_query($sqlString,$this->sqlLink);
        if (!$this->sqlLink)
        {
            $this->oops("<b>MySQL Query fail:</b> ".$sqlString);
            return 0;
        }
        $this->affected_rows = @mysql_affected_rows($this->sqlLink);
    }

    function query_id($sqlString)
    {
        @mysql_query($sqlString,$this->sqlLink);
        $id = mysql_insert_id($this->sqlLink);
        if (!$this->sqlLink)
        {
            $this->oops("<b>MySQL Query fail:</b> ".$sqlString);
            return 0;
        }
        $this->affected_rows = @mysql_affected_rows($this->sqlLink);
        return $id;
    }

    function fetch_assoc($sqlResult)
    {
        $ret = array();
        if (!empty($sqlResult)) {
            while ($res = mysql_fetch_assoc($sqlResult))
            {
                $ret[] = $res;
            }
        }
        return $ret;
    }

    function num_rows($sqlString)
    {
        $qry = @mysql_query($sqlString,$this->sqlLink);
        $res = @mysql_num_rows($qry);
        if (!$this->sqlLink)
        {
            $this->oops("<b>MySQL Query fail:</b> ".$sqlString);
            return 0;
        }
        return $res;
    }

    function connect($dbhost,$dbuser,$dbpass)
    {
        $this->sqlLink = @mysql_connect($dbhost,$dbuser,$dbpass);
        if (!$this->sqlLink)
        {
            $this->oops("Could not connect to server.");
        }
    }

    function disconnect()
    {
        if(!@mysql_close($this->sqlLink))
        {
            $this->oops("Connection close failed.");
        }
    }

    function select_db($db)
    {
        if (!@mysql_select_db($db,$this->sqlLink))
        {
            $this->oops("Could not open database.");
        }
    }
}
?>

Note: This uses the deprecated mysql_* extension which was removed in PHP 7.0. Modern code should use mysqli or PDO.