how to run select query in mysqli ?

// Establish a connection
$mysqli = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// Prepare and execute query
$query = "SELECT * FROM users";
$result = $mysqli->query($query);

// Check for errors and process results
if (!$result) {
    echo "Error executing query: " . $mysqli->error;
    exit();
}

// Loop through results and output data
while ($row = $result->fetch_assoc()) {
    echo "User ID: " . $row["id"] . "<br>";
    echo "Name: " . $row["name"] . "<br>";
    echo "Email: " . $row["email"] . "<br><br>";
}

// Free result set
$result->free();

// Close connection
$mysqli->close();