From b2ab51b432e4de4aeb551ca17cba323ad729f406 Mon Sep 17 00:00:00 2001 From: admin Date: Sun, 24 Sep 2006 18:03:40 +0000 Subject: Deleting database folder --- user_guide/libraries/database/results.html | 224 ----------------------------- 1 file changed, 224 deletions(-) delete mode 100644 user_guide/libraries/database/results.html (limited to 'user_guide/libraries/database/results.html') diff --git a/user_guide/libraries/database/results.html b/user_guide/libraries/database/results.html deleted file mode 100644 index b1952db5a..000000000 --- a/user_guide/libraries/database/results.html +++ /dev/null @@ -1,224 +0,0 @@ - - - - -Code Igniter User Guide - - - - - - - - - - - - - - - - - - - - - - -
- - - - - -

Code Igniter User Guide Version 1.4.1

-
- - - - - - - - - -
- - - -
- - - -
- - - -

Generating Query Results

- - -

There are several ways to generate query results:

- -

result()

- -

This function returns the query result as an array of objects, or FALSE on failure. - - Typically you'll use this in a foreach loop, like this:

- - - $query = $this->db->query("YOUR QUERY");
-
- foreach ($query->result() as $row)
- {
-    echo $row->title;
-    echo $row->name;
-    echo $row->body;
- }
- -

If you run queries that might not produce a result, you are encouraged to test the result first:

- - - $query = $this->db->query("YOUR QUERY");
-
- if ($query->num_rows() > 0)
- {
-    foreach ($query->result() as $row)
-    {
-       echo $row->title;
-       echo $row->name;
-       echo $row->body;
-    }
- } -
- -

result_array()

- -

This function returns the query result as a pure array, or FALSE on failure. Typically you'll use this in a foreach loop, like this:

- - $query = $this->db->query("YOUR QUERY");
-
- foreach ($query->result_array() as $row)
- {
-    echo $row['title'];
-    echo $row['name'];
-    echo $row['body'];
- }
- -

result('array')

- -

Identical to $this->db->result_array().

- - -

row()

- -

This function returns a single result row. If your query has more than one row, it returns only the first row. - The result is returned as an object. Here's a usage example:

- - $query = $this->db->query("YOUR QUERY");
-
- if ($query->num_rows() > 0)
- {
-    $row = $query->row(); -

-    echo $row->title;
-    echo $row->name;
-    echo $row->body;
- } -
- -

If you want a specific row returned you can submit the row number as a digit in the first parameter: - - $row = $query->row(5); - - -

row_array()

- -

Identical to the above row() function, except it returns an array. Example:

- - - $query = $this->db->query("YOUR QUERY");
-
- if ($query->num_rows() > 0)
- {
-    $row = $query->row_array(); -

-    echo $row['title'];
-    echo $row['name'];
-    echo $row['body'];
- } -
- - -

If you want a specific row returned you can submit the row number as a digit in the first parameter: - - $row = $query->row_array(5); - - -

In addition, you can walk forward/backwards/first/last through your results using these variations:

- -

- $row = $query->first_row()
- $row = $query->last_row()
- $row = $query->next_row()
- $row = $query->previous_row() -

- -

By default they return an object unless you put the word "array" in the parameter:

- -

- $row = $query->first_row('array')
- $row = $query->last_row('array')
- $row = $query->next_row('array')
- $row = $query->previous_row('array') -

- - - -


Result Helper Functions

- - -

$query->num_rows()

-

The number of rows returned by the query. Note: In this example, $query is the variable that the query result object is assigned to:

- -$query = $this->db->query('SELECT * FROM my_table');

-echo $query->num_rows(); -
- -

$query->num_fields()

-

The number of FIELDS (columns) returned by the query. Make sure to call the function using your query result object:

- -$query = $this->db->query('SELECT * FROM my_table');

-echo $query->num_fields(); -
- - - - - -
- - - - - - - \ No newline at end of file -- cgit v1.2.3-24-g4f1b