How to read “fetch(PDO::FETCH_ASSOC);”

by

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'];

More Related Contents:

  1. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  2. PDO get the last ID inserted
  3. PDO with INSERT INTO through prepared statements [closed]
  4. PDO::fetchAll vs. PDO::fetch in a loop
  5. Are there good tutorials on how to use PDO? [closed]
  6. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  7. PDO’s query vs execute
  8. Real escape string and PDO [duplicate]
  9. How to check if a row exist in the database using PDO?
  10. PHP PDO vs normal mysql_connect
  11. Can I create a database using PDO in PHP?
  12. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  13. Insert multiple rows with PDO prepared statements
  14. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  15. Using htmlspecialchars function with PDO prepare and execute
  16. PDO::PARAM for type decimal?
  17. Update query with PDO and MySQL
  18. Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’ with pdo
  19. Is “SET CHARACTER SET utf8” necessary?
  20. Retrieve (or simulate) full query from PDO prepared statement
  21. PDO returning incorrect, but duplicate, data. Key’s not in database.
  22. Unknown database error in PHP but it exists in PHPMyAdmin
  23. Set PDO to throw exceptions by default [duplicate]
  24. PDO: MySQL server has gone away
  25. How do detect that transaction has already been started?
  26. return multiple response data in one response
  27. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  28. PDOStatement to JSON [closed]
  29. PHP/SQL Insert Error when using Named Placeholders
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment