Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between mysql_fetch_object and
mysql_fetch_array?
- 10 Answers
- 37610 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 types of Data Can Be Used as Array Keys?
class Database { public static $_instance; public static function getInstance() { if(!isset(self::$_instance)) self::$_instance = new Database(DB_SERVER, DB_USER, DB_PASS, DB_NAME); print_r(self::$_instance); return self::$_instance; } } can any one explain "self::$_instance = new Database(DB_SERVER, DB_USER, DB_PASS, DB_NAME);" this line
1.What is application server ? 2.What is web server ? 3.Explain the process of execution of a php file ?
Why super () is used in java?
Explain which cryptographic extension provide generation and verification of digital signatures?
How can we create a database using php?
What is fulltextsearch
i have designed a registration form in html (registration.html) and to insert user details in database i have designed a submit form in php (submit_registration.php) but when i click on submit button in registration.html it opens a dialogue box which asks for open or save php(submit_registration.php) even though i have already installed apache HTTP server and php version 5 on my computer and i am using mysql as backend. plz suggest me what should i do????
How to redirect https to http url and vice versa in .htaccess?
What is use of count() function in php?
What is strlen php?
How to run a php script?
PHP 
