In how many ways we can retrieve the date in the result set
of mysql using PHP?
Answer Posted / binoyav
1) mysql_result: returns the value of a field in a recordset.
Note: This function is slower than mysql_fetch_row(), mysql_fetch_array(), mysql_fetch_assoc() and mysql_fetch_object()
2) mysql_fetch_array(): function returns a row from a recordset as an associative array and/or a numeric array. Note: Its a misconception that, this function will return all rows. Its completely wrong, it will return only a single row at a time as like mysql_fetch_row
3) mysql_fetch_row(): returns a row from a recordset as a numeric array
4) mysql_fetch_assoc(): returns a row from a recordset as an associative array. No numerical indices available for this
5) mysql_fetch_object(): returns a row from a recordset as an object
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to delete a file from the system?
Will php die?
What is the use of mvc in php?
What is full form of PHP?
What's the difference between __sleep and __wakeup?
What is the different between count() and sizeof() in php?
How many types of php are there?
What is final class and final method in php?
What is regex in html?
Why session timeout is important?
What is session_register()?
How do you end a session in php?
What is magic quotes?
What is singleton class in php?
Does jwt protect against csrf?