summaryrefslogtreecommitdiffstats
path: root/user_guide_src/source
diff options
context:
space:
mode:
authorAndrey Andreev <narf@devilix.net>2014-12-08 13:45:16 +0100
committerAndrey Andreev <narf@devilix.net>2014-12-08 13:45:16 +0100
commitc84e10f059773d1cc7b77d1e9e72738c4bbc342f (patch)
tree63227b68dd1a4fa6217adb23653484c1ba138915 /user_guide_src/source
parent162b1a9824deba1369d756eccc9535544452b479 (diff)
parent8b875cedfa63a06420b9908c3266daddf3a6a706 (diff)
Merge pull request #3395 from jim-parry/userguide/results
User Guide - generating query results
Diffstat (limited to 'user_guide_src/source')
-rw-r--r--user_guide_src/source/database/results.rst185
1 files changed, 184 insertions, 1 deletions
diff --git a/user_guide_src/source/database/results.rst b/user_guide_src/source/database/results.rst
index e06985130..044360ebb 100644
--- a/user_guide_src/source/database/results.rst
+++ b/user_guide_src/source/database/results.rst
@@ -4,6 +4,10 @@ Generating Query Results
There are several ways to generate query results:
+.. contents::
+ :local:
+ :depth: 2
+
*************
Result Arrays
*************
@@ -238,4 +242,183 @@ TRUE on success or FALSE on failure.
$row = $query->unbuffered_row();
.. note:: Not all database drivers support this feature and will return FALSE.
- Most notably - you won't be able to use it with PDO. \ No newline at end of file
+ Most notably - you won't be able to use it with PDO.
+
+***************
+Class Reference
+***************
+
+.. class:: CI_DB_result
+
+ .. method:: custom_result_object($class_name)
+
+ :param string $class_name: Class name for the results
+ :returns: Array of objects of type $class_name
+ :rtype: array of $class_name
+
+ Return the query results as an array of the specified class.
+
+ .. method:: custom_row_object($n, $type)
+
+ :param int $n: Index of the results row to return
+ :param string $class_name: Class name for the results
+ :returns: Object of type $type
+ :rtype: $type
+
+ Return a specific row from the query results as an object of
+ the specified class.
+
+ .. method:: data_seek([$n = 0])
+
+ :param int $n: Index of the results row to be returned next
+ :returns: TRUE on success, FALSE otherwise
+ :rtype: bool
+
+ Moves the internal results row pointer to the desired offset.
+ Usage: see `Result Helper Methods`_.
+
+ .. method:: field_data()
+
+ :returns: Array of objects containing field meta-data.
+ :rtype: array
+
+ Generates an array of objects containing field meta-data.
+
+ .. method:: first_row([$type = 'object'])
+
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: First row of result set
+ :rtype: mixed
+
+ Returns the "first" row, as an array, generic object, or
+ object of a specific class
+
+ .. method:: free_result()
+
+ :rtype: void
+
+ Free the result.
+ Usage: see `Result Helper Methods`_.
+
+ .. method:: last_row([$type = 'object'])
+
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: Last row of result set
+ :rtype: mixed
+
+ Returns the "last" row, as an array, generic object, or
+ object of a specific class
+
+ .. method:: list_fields()
+
+ :returns: Array of column names
+ :rtype: array
+
+ Fetch Field Names
+
+ .. method:: next_row([$type = 'object'])
+
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: "Next" row of result set, NULL if there isn't one
+ :rtype: mixed
+
+ Returns the "next" row, as an array, generic object, or
+ object of a specific class
+
+ .. method:: num_fields()
+
+ :returns: Number of fields in the result set
+ :rtype: integer
+
+ Number of fields in the result set.
+ Usage: see `Result Helper Methods`_.
+
+ .. method:: num_rows()
+
+ :returns: Number of rows in the result set
+ :rtype: integer
+
+ Number of rows in the result set.
+ Usage: see `Result Helper Methods`_.
+
+ .. method:: previous_row([$type = 'object'])
+
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: "Previous" row of result set, NULL if there isn't one
+ :rtype: mixed
+
+ Returns the "previous" row, as an array, generic object, or
+ object of a specific class
+
+ .. method:: result([$type = 'object'])
+
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: Query results as the specified type
+ :rtype: mixed
+
+ Query result. Acts as a wrapper function for the result_array,
+ result_object and custom_result_object methods.
+ Usage: see `Result Arrays`_.
+
+ .. method:: result_array()
+
+ :returns: Query results as an associative array
+ :rtype: array
+
+ Returns the query results as an array of rows, where each
+ row is itself an associative array.
+ Usage: see `Result Arrays`_.
+
+ .. method:: result_object()
+
+ :returns: Query results as an array of objects
+ :rtype: array
+
+ Returns the query results as an array of rows, where each
+ row is an object
+
+ .. method:: row([$n = 0[, $type = 'object']])
+
+ :param integer $n: Index of the query results row to be returned
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: Requested row of result set
+ :rtype: mixed
+
+ Wrapper for result_row_array, result_row_object, and
+ custom_row_object.
+ Usage: see `Result Rows`_.
+
+ .. method:: row_array([$n = 0])
+
+ :param integer $n: Index of the query results row to be returned
+ :returns: Requested row of result set
+ :rtype: array
+
+ Returns requested result row as an associative array.
+ Usage: see `Result Rows`_.
+
+ .. method:: row_object([$n = 0])
+
+ :param integer $n: Index of the query results row to be returned
+ :returns: Requested row of result set
+ :rtype: object
+
+ Returns requested result row as an object
+
+ .. method:: set_row($key[, $value = NULL])
+
+ :param mixed $key: Column index or array of key/value pairs
+ :param mixed $value: Result to assign to a column if the key is an index
+ :rtype: void
+
+ Assigns an item into a particular column slot
+
+ .. method:: unbuffered_row([$type = 'object'])
+
+ :param string $type: Type of result requested - array, object, or class name
+ :returns: Requested row of result set
+ :rtype: mixed
+
+ Fetches the next result row and returns it in the requested
+ form.
+ Usage: see `Result Rows`_. \ No newline at end of file