DB

<?php

class DB{
    protected $connection;
    function __construct($debug = false)
    {

        $user = "hemrank";
        $pass = "hemrankscraper";
        $this->connection = new PDO("mysql:host=localhost;port=3306;dbname=hemrank;", $user, $pass);
    }
    private function retrieve($query) {
            // Fetch objects, always
            $query->setFetchMode(PDO::FETCH_OBJ);
            $query = $query->fetchAll();
            return $query;
        }

        /**
         * Main Query-function
         * @param  sql $query the query
         * @return obj        the result object
         */
        public function query($query, $execute = array())
        {
            $query = $this->connection->prepare($query);
            $query->execute($execute);
            $result = $this->retrieve($query);
            return $result;
        }

        /**
         * Main execute function
         * @param  sql $query   the query
         * @param  array  $execute the parameters
         * @return mixed          the result
         */
        public function execute($query, $execute = array())
        {
            $query = $this->connection->prepare($query);
            return $query->execute($execute);
        }
}