PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]; $pdo = new PDO($dsn, 'root', '', $options); $stmt = $pdo->prepare("SELECT `Code`, `Name` FROM country LIMIT 20"); $stmt->execute(); $countries = $stmt->fetchAll(); foreach ($countries as $country) { echo "Code: {$country['Code']}, Name: {$country['Name']}
"; }