Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between mysql_fetch_object and
mysql_fetch_array?
- 10 Answers
- 37327 Views
- Sarv, I also Faced
- E-Mail Answers
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 |
hi sir am a fresher just learning LAMP COURSE linux,apache,mysql and php .just i finished my M.C.A 2009 passed out ..can any one tell after i finish this course how much salary we expect in any php based company ? and also tell please how much salary we can demand as a fresher with my M.C.A qualification as a PHP fresher in a company ? how much we get atleast mininum as a PHP fresher in CHENNAI and Bangalore just send ur valuable suggestions to kiranpulsar2007@gmail.com please guide to me sir
Tell me what is the definition of a session?
What is an anti csrf token?
What is php how it works?
What is strcmp () in php?
What is data structure in php?
How to open standard output as a file handle?
What’s the special meaning of __sleep and __wakeup?
How does the identity operator ===compare two values in PHP?
What are the differences between require and include, include_once?
How to close a session properly?
What are hooks in php?
PHP 
