How to read "fetch(PDO::FETCH_ASSOC);"

Question

I am trying to build a web application using PHP and I am using Memcached for storing user data from the database.

For example, let’s say that I have this code:

 $sql    = "SELECT * FROM users WHERE user_id = :user_id"; $stmt   = $this->_db->prepare($sql); $result = $stmt->execute(array(":user_id" => $user_id)); $user   = $stmt->fetch(PDO::FETCH_ASSOC); 

I am not really sure how to read the $user variable and get the data out of it. I will need to be able to read the email and password column.

How does this work?

Answer 1

PDOStatement::fetch returns a row from the result set. The parameter PDO::FETCH_ASSOC tells PDO to return the result as an associative array.

The array keys will match your column names. If your table contains columns 'email' and 'password', the array will be structured like:

Array (     [email] => '[email protected]'     [password] => 'yourpassword' ) 

To read data from the 'email' column, do:

$user['email']; 

and for 'password':

$user['password'];