class db {

        private $host      = 'localhost';
        private $base      = 'temp';
        private $user      = 'root';
        private $pass      = '';
        private $charset   = 'utf8';
        private $collation = 'utf8_general_ci';

        // соединение с базой --------------------------------------------------

        function connect() {

                $this->db = mysql_connect($this->host, $this->user, $this->pass);
                mysql_select_db($this->base, $this->db);
                mysql_query('SET NAMES ' . $this->charset);
                mysql_set_charset($this->charset);
        }
         
        // выборка данных ------------------------------------------------------
         
        function select($fields, $tables, $conditions) {

                if (count($fields)===0 || count($tables)===0 || count($conditions)===0)
                 
                        return FALSE;
                         
                else {
                        // поля

                        reset ($fields);

                        list($key, $val) = each($fields);

                        $query_text = 'SELECT ' . $val;

                        while (list($key, $val) = each($fields))

                    $query_text = $query_text . ', ' . $val;

                        // таблицы

                        reset ($tables);

                        list($key, $val) = each($tables);

                        $query_text = $query_text . ' FROM ' . $val;

                        while (list($key, $val) = each($tables))

                    $query_text = $query_text . ', ' . $val;

                        // условия
                         
                        reset ($conditions);
                         
                        list($key, $val) = each($conditions);
                         
                        $query_text = $query_text . ' WHERE ' . $key . '=' . $val;
                         
                        while (list($key, $val) = each($conditions))
                         
                    $query_text = $query_text . ', ' . $key . '=' . $val;
                    

                        return $mysql_query($query_text);
                }
        }

        // закрытие соединения -------------------------------------------------

        function disconnect() {
         
                mysql_close($this->db);
        }
         
        //----------------------------------------------------------------------

}