PHP PDO returning single row

by

Just fetch. only gets one row. So no foreach loop needed 😀

$row  = $STH -> fetch();

example (ty northkildonan):

$id = 4;
$stmt = $dbh->prepare("SELECT name FROM mytable WHERE id=? LIMIT 1"); 
$stmt->execute([$id]); 
$row = $stmt->fetch();

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PHP – Using PDO with IN clause array
  3. How to squeeze error message out of PDO? [duplicate]
  4. How to properly set up a PDO connection
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. PDO Prepared Inserts multiple rows in single query
  8. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  9. PDO mysql: How to know if insert was successful
  10. mysql PDO how to bind LIKE
  11. Connect PHP to MSSQL via PDO ODBC
  12. PDO closing connection
  13. How to get the total number of rows of a GROUP BY query?
  14. How do I use pdo’s prepared statement for order by and limit clauses?
  15. What is PDO & why should I use it?
  16. How to install pdo driver in php docker image?
  17. How do I loop through a MySQL query via PDO in PHP?
  18. MySQL retrieve variable from Stored Procedure in PHP PDO
  19. Understanding pdo mysql transactions
  20. PDO fetchAll array to one dimensional
  21. How do I enable php to work with postgresql?
  22. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. How to handle PDO exceptions [duplicate]
  25. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  26. Get Last Executed Query in PHP PDO
  27. pdo sqlite could not find driver… php file not processing
  28. PDO and MySQL Fulltext searches
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment