1.

What Are The Differences Between Mysql_fetch_array(), Mysql_fetch_object(), Mysql_fetch_row()?

Answer»

Mysql_fetch_object is used to retrieve the result from the DATABASE as objects while mysql_fetch_array returns result as an ARRAY. This will allow access to the data by the field names.
For EXAMPLE:
Using mysql_fetch_object field can be accessed as $result->NAME.
Using mysql_fetch_array field can be accessed as $result->[name].
Using mysql_fetch_row($result) where $result is the result resource returned from a successful query executed using the mysql_query() function.
Example:
1.$result = mysql_query("SELECT * from students");
2.while($row = mysql_fetch_row($result))
3.{
4.Some statement;
5.}

Mysql_fetch_object is used to retrieve the result from the database as objects while mysql_fetch_array returns result as an array. This will allow access to the data by the field names.
For example:
Using mysql_fetch_object field can be accessed as $result->name.
Using mysql_fetch_array field can be accessed as $result->[name].
Using mysql_fetch_row($result) where $result is the result resource returned from a successful query executed using the mysql_query() function.
Example:
1.$result = mysql_query("SELECT * from students");
2.while($row = mysql_fetch_row($result))
3.{
4.Some statement;
5.}



Discussion

No Comment Found