PHP and Mysqli OOP - Handling database

Today i tried to convert my functions to PHP Class. I tried with some basic steps.

<?php
    class DataBase {
        private $host;
        private $user;
        private $password;
        private $db;
        private $mysqli;

        function __construct() {
            $this->host = "localhost";
            $this->user = "root";
            $this->password = "";
            $this->db = "my_database";

            $this->mysqli = new mysqli($this->host, $this->user, $this->password, $this->db);
        }

        function __destruct() {
            $this->mysqli->close();
        }

        public function query($query, $params = '', $bind_result) {
            $stmt = $this->mysqli->prepare($query);

                    //Need to change this to process the array of params
            $stmt->bind_param('i', $params);
            $stmt->execute();
                    //Change this to handle array of bind
            $stmt->bind_result($bind_result);
                    //Loop the result and store it in a temp array
            $stmt->fetch();
                    //Don't print the statement. Just close the statement and return the array.
            printf("%s\n", $bind_result);
            /* close statement */
            $stmt->close();
        }
    }
?>

I have to now create another class. I created one dummy table in database.

<?php
    class Dummy {

        private $database;

        function __construct() {
            $this->database = new Database();
        }

        public function getAllDummy() {
            $query = "SELECT name FROM dummy WHERE id = ?";
            $this->database->query($query, 1, 'name');
        }

    }
?>

But I don't think it is the right way to do the things. I feel some of them are in the right way and some of them are wrong.

When i call the query() function, Do i need to connect the database all the time in every classes' construct method? Or Do i need to change the Database class to static functions? So i can call the functions like Database::query();

It seems i need to create everything from the start. Is such a model already available in internet? like cakephp, codeigniter