PDO fetch array of arrays. Outer has numeric index. Inner has associative index

Question

Am working on a database of student lessons and answers. Each assignment and each result has an associative array with six or more fields (columns) stored in a MySQL database in lesson and answer tables.

I use sql PDO execute() to get all the assignments and also different sql to get all the results.

FetchAll gives me an outer numeric array and an inner array with both numeric and associative indexes. I want only associative indexes on the inner array. ->fetch(\PDO::FETCH_ASSOC); gives me nothing. (the \ due to name spaces -- without the \ I get an error) ->fetchAll(); gives me an outer numeric index array and the inner arrays with both indexes.

I can strip out the inner numeric indexes or ignore them, but that seems klutzy as these inner arrays are used many ways.

Perhaps the answer is in the sql instead of the fetch. The best I have come up with so far is stripping out the numeric indexes with:

    $stmt->execute();
    $rows = $stmt->fetchAll();
    foreach ($rows as $key=>$value) {
        foreach ($value as $key2=>$value2) {
            if (is_numeric($key2) === TRUE) {
                unset($value[$key2]);
            }
        }
        $rows[$key] = $value;
    }
    return $rows;

Is there a better way?

jimfuqua

fetchAll() will also accept PDO::FETCH_ASSOC. Its first arg is $fetch_style which is the same as that of fetch(). — Michael Berkowski
– Michael Berkowski, Commented Jan 12, 2015 at 14:06
As for getting nothing from fetch(), when did you call it? If fetchAll() had already been called, then the internal record pointer would have no rows left to return and it would return false. — Michael Berkowski
– Michael Berkowski, Commented Jan 12, 2015 at 14:08
Thanks Michael, you are correct. I did not understand that fetchAll() could contain the limitation. With $rows = $stmt->fetch(\PDO::FETCH_ASSOC); I got one of the inner arrays as associative only. There was no outer array and one of the inner arrays was missing. Because they were identical, I could not tell which inner array was lost. With $rows = $stmt->fetchAll(\PDO::FETCH_ASSOC); I got just what I was looking for. The outer array had a numeric index and the inner array had an associative index. — JimFuqua
– JimFuqua, Commented Jan 15, 2015 at 15:25
You should go ahead and post your solution as an answer below. — Michael Berkowski
– Michael Berkowski, Commented Jan 15, 2015 at 15:29

JimFuqua · Accepted Answer · 2015-01-15 15:42:30Z

1

With help from Michael Berkowski's comment, I tried an experiment.

With $rows = $stmt->fetchAll(\PDO::FETCH_ASSOC); I got just what I was looking for. The outer array had a numeric index and the inner array had an associative index.

With $rows = $stmt->fetchAll(); I got the duplication I was trying to avoid.

With $rows = $stmt->fetch(\PDO::FETCH_ASSOC); I got one of the inner arrays as associative only. There was no outer array and one of the inner arrays was missing. Because they were identical, I could not tell which inner array was lost.

JimFuqua

answered Jan 15, 2015 at 15:42

JimFuqua

1,0911 gold badge8 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PDO fetch array of arrays. Outer has numeric index. Inner has associative index

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related