There are 4 ways of handling the result set of MySQL in PHP. They are:
- mysqli_fetch_array(): Returns the current row of the result set as an associative array, a numeric array, or both.
- mysqli_fetch_assoc(): Returns the current row of the result set as an associative array.
- mysqli_fetch_object(): Returns the current row of a result set, as an object.
- mysqli_fetch_row(): Returns result in a row as an enumerated array.