What is the difference between mysql_fetch_object and
mysql_fetch_array?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What is the difference between get and post method in php?
What is global array in php?
Is php better than python?
Which php framework is best for beginners?
How can you get the size of an image in PHP?
i m a B.E,passed out few yrs bak failed to find good job due to less marks now thinkin of a career as PHP developer. is it a lucarative field and wat r career prospects; hv heard dat initial salary is very less bout 6k also most jobs r contrct jobs.pls guide me need ur valuable advice.pls hellppp!! thnx..
How to convert a timezone from one to another ?
What is static variable in php?
What is repository in php?
What are the security measures we have to take for our site not to hack by others.
3 Answers Infosys, Torque Infotech,
i am a php programmer can i be a java programmer?
What are the differences between PHP3 and PHP4 versions?