PDO not fetching results returns an array of size 1

Question

Simple selection of two columns:

try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  $stmt = $conn->prepare("SELECT email, pasword FROM users");
  $stmt->execute();

  $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);

This does not work

  echo $result["email"];

Rest of the query

} catch(PDOException $e) {
  echo "Error: " . $e->getMessage();
}
$conn = null;

When I echo $result["email"] it does not echo anything. I tried to echo the size of the $result array and it said it was a size of 1.

Answer 1

you don't seem to be using the correct method to get the result. try this...

$result = $stmt->fetch(PDO::FETCH_ASSOC);

instead of this...

$result = $stmt->setFetchMode(PDO::FETCH_ASSOC);

Answer 2

The $result variable contains an associative array, most likely you should use an iteration foreach, for, while, to get values. For example:

foreach($data as $result)
{
    $email = $data["email"];
}

If you want access to value without loop, try this:

$email = $result[0]["email"];