What is the difference between mysql_fetch_object and
mysql_fetch_array?

Answers were Sorted based on User's Feedback



What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / priya ranganathan

mysql_fetch_object : will return the results from database
as objects. fields will be accessible like in objects
i.e $result->name,$result->cust_name

mysql_fetch_array : will return the results from database as
array. fields will be accessible like in objects
i.e $result[name],$result[cust_name]




Is This Answer Correct ?    139 Yes 10 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / arumugam

mysql_fetch_object : will return the results from database
as objects. fields will be accessible like in objects
i.e $result->name,$result->cust_name

mysql_fetch_array : will return the results from database as
an array.The array will be in in associative as well as
numeric manner.
i.e $result['column_name'] or $result[0].here '0'indicates
first column in table

Is This Answer Correct ?    47 Yes 4 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / arvind pippal

mysql_fetch_object will return an object by which we can
access the database fields records while mysql_fetch_aaray
return array of database records and return associative
array.

Is This Answer Correct ?    38 Yes 19 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / rupal

mysql_fetch_row ::Return row as aan enumrated array and each
line contain a unique ID .example.
$result=mysql_query($query);
while($row=mysql_fetch_row($result))
{
print $row[0] ;
print $row[1] ;
print $row[2] ;
}

mysql_fetch_array ::Return row as anassociative or an
enumrated array or both which is default .you can refer to
outputs as databases fieldname rather then number .example.
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
print $row['name'] ;
print $row['address'] ;
print $row['city'] ;
}

mysql_fetch_object :: it return as an object on the place of
array.

$result=mysql_query($query);
while($row=mysql_fetch_object($result))
{
print $row->name ;
print $row->address ;
print $row->city ;
}

Is This Answer Correct ?    18 Yes 1 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / shesh

mysql_fetch_object.....it return result as a object like
$result->name;
$result->city;

mysql_fetch_array.....it return result as a assiciative
array like
$result['name'];
$result['city'];

Is This Answer Correct ?    19 Yes 7 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / vinod

mysql_fetch_object : as an object, we can access value by
column name as properties of the object.

mysql_fetch_array : as an associative array, we can access
value by column name as like associative name as column name
from array

Is This Answer Correct ?    11 Yes 8 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / ghan shyam

mysql_fetch_object : will return the results from database
as objects. fields will be accessible like in objects
i.e $result->name,$result->cust_name

mysql_fetch_array : will return the results from database as
array.
you have to define array type in second parameter of mysql_fetch_array function.

fields will be accessible like
$result[name],$result[cust_name] (if type =MYSQL_ASSOC)

or like
$result[0],$result[1] (if type =MYSQL_NUM)

or like
$result[name],$result[cust_name],$result[0],$result[1] (if type=MYSQL_BOTH)

Is This Answer Correct ?    6 Yes 5 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / shivang

yaar sabhi ek hi cheez keh rahein hain....mein aur kya post
karoon...i can only say......











same as above :P

Is This Answer Correct ?    12 Yes 12 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / bijaya.behera9911033016@orissa

mysql_fetch_object : as an object, we can access value by
column name as properties of the object.

mysql_fetch_array : as an associative array, we can access
value by column name as like associative name as column name
from array.

Is This Answer Correct ?    11 Yes 13 No

What is the difference between mysql_fetch_object and mysql_fetch_array?..

Answer / abhishek

my_fetch_object is only fetch the object value and
my_fetch_array is handle the arry but in associative form..
so this is the basic difference.

Is This Answer Correct ?    7 Yes 9 No

Post New Answer

More PHP Interview Questions

What are the differences between procedure-oriented languages and object-oriented languages?

6 Answers   ASD Lab, DewSoft,


How many ways you can delete a session variable ?

6 Answers  


Explain what are psrs?

0 Answers  


how to detect a mobile device using php

0 Answers  


What do you mean range() in php?

0 Answers  






How can you pass a variable by reference?

0 Answers  


Is facebook still written in php?

0 Answers  


What does == mean in php?

0 Answers  


Can we override static method?

0 Answers  


Which function would you use to insert a record into a database in php?

0 Answers  


Explain type casting and type juggling.

0 Answers  


How many open modes available when a file open in PHP?

0 Answers  


Categories