PDO returning incorrect, but duplicate, data. Key’s not in database.

by

It’s not duplicates, it’s just the current FETCH_MODE you’re using. To get as associative keys only you need to specify as such; by default it fetches as both.

Use like so:

$query->fetchAll(PDO::FETCH_NUM); // to fetch with numeric indexes
$query->fetchAll(PDO::FETCH_ASSOC); // to fetch with associative indexes

fetchAll docs
fetch docs

More Related Contents:

  1. Why does this PDO statement silently fail?
  2. Cleansing User Passwords
  3. How can I use PDO to fetch a results array in PHP?
  4. What are the disadvantages of using persistent connection in PDO
  5. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  6. MySQL check if a table exists without throwing an exception
  7. Error logging, in a smooth way
  8. How to read “fetch(PDO::FETCH_ASSOC);”
  9. PDO + MySQL and broken UTF-8 encoding
  10. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  11. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  12. Why is constructing PDO connection slow?
  13. php code to test pdo is available?
  14. PDO fetchAll group key-value pairs into assoc array
  15. how to properly use while loop in PDO fetchAll
  16. What is the best way to insert multiple rows in PHP PDO MYSQL?
  17. PDO MySQL: Insert multiple rows in one query
  18. How to bind LIKE values using the PDO extension?
  19. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  20. PDO LIMIT and OFFSET [duplicate]
  21. PHP 7 RC3: How to install missing MySQL PDO
  22. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]
  23. PHP Laravel: No connection could be made because the target machine actively refused it
  24. PDO bindParam into one statement?
  25. PDO Unbuffered queries
  26. escaping column name with PDO
  27. prepared parameterized query with PDO
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PDO Exception Questions – How to Catch Them

Leave a Comment