<?php try {
$db = new PDO("mysql:host=localhost;dbname=c1", "root", "");
} catch ( PDOException $e ){
print $e->getMessage();
}



$query = $db->query("SELECT email FROM users", PDO::FETCH_ASSOC);
if ( $query->rowCount() ){
foreach( $query as $row ){
print $row['email']."<br>";
}
} ?>