From 3dd978f680076be842bfcb5c9e2cbf35b926373b Mon Sep 17 00:00:00 2001
From: admin
Date: Sat, 30 Sep 2006 19:24:45 +0000
Subject:
---
user_guide/database/fields.html | 16 +++++-----------
user_guide/database/index.html | 1 +
user_guide/database/table_data.html | 6 ++++--
user_guide/database/utilities.html | 32 ++++----------------------------
4 files changed, 14 insertions(+), 41 deletions(-)
(limited to 'user_guide/database')
diff --git a/user_guide/database/fields.html b/user_guide/database/fields.html
index 5c872eca9..260cd222f 100644
--- a/user_guide/database/fields.html
+++ b/user_guide/database/fields.html
@@ -65,17 +65,14 @@ Field Names
Field Data
-Retrieving Field Names
-Sometimes it's helpful to gather the field names for a particular table or with a paritcular query result.
-
-$this->db->field_names();
+$this->db->list_fields();
Returns an array containing the field names. This query can be called two ways:
1. You can supply the table name and call it from the $this->db-> object:
-$fields = $this->db->field_names('table_name');
+$fields = $this->db->list_fields('table_name');
foreach ($fields as $field)
{
@@ -90,7 +87,7 @@ from your query result object:
$query = $this->db->query('SELECT * FROM some_table');
-foreach ($query->field_names() as $field)
+foreach ($query->list_fields() as $field)
{
echo $field;
}
@@ -98,13 +95,10 @@ foreach ($query->field_names() as $field)
-
-
-Retrieving Field MetaData
-Sometimes it's helpful to gather the field names or other metadata, like the column type, max length, etc.
-
$this->db->field_data();
Returns an array of objects containing field information.
+Sometimes it's helpful to gather the field names or other metadata, like the column type, max length, etc.
+
Note: Not all databases provide meta-data.
diff --git a/user_guide/database/index.html b/user_guide/database/index.html
index 78f90478f..3af6edee8 100644
--- a/user_guide/database/index.html
+++ b/user_guide/database/index.html
@@ -76,6 +76,7 @@ structures and Active Record patterns. The database functions offer clear, simpl
Query Helper Functions
Active Record Class
Transactions
+ Table MetaData
Field MetaData
Custom Function Calls
Database Utilities Class
diff --git a/user_guide/database/table_data.html b/user_guide/database/table_data.html
index f3df176ed..299e6dc3e 100644
--- a/user_guide/database/table_data.html
+++ b/user_guide/database/table_data.html
@@ -62,15 +62,17 @@ Table Data
+
+
Table Data
These functions let you fetch table information.
-
$this->db->tables();
+
$this->db->list_tables();
Returns an array containing the names of all the tables in the database you are currently connected to. Example:
-
$tables = $this->db->tables()
+$tables = $this->db->list_tables()
foreach ($tables as $table)
{
diff --git a/user_guide/database/utilities.html b/user_guide/database/utilities.html
index b064c7983..2cc3f5219 100644
--- a/user_guide/database/utilities.html
+++ b/user_guide/database/utilities.html
@@ -119,34 +119,6 @@ foreach($dbs as $db)
-$this->dbutil->list_tables();
-
-Returns an array containing the names of all the tables in the database you are currently connected to. Example:
-
-$tables = $this->dbutil->list_tables()
-
-foreach ($tables as $table)
-{
- echo $table;
-}
-
-
-
-$this->dbutil->table_exists();
-
-Sometimes it's helpful to know whether a particular table exists before running an operation on it.
-Returns a boolean TRUE/FALSE. Usage example:
-
-
-if ($this->dbutil->table_exists('table_name'))
-{
- // some code...
-}
-
-
-Note: Replace table_name with the name of the table you are looking for.
-
-
$this->dbutil->optimize_table('table_name');
Permits you to optimize a table using the table name specified in the first parameter. Returns TRUE/FALSE based on success or failure:
@@ -245,6 +217,10 @@ echo $this->dbutil->cvs_from_result($query, $config);
If you need to write the file use the File Helper.
+$this->dbutil->export()
+
+Permits you to export your database or any desired tables. Export data can be downloaded to your desktop, archived to your
+server, or simply displayed. Archived files can be compressed.
--
cgit v1.2.3-24-g4f1b