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
- 8167 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 |
How many escape sequences are recognized in double-quoted strings in php?
How many php functions are there?
How do you connet mysql database with php?
Why ide is recommended for use while programming with php?
How can we set and destroy the cookie in php?
Explain the importance of the function htmlentities.
Echo is used to Display message on screen. Which is used with echo to not output the trailing newline?
What is the function mysql_pconnect() useful for?
Can you extend a final defined class?
How to terminate the execution of a script in PHP?
Which php framework is fastest?
How to delete a file from the system?
PHP 
