PDO 'fetchAll' return rows with an extra array

I think the issue was by ths following , I am writing my own simply ORM using PDO. My question is if you can force PDOStatement::fetchAll() method to return array of objects of stdClass? For example: , Use $result = $q->fetchAll(PDO::FETCH_OBJ);

hop of those help? Zeos returns number of already fetched records. It does not take into account any applyed filters and does not do FetchAll before returning RecordCount. SELECT COUNT(*) ... is not "much more efficient", because it creates additional server workload, which sometimes may be equal to workload to execute an original query. In general, a data access library may offer 3 modes of record count calculation: the number of fetched rows, the number of visible rows (like first, but after applying filters), and SELECT COUNT(*). FetchAll or not FetchAll will be better to control explicitly. This is how this is done in AnyDAC (more).

wish of those help The issue happens because the returned data isn't encoded in utf-8 as it is required by json_encode.
To fix it the charset=utf8 attribute must be added to the PDO's DSN.

Hope this helps I tried to output all values in a column in mysql however, it also outputs extra comma in the end. , a couple more options:

# validate that the results contain exactly one column
for [x] in result:
    print(x)

# using argument unpacking
for x in result:
    print(*x)

I wish this help you I used the encode function for fetched data. Unicode to ASCII converted for the solution.