Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between mysql_fetch_object and
mysql_fetch_array?
- 10 Answers
- 37246 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 |
Why we use get in php?
What is the current php version?
Is it possible to destroy a cookie?
How many types of session are there?
What is the default session time in PHP and how can I change it?
How many ways I can redirect a PHP page?
9 Answers MicroSec, N-Tier Business Solutions, University Exams,
In php, how to redirect from one page to another page?
How can we connect to a mysql database from a php script?
hello friend koi mujhe bata skta ke php easy way se aur jaldi kese seekh skte h...plz im waiting for ur answer..
Why php is used with mysql?
How to check curl is enabled or not in PHP
Where can I learn php?
PHP 
