DB PHP

db

<?php
	class Database extends Core {
	private
            $link,
            $db_vars,
            $enconing = 'utf8';

        public function __construct($host, $db, $user, $pass){           
            $this->db_vars = new stdClass();
            
            $this->db_vars->host 	= $host;
			$this->db_vars->user 	= $user;
			$this->db_vars->pass 	= $pass;
			$this->db_vars->db 		= $db;
			
            $this->mySqlConnect();
        }

        //Connect to DB
        private function mySqlConnect(){
            $this->link = new mysqli(
                $this->db_vars->host,
                $this->db_vars->user,
                $this->db_vars->pass,
                $this->db_vars->db
            );

            if(mysqli_connect_errno()){
                $this->utils->debug('
                    <b>MySQL connect failed:</b><br>
                    '.mysqli_connect_error().'
                ');
            };

            $this->link->set_charset($this->encoding);
        }

        //Disconnect from DB
        public function mySqlDisconnect(){
            $this->link->close();
        }

        //Quote a sting
        public function quote($value){
            if(get_magic_quotes_gpc()){
                $value = stripslashes($value);
            };

            if(!is_numeric($value)){
                $value = $this->link->real_escape_string($value);
            };

            return $value;
        }

        //Filtering query and save HTML-tags
        static public function quoteWithHTML($value){
            if(get_magic_quotes_gpc()){
                $value = stripslashes($value);
            };

            $value = mysql_real_escape_string($value);
            return $value;
        }

        //Return just inserted id
        public function getMysqlInsertId(){
            return mysqli_insert_id($this->link);
        }

        //Perform a query
        public function query($query){
            $result = $this->link->query($query) or die('
				<b>MySQL Error:</b><br>
				'.$this->link->error.'<br><br>
				<b>Query that been requested:</b><br>
				<code>'.$query.'</code>
			');

            return $result;
        }

        //Return an associative array of a one row
        public function assocItem($query){
            $sql = $this->query($query);
            return $sql->fetch_assoc();
        }

        //Return an associative array of a multiple rows
        public function assocMulti($query){
            $rows = array();
            $sql = $this->query($query);

            while($req = $sql->fetch_assoc()){
                $rows[] = $req;
            };

            $sql->free();
            return $rows;
        }

        //Returns true, if exists
        public function checkRowExistance($table, $param, $value, $not = false){
            if(is_numeric($value)){
                $value = intval($value);
            }else{
                $value = "'".$this->quote($value)."'";
            };

            if($not && !empty($not)){
                $exclude = " && `id` NOT IN (";

                foreach($not as $item){
                    $exclude .= intval($item).",";
                };

                $exclude = substr($exclude, 0, strlen($exclude)-1);
                $exclude .= ")";
            };

            $query = "
                SELECT
                    COUNT(*) AS `count`
                FROM
                    `".$this->quote($table)."`
                WHERE
                    `".$this->quote($param)."` = ".$value.$exclude."
                LIMIT 1
            ";

            $row_count = $this->assocItem($query);

            if($row_count['count'] > 0){
                return true;
            }else{
                return false;
            };
        }

        //Return an associative array of a multiple rows by random selection
        public function getRandomItems($table, $count, $fields = array(), $where = false){
            if($where){
                $where = "WHERE ".$where;
            };

            $query = "SELECT COUNT(*) AS `count` FROM `".$this->quote($table)."` ".$this->quote($where);
            $row_count = $this->assocItem($query);
            $row_count = $row_count['count'];
            $query = array();

            if(!empty($fields)){
                $f = implode(",", $fields);
            }else{
                $f = '*';
            };

            $rand_matrix = array();

            while (count($query) < $count) {
                $next_random = rand(0, $row_count);

                while(in_array($next_random, $rand_matrix)){
                    $next_random = rand(0, $row_count);
                };

                array_push($rand_matrix, $next_random);

                $query[] = "(SELECT ".$this->quote($f)." FROM `".$this->quote($table)."` ".$this->quote($where)." LIMIT ".$next_random.", 1)";
            };

            unset($rand_matrix, $next_random);

            $query = implode(" UNION ", $query);

            return $this->assocMulti($query);
        }
	};
?>