Question

Which of the methods are used to manage result sets using both associative and indexed arrays?

(a) get_array() and get_row()

(b) get_array() and get_column()

(c) fetch_array() and fetch_row()

(d) mysqli_fetch_array() and mysqli_fetch_row()

This question was posed to me in semester exam.

I need to ask this question from Working with Databases-2 in portion Objects and Databases in PHP of PHP

Answer 1

Right answer is (d) mysqli_fetch_array() and mysqli_fetch_row()

Easiest explanation: The method mysqli_fetch_array() is used to fetch a result row as an associative array or a numeric array.

And the function mysqli_fetch_row() is used to fetche one row from a result-set and returns it as an enumerated array.

The method fetch_array() and fetch_row() were used in the previous version of PHP.