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()
Answer Posted / 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 |
Post New Answer View All Answers
What is php addslashes?
How can we set and destroy the cookie in php?
What is interface? Why it is used?
Tell me how to get the value of current session id?
How to get the position of the character in a string in php?
What is "print" in php?
what is benefit of magento?
What do you mean by core php?
What is the current stable version of php? What advance thing in php7?
What is get method in java?
What is a php tag?
How to get the total number of values in an array?
Write a php script to get the largest key in an array?
What is restful api?
What is a comment in php?