How to use mysqli_query() in php?

// 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();
}

// Execute query
$query = "SELECT * FROM users";
$result = mysqli_query($mysqli, $query);

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

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

// Free result set
mysqli_free_result($result);

// Close connection
mysqli_close($mysqli);