In how many ways we can retrieve the date in the result set
of mysql using PHP?
Answers were Sorted based on User's Feedback
Answer / vasan.
4 ways
1. mysql_fetch_rows
2. mysql_fetch_object
3. mysql_fetch_assoc
4. mysql_fetch_array
| Is This Answer Correct ? | 57 Yes | 4 No |
Answer / bijay.behera9911033016@orissa
1. mysqli_fetch_rows
2. mysqli_fetch_object
3. mysqli_fetch_assoc
4. mysqli_fetch_array
| Is This Answer Correct ? | 22 Yes | 4 No |
Answer / ankish kumar
What is the difference between all these 4 versions:
1. mysqli_fetch_rows
2. mysqli_fetch_object
3. mysqli_fetch_assoc
4. mysqli_fetch_array
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / 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 |
What is the delimiter default in PHP?
Is php used anymore?
What does csrf token mean?
What is an anti csrf token?
Inside a php function, what param needs to be set in order to access a global variable?
What is a query in php?
How to add a cookie?
What is strlen function in php?
How do I stop php artisan serve in windows?
What are the different ways to login to a remote server?
Which function would you use to merge two arrays in php?
Does php 7 support mysql?