PDO prepared statement fetch() returning double results

by

You should say to PDO, that you want only an associative array or a numbered array:

while ($rows_get_rows = $result_get_rows->fetch(PDO::FETCH_ASSOC))

to get an associative array or

while ($rows_get_rows = $result_get_rows->fetch(PDO::FETCH_NUM))

to get an array indexed by the column number

from PDOStatement::fetch

fetch_style

Controls how the next row will be returned to the caller.
This value must be one of the PDO::FETCH_* constants, defaulting to
value of PDO::ATTR_DEFAULT_FETCH_MODE (which defaults to
PDO::FETCH_BOTH).

PDO::FETCH_ASSOC: returns an array indexed by column name as returned
in your result set

PDO::FETCH_BOTH (default): returns an array indexed by both column
name and 0-indexed column number as returned in your result set

More Related Contents:

  1. PDO::fetchAll vs. PDO::fetch in a loop
  2. PDOException SQLSTATE[HY000] [2002] No such file or directory
  3. How to get numeric types from MySQL using PDO?
  4. How can I use PDO to fetch a results array in PHP?
  5. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  6. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  7. php pdo: get the columns name of a table
  8. Use bound parameter multiple times
  9. MySQL check if a table exists without throwing an exception
  10. how safe are PDO prepared statements
  11. Replacing mysql_* functions with PDO and prepared statements
  12. PDO + MySQL and broken UTF-8 encoding
  13. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  14. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  15. php code to test pdo is available?
  16. Calling stored procedure with Out parameter using PDO
  17. When *not* to use prepared statements?
  18. PDO fetchAll group key-value pairs into assoc array
  19. How to select multiple rows from mysql with one query and use them in php
  20. PDO MySQL: Insert multiple rows in one query
  21. How to bind LIKE values using the PDO extension?
  22. Binding parameters for WHERE IN clause with PDO [duplicate]
  23. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  24. PDO::rowCount VS COUNT(*)
  25. PHP 7 RC3: How to install missing MySQL PDO
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment