$conn = new mysqli('localhost', 'username', 'password', 'database');
$sql = 'SELECT * FROM table';
$result = $conn->query($sql);

while ($row = $result->fetch_assoc()) {
    // Process each row
}

$conn->close();