Understanding array notation (specifically mysql_fetch_array and print_r)

Question

Do functions that print arrays all use the same notation to do so? What is the reasoning for one notation over another? I noticed when using PHP print_r to display an array compiled using mysql_fetch_array, the notation of the array is as follows:

Array ([column] => value [index] = value)

For example, if this is the table:

id fname lname
1 John Smith

Then the print_r output of mysql_fetch_array will be:

Array ([id] => 1 [0] => 1 [fname] => John [1] => John [lname] => Smith [2] => Smith)

What is the reason for this notation? Specifically, why does the value repeat? Isn't that redundant?

Also, can anybody recommend a good resource for a better conceptual understanding of arrays in general? Thanks!

Paul · Accepted Answer · 2012-03-16 13:16:15Z

4

Associative arrays use strings for the index, numeric arrays use numbers.

mysql_fetch_array() creates an associative array containing numeric keys as well so that both may be used to access the array.

mysql_fetch_assoc() creates an array containing only the string indices.

mysql_fetch_row() creates an entirely numeric array, and is the fastest to execute of these functions.

edited Mar 16, 2012 at 13:16

answered Jul 22, 2011 at 0:34

Paul

142k28 gold badges285 silver badges272 bronze badges

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

Comments

Wrikken · Accepted Answer · 2011-07-22 00:49:41Z

3

print_r & var_dump are for debugging by a developer only. Its syntax is not set in stone, and shouldn't be relied upon. The only thing that matters is that it's readable to the developer. Especially look at the source of a html document and you see a more structured formatting.

As for your second question: seems like you did a mysql_fetch_array() instead of mysql_fetch_row or mysq_fetch_assoc, see the manual pages for those functions.

As for sources to learn about arrays: have you tried the manual?

edited Jul 22, 2011 at 0:49

answered Jul 22, 2011 at 0:35

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Comments

genesis · Accepted Answer · 2011-07-22 00:39:16Z

2

mysql_fetch_assoc(); will give you what you want

mysql_fetch_array allows you use

$array['id']

but either

$array[0];

mysql_fetch_row(); gives you only these numeric values and

mysql_fetch_assoc(); gives you only these string values

answered Jul 22, 2011 at 0:39

genesis

51.1k20 gold badges99 silver badges127 bronze badges

Collectives™ on Stack Overflow

Understanding array notation (specifically mysql_fetch_array and print_r)

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related