<? 
    class db 
    { 
        function db () 
        { 
            $user = "usr"; 
            $pass = "pass"; 
            $host = "localhost"; 
            $dbdb = "dbnaam"; 
             
            if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass))) 
            { 
                echo "Could not establish a database connection."; 
                exit(); 
            } 
        } 
         
        function dbexec ($sql) 
        { 
            $res = mysql_query($sql) or die(mysql_error());       
            return $res; 
        } 
         
        function dblastid () 
        { 
            $res = mysql_insert_id(); 
            return $res; 
        } 
     
        function dbinsert ($table, $values) 
        { 
            $sql = "INSERT INTO "; 
            $sql .= $table; 
            $sql .= " SET "; 
             
            foreach ($values as $key => $value) 
            { 
                if ($key != "submit") 
                { 
                    if (!$keys) 
                    { 
                        $keys = 1; 
                        $sql .= $key . " = '" . $value . "'"; 
                    } 
                    else 
                        $sql .= ", " . $key . " = '" . $value . "'"; 
                } 
            } 
             
            $res = $this->dbexec($sql); 
             
            return $res; 
        } 
         
        function dbarray ($res) 
        { 
            $row = mysql_fetch_array($res); 
             
            return $row; 
        } 
         
        function dbselect ($fields, $table, $array = '', $where = '', $order = '', $limit = '') 
        { 
            $sql = "SELECT "; 
            $sql .= $fields; 
            $sql .= " FROM "; 
            $sql .= $table; 
             
            //--- where clause 
            if ($where) 
            { 
                $sql .= " WHERE "; 
                $sql .= $where; 
            } 
             
            //--- order clause 
            if ($order) 
            { 
                $sql .= " ORDER BY "; 
                $sql .= $order; 
            } 
             
            //--- limit clause 
            if ($limit) 
            { 
                    $sql .= " LIMIT "; 
                    $sql .= $limit; 
            } 
             
            $res = $this->dbexec($sql); 
             
            if ($array) 
                $res = $this->dbarray($res); 
             
            return $res; 
        }
        
        function dbnumrows($result)
        {
        	if (mysql_num_rows($result) >= 1)
        		return mysql_num_rows($result);
        }
         
        function dbupdate ($table, $values, $where = '') 
        { 
            $sql = "UPDATE "; 
            $sql .= $table; 
            $sql .= " SET "; 

            foreach ($values as $key => $value) 
            { 
                if ($key != "submit") 
                { 
                    if (!$keys) 
                    { 
                        $keys = 1; 
                        $sql .= $key . " = '" . $value . "'"; 
                    } 
                    else 
                        $sql .= ", " . $key . " = '" . $value . "'"; 
                } 
            } 
             
            if ($where) 
            { 
                $sql .= " WHERE "; 
                $sql .= $where; 
            } 
             
            $res = $this->dbexec($sql); 
             
            return $res; 
        } 
    } 
?>
