Which is the best method to fetch the data from mysql?
1.mysql_fetch_array()
2.mysql_fetch_object()
3.mysql_fetch_row()
4.mysql_fetch_assoc()
- 6 Answers
- 8223 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mervin thomas
I think all mysql_fetch_array() is the best one, since we
can get the value of the records using the numeric index (as
numbers) or using the string index (as column).
mysql_fetch_array () => fetches the records using the two
way index method,
(ex). $record[0];
$record['id'];
gives the same value.
mysql_fetch_row() fetches the records using the numerical index
ex. $record[0];
mysql_fetch_assoc() fetches the records using the string
index and returs the records as associative array
ex. $record['id'];
mysql_fetch_object() fetches the records as the object.
ex. $record->id;
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / pratik
mysql_fetch_object() is the best method. It is not
generally affected in small result. mysql_fetch_array() has
some limit to fetch data from table. when result it too high
(more than 4000 record) at that time
mysql_fetch_object()will support.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 24/06/08
mysql_fetch_array() is select total values of tables.
mysql_fetch_object() is select a partcular name of the row
in a tables.
mysql_fetch_row() is select row in tables is saem one
object functionor comment.
mysql_fetch)assoc() it means the same function of
mysql_fetch)row and object function.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / pradeep
hi all,
i think mysql_fetch_object or mysql_fetch_array both are best method bcz both are take same time for result show.
but mysql_fetch_array() fetches the records using the numeric index (as numbers) or using the string index (as column)
mysql_fetch_object() fetches the records as the object.
ex. $record->id;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / devendra modi
mysql_fetch_object() is better then mysql_fetch_array()
because mysql_fetch_array () will return numeric and
associative array if you have 1 lac record then it will
generate two array mean load two lack record. so it is
slower then mysql_fetch_object()
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vinoth
My Opinion is at the developer point of view
mysql_fetch_assoc() is the Best method to fetch data but at
the same time at the user point of view we can use
mysql_fetch_object()for faster execution of the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Php says that an array is an ordered map. But how the values are ordered in an array?
What are the steps for the payment gateway processing?
What are the array functions in php?
How can we extract string ‘abc.com ‘ from a string info@abc.com" target="_blank">http://info@abc.com using regular expression of php?
What is a substring in php?
What should we do to be able to export data into an excel file?
What is echo and print in php?
full form of php??
What is the basic function to search files for lines (or other units of text) that contain a pattern.
Where is session value stored php?
How to upload any files extension in our database Ex.(.doc,.txt,mp4,mp3 etc.)in php
What is singleton design pattern in php?
PHP 
