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 value for this auto incremented field user_pri_id?
What are php loops?
How to write the form tag correctly for uploading files?
What is variable give example?
What is session in php w3schools?
Is java is better than php?
What is isset post?
hello.. i am b.tech 4th year student. i am confused that i should learning php or java. I have some knowledge of java and developed project in java, but i want to develop my career in php. So plz suggest me , i should go with php or java.
What is use of count() function in php?
What is the ioncube php loader?
how set session expire time in php?
How to count a number of words in a string in php?