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
What is csrf mvc?
What is difference between isset and empty in php?
How come the code works, but does not for two-dimensional array of mine?
Is java is better than php?
What are the encryption functions available in PHP?
What happens when submit button is clicked?
What is explode() in php?
How to define a function with any number of arguments?
Which function would you use to read a line of data from a file in php?
When use javascript vs php?
What changes I have to do in php.ini file for file uploading?
How to remove a file?
What are the different ways to login to a remote server?
What is namespaces in PHP?
So if md5() generates the most secure hash, why would you ever use the less secure crc32() and sha1()?