What is the difference between mysql_fetch_object and mysql_fetch_array?
Mysql_fetch_object returns the result from the database as objects while mysql_fetch_array returns result as an array. This will allow access to the data by the field names. Example:
Using mysql_fetch_object field can be accessed as $result->name and using mysql_fetch_array field can be accessed as $result->[name]
Explain the ways to retrieve the data in the result set of MySQL using PHP.
Ways to retrieve the data in the result set of MySQL using PHP1. mysql_fetch_row($result):
where $result is the result resource returned from a successful query executed using the mysql_query() function.Example:
$result = mysql_query(“SELECT * from students);2. mysql_fetch_array($result):
while($row = mysql_fetch_row($result))
Return the current row with both associative and numeric indexes where each column can either be accessed by 0, 1, 2, etc., or the column name.Example:
$row = mysql_fetch_array($result)3. mysql_fetch_assoc($result):
Return the current row as an associative array, where the name of each column is a key in the array.Example:
$row = mysql_fetch_assoc($result)
What is the difference between mysql_fetch_object and mysql_fetch_array in PHP?mysql_fetch_object:
Results are objects returned from database. Fields are accessible like
$result->name, $result->cust_name, where $result is the result object and name, cust_name are the fields.mysql_fetch_array :
Results are arrays returned from database. Fields are accessible like $result[name], $result[cust_name].