mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object

by

mysql_fetch_array will get you an array that can have as keys :

  • both numbers and names of columns, if using MYSQL_BOTH
  • columns names, using MYSQL_ASSOC — in this case, you’ll get the same thing you get when using mysql_fetch_assoc
  • only numbers (depending on the order of columns in the query), if using MYSQL_NUM

Getting results indexed by columns names is probably the most useful solution — easier to use, at least.

But getting results indexed by the positions of the fields in the select clause is interesting in one situtation : when you have several columns that have the same name or alias.

In this case, as you cannot have two entries with the same index in an array, you will be able to access only one of those columns using the column name as index.

For the other columns that have the same name, you’ll have to use numeric indexes.

That situation is probably the only case for which I would use mysql_fetch_array — and I rather prefer using aliases in my query, to avoid that situation — it’s more clear, in my opinion.

mysql_fetch_assoc will get you an array, with columns names as keys, and data as values.

Not much to say, actually.

And mysql_fetch_object will get you objetcs in return.

Choosing between mysql_fetch_assoc and mysql_fetch_object most probably depend on how you develop your application : if using objects everywhere, the second one is probably the most suited.

If using arrays as data-containers, you can just go with the first one.

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. remove duplicate key array from php [duplicate]
  4. How can I sort arrays and data in PHP?
  5. How can I access an array/object?
  6. Modify array values in foreach loop
  7. How to find entry by object property from an array of objects?
  8. Sum values of multidimensional array by key without loop
  9. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  10. What is the best method to merge two PHP objects?
  11. Trying to get property of non-object in [duplicate]
  12. Save PHP array to MySQL?
  13. Sort array of objects by one property
  14. PHP OOP core framework
  15. Notice: Array to string conversion in
  16. How get all values in a column using PHP?
  17. mysql select query within a serialized array
  18. PDO fetch one column from table into 1-dimensional array
  19. Using usort in php with a class private function
  20. Get all mysql selected rows into an array
  21. Select from mysql table WHERE field=’$array’?
  22. Array to Object and Object to Array in PHP – interesting behaviour
  23. Dynamically create PHP object based on string
  24. Creating anonymous objects in php
  25. MySQL query using an array [duplicate]
  26. How to insert json array into mysql database
  27. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  28. Create PHP array from MySQL column
  29. How to get the object or class name?
  30. Save array in mysql database

Leave a Comment