Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between mysql_fetch_object and
mysql_fetch_array?
- 10 Answers
- 36901 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 |
What the limitation of header() function in php?
How can you create a session in php?
What is mysql_fetch_row?
What kind of things have you done on the social side?
What is lazy loading in php?
What are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10)) ?
when will be syndicate bank written exam ? i need the date of exam
Explain the ternary conditional operator in php?
How to get the directory name out of a file path name?
Does php support inheritance?
How to execute a php script from the command line?
Can we override magic methods in php?
PHP 
