Fetching data from MySQL database

bettermysql-fetch.php

<?php
  // Assuming that database connection is already open
  // Prepare statement
  $stmt = $db->prepare("SELECT
    COUNT(user_id) AS UserCount,
    country AS Country
  FROM users
  GROUP BY country
  ORDER BY country");
  
  // Execute statement, check if execution is ok
  if($stmt->execute()) {
    // Fetch rows as arrays indexed by column name
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
      // Access field values by column name
      echo $row['UserCount'] . ' user(s) in ' . $row['Country'];
    }
  }
  
?>