Sql query keeps returning bool(false)

[Azorky]

function __construct() {
    $this->conn = mysqli_connect($this->host, $this->username, $this->password);
}

public function query(){
    if (mysqli_connect_errno()) return "Failed to connect to MySQL: " . mysqli_connect_error();

    $sql = "SELECT * FROM users";
    $result = mysqli_query($this->conn, $sql);
    return $result;
}

[Azorky]

I was quite tired last night so I forgot to give some extra information.
I have this function inside a class “Database” and I want to execute this function “query()” from another page:

<?php echo($database->query()) ?>

But this always returns bool(false) instead of users although my connection is okay.
So if anyone could help it would be very much appreciated!

[Admin]

By “the SQL query”, do you mean that the mysqli_query function returns false? If so, that sounds like your query is generating an error.

Can you please check if the function mysqli_error($this->conn) returns any information after running mysqli_query? That should contain an error message with more information about why the query failed.

[Azorky]

Apparantly there was no database selected.
But after adding this line: $this->conn->select_db($this->database);
$result returns: object(mysqli_result)#3 (5) { ["current_field"]=> int(0) ["field_count"]=> int(4) ["lengths"]=> NULL ["num_rows"]=> int(1) ["type"]=> int(0) }
I’m not really good with databases so I don’t really know what this means…

[Admin]

The object(mysqli_result) means the query was successful and returned a result. Please check the PHP documentation or a good MySQL tutorial to learn how to use the results.

[Azorky]

Thanks for the support!
I know what to do now.