CI_DB_result::row()

row([$n = 0[, $type = 'object']]) Parameters: $n (int) – Index of the query results row to be returned $type (string) – Type of the requested result - array, object, or class name Returns: The requested row or NULL if it doesn’t exist Return type: mixed A wrapper for the row_array(), row_object() and ``custom_row_object() methods. Usage: see Result Rows.

CI_DB_result::set_row()

set_row($key[, $value = NULL]) Parameters: $key (mixed) – Column name or array of key/value pairs $value (mixed) – Value to assign to the column, $key is a single field name Return type: void Assigns a value to a particular column.

CI_DB_result::result_object()

result_object() Returns: Array containing the fetched rows Return type: array Returns the query results as an array of rows, where each row is an object of type stdClass. Usage: see Result Arrays.

CI_DB_result::result()

result([$type = 'object']) Parameters: $type (string) – Type of requested results - array, object, or class name Returns: Array containing the fetched rows Return type: array A wrapper for the result_array(), result_object() and custom_result_object() methods. Usage: see Result Arrays.

CI_DB_result::last_row()

last_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Last row of result set, or NULL if it doesn’t exist Return type: mixed Returns the last row from the result set.

CI_DB_result::list_fields()

list_fields() Returns: Array of column names Return type: array Returns an array containing the field names in the result set.

CI_DB_result::previous_row()

previous_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Previous row of result set, or NULL if it doesn’t exist Return type: mixed Returns the previous row from the result set.

CI_DB_result::num_fields()

num_fields() Returns: Number of fields in the result set Return type: int Returns the number of fields in the result set. Usage: see Result Helper Methods.

CI_DB_result::num_rows()

num_rows() Returns: Number of rows in the result set Return type: int Returns the number of rows in the result set. Usage: see Result Helper Methods.

CI_DB_result::next_row()

next_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Next row of result set, or NULL if it doesn’t exist Return type: mixed Returns the next row from the result set.