I’m getting this error code: Invalid argument supplied for foreach() [duplicate]

by

Try to increase error mode:

<?php
$hostname="localhost";
$username="root";
$password='';

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=stickercollections",$username,$password);

    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line
    echo 'Connected to Database<br/>';

    $sql = "SELECT * FROM stickercollections";
foreach ($dbh->query($sql) as $row)
    {
    echo $row["collection_brand"] ." - ". $row["collection_year"] ."<br/>";
    }


    $dbh = null;
    }
catch(PDOException $e)
    {
    echo $e->getMessage();
    }
?>

EDIT:
pdo.error-handling says, you can alternatively use pdo.errorcode and pdostatement.errorcode (or like) to get more info, but I think throw exception is better way to handle bad connections, not resolved hosts etc.

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. PDO and MySQL ‘between’
  13. PDO Return All Rows [duplicate]
  14. PDO Exception Questions – How to Catch Them
  15. Query database then email posts from where user is subbed to
  16. What is parameterized query?
  17. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  18. How do I set ORDER BY params using prepared PDO statement?
  19. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  20. pdo – Call to a member function prepare() on a non-object [duplicate]
  21. CakePHP find method with JOIN
  22. PDO PHP Fetch Class
  23. PDO Connection Test
  24. PDO error: SQLSTATE[HY000]: General error: 2031
  25. Execute raw SQL using Doctrine 2
  26. Simple PHP SQL login troubleshooting
  27. Check if row exists in the database before inserting
  28. pdo sqlite could not find driver… php file not processing
  29. How to check if a value already exists to avoid duplicates?
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment