how to properly use while loop in PDO fetchAll

by

With fetchAll() you don’t have to use while at all. As this function returns an array, you have to use foreach() instead:

function getContent() {
    $db = PDOconn();
    $query = "SELECT * FROM posts ORDER BY id DESC LIMIT 0,3";
    $sql = $db->prepare($query);
    $sql->execute();
    return $sql->fetchAll();
}

$data = getContent();
foreach($data as $row) {
    $id = $row['id'];
    $content = $row['content'];
}

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. Can PHP PDO Statements accept the table or column name as parameter?
  3. Can I bind an array to an IN() condition in a PDO query?
  4. How to apply bindValue method in LIMIT clause?
  5. PDOException “could not find driver”
  6. PDO get the last ID inserted
  7. How do I use password hashing with PDO to make my code more secure? [closed]
  8. How to view query error in PDO PHP
  9. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  10. Insert/update helper function using PDO
  11. Is the leading colon for parameter names passed to PDOStatement::bindParam() optional?
  12. PDO’s query vs execute
  13. Resetting array pointer in PDO results
  14. PDO multiple queries
  15. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  16. Using htmlspecialchars function with PDO prepare and execute
  17. What is the advantage of using try {} catch {} versus if {} else {}
  18. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  19. Call to undefined method PDO::execute()
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. How do detect that transaction has already been started?
  22. return one value from database with mysql php pdo
  23. Trying to access array offset on value of type bool
  24. LIKE query using multiple keywords from search field using PDO prepared statement
  25. return multiple response data in one response
  26. How to get a query error from prepare() in PDO PHP?
  27. Do PHP PDO prepared statements need to be escaped?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. PHP PDO how to run a multiple query request?
  30. PDO and MySQL ‘between’

Leave a Comment