What is the difference between mysql_fetch_object and
mysql_fetch_array?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between array_pop() and array_push()?
How to check a variable is array or not in php?
What are the ways to include file in php?
Is overloading possible in php?
Why php is also called as scripting language?
How to execute a function in php?
Tell me how is it possible to remove escape characters from a string?
What is the use of print_r function in php?
How to call a php function from another php file?
Tell me what is the actually used php version?
Tell me how a constant is defined in a php script?
Why do we use htaccess and where?
If the variable $var1 is set to 10 and the $var2 is set to the character var1, what's the value of $$var2?
What is the Pipe Symbol represented?
What is split function in php?