PHP fetch MySQL array with an index

Question

When fetching an array from MySQL the rows are typically returned with a key from 0 to the size of your recordset:

row[0][key][value]

Is it possible to have one of the fields from the select statement returned as the key in the array?

For example. Assuming my data set has StudentID, Name, City, etc.

How can I select into an array where I could refer to the StudentID as the index like this:

rows[StudentID][Name]
rows[StudentID][City]
etc.

Thanks!

you should post some code instead of writing "When fetching an array..." — Your Common Sense
– Your Common Sense, Commented Apr 8, 2011 at 22:05

Kevin Peno · Accepted Answer · 2011-04-08 22:04:31Z

2

PDOStatement::fetchAll

To return an associative array grouped by the values of a specified column, bitwise-OR PDO::FETCH_COLUMN with PDO::FETCH_GROUP.

// Other PDO stuff to get a statement - abstract below
$result = PDOStatement::fetchAll( PDO::FETCH_COLUMN | PDO::FETCH_GROUP, 0 );

See example 3 on this page

answered Apr 8, 2011 at 22:04

Kevin Peno

9,2261 gold badge36 silver badges56 bronze badges

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

1 Comment

djot Over a year ago

This works, but not as needed, when e.g. column 0 is an (unique) ID like here StudentID. Then you'll always get an "extra" index 0 level, like e.g. StudentID=4: ARRAY(4=>ARRAY(0=>ARRAY('StudendID'=>4, 'StudendName'=>'Joe', ...)))

Tieson T. · Accepted Answer · 2011-04-08 22:04:55Z

0

Depending on which library you are using:

mysql_fetch_assoc()

mysqli_fetch_assoc()

PDO fetches both by default.

answered Apr 8, 2011 at 22:04

Tieson T.

21.2k6 gold badges82 silver badges99 bronze badges

3 Comments

Kevin Peno Over a year ago

He wants the first column to the the array key of the result set.

Tieson T. Over a year ago

@Kevin Peno Oh, that wasn't entirely obvious from the original version of this question. Sorry.

Tieson T. Over a year ago

@ Kevin Peno No offense taken, either. Thanks. :)

Collectives™ on Stack Overflow

PHP fetch MySQL array with an index

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related