PDO Return All Rows [duplicate]

by

You need to use fetchAll()

$result = $query -> fetchAll();

foreach( $result as $row ) {
    echo $row['first_name'];
    echo $row['last_name'];
}

More Related Contents:

  1. Cleansing User Passwords
  2. How to apply bindValue method in LIMIT clause?
  3. How to properly set up a PDO connection
  4. Getting raw SQL query string from PDO prepared statements
  5. PDO with INSERT INTO through prepared statements [closed]
  6. Use bound parameter multiple times
  7. How to replace MySQL functions with PDO?
  8. How to debug PDO database queries?
  9. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  10. Do SQL connections opened with PDO in PHP have to be closed
  11. Using value of a column as index in results using PDO
  12. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  13. PDO and MySQL ‘between’
  14. PDO Exception Questions – How to Catch Them
  15. Using PHP data in MySQL [closed]
  16. Checking the availability of rooms
  17. PHP PDO prepared statements
  18. PDO Prepared Inserts multiple rows in single query
  19. Loading .sql files from within PHP
  20. mysql PDO how to bind LIKE
  21. Best way to defend against mysql injection and cross site scripting
  22. PDO closing connection
  23. What is PDO & why should I use it?
  24. PHP: multiple SQL queries in one mysql_query statement
  25. SQLSTATE[42S22]: Column not found: 1054 Unknown column – Laravel
  26. Understanding pdo mysql transactions
  27. Why does this return Resource id #2? [duplicate]
  28. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  29. PDO::rowCount VS COUNT(*)
  30. PHP Warning: PHP Startup: Unable to load dynamic library ‘pdo_mysql.so’

Leave a Comment