using Mysqli within CLASS

Question

Hello, I’m in trouble, I have some queries to do, I wanted to leave within class, I’m making the following code:

<?php
class MySQL {
    private $user;
    private $password;
    private $database;
    private $host;

    public function __construct($user, $password, $database, $host="localhost"){
        $this->user     =   $user;
        $this->password =   $password;
        $this->database =   $database;
        $this->host     =   $host;

        $this->mysqli = new mysqli($this->host, $this->user, $this->password, $this->database);
        if (mysqli_connect_errno()) {
            die('FATAL ERROR: Can not connect to SQL Server.');
            exit();
        }
    }

    public function _query($qr)
    {
        $this->result = $this->mysqli->query($qr);
        return $this->result;
    }

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

To call, I do:

    <?php
        session_start();
        $connect = new MySQL(UserMySQL, PassMySQL, DataBaseMySQL, ServerMySQL);
function test(){
        $search =   $connect->_query("SELECT value FROM tab2 WHERE type='".$type."'");
        $search =   $connect->_query("SELECT * FROM tab1 WHERE urlName='".$subName."'");
    }
    test();

But returns me error. Call to a Member Function _query() on a non-object in ..........

Answer 1

Failed to declare variable $connect global within the function, thus:

function test(){
    global $connect;
    $search =   $connect->_query("SELECT value FROM tab2 WHERE type='".$type."'");
    $search =   $connect->_query("SELECT * FROM tab1 WHERE urlName='".$subName."'");
}

I ask forgiveness to the community for making this mistake, anyway, now whoever has this doubt will know hahaha