diff options
Diffstat (limited to 'user_guide/database')
| -rw-r--r-- | user_guide/database/fields.html | 16 | ||||
| -rw-r--r-- | user_guide/database/index.html | 1 | ||||
| -rw-r--r-- | user_guide/database/table_data.html | 6 | ||||
| -rw-r--r-- | user_guide/database/utilities.html | 32 |
4 files changed, 14 insertions, 41 deletions
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 <h1>Field Data</h1>
-<h2>Retrieving Field Names</h2>
-<p>Sometimes it's helpful to gather the field names for a particular table or with a paritcular query result.</p>
-
-<h2>$this->db->field_names();</h2>
+<h2>$this->db->list_fields();</h2>
<p>Returns an array containing the field names. This query can be called two ways:</p>
<p>1. You can supply the table name and call it from the <dfn>$this->db-></dfn> object:</p>
<code>
-$fields = $this->db->field_names('table_name');<br /><br />
+$fields = $this->db->list_fields('table_name');<br /><br />
foreach ($fields as $field)<br />
{<br />
@@ -90,7 +87,7 @@ from your query result object:</p> $query = $this->db->query('SELECT * FROM some_table');
<br /><br />
-foreach ($query->field_names() as $field)<br />
+foreach ($query->list_fields() as $field)<br />
{<br />
echo $field;<br />
}
@@ -98,13 +95,10 @@ foreach ($query->field_names() as $field)<br /> -
-
-<h2>Retrieving Field MetaData</h2>
-<p>Sometimes it's helpful to gather the field names or other metadata, like the column type, max length, etc.</p>
-
<h2>$this->db->field_data();</h2>
<p>Returns an array of objects containing field information.</p>
+<p>Sometimes it's helpful to gather the field names or other metadata, like the column type, max length, etc.</p>
+
<p class="important">Note: Not all databases provide meta-data.</p>
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 <li><a href="helpers.html">Query Helper Functions</a></li>
<li><a href="active_record.html">Active Record Class</a></li>
<li><a href="transactions.html">Transactions</a></li>
+ <li><a href="table_data.html">Table MetaData</a></li>
<li><a href="fields.html">Field MetaData</a></li>
<li><a href="call_function.html">Custom Function Calls</a></li>
<li><a href="utilities.html">Database Utilities Class</a></li>
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 <!-- START CONTENT -->
<div id="content">
+
+
<h1>Table Data</h1>
<p>These functions let you fetch table information.</p>
-<h2>$this->db->tables();</h2>
+<h2>$this->db->list_tables();</h2>
<p>Returns an array containing the names of all the tables in the database you are currently connected to. Example:</p>
-<code>$tables = $this->db->tables()<br />
+<code>$tables = $this->db->list_tables()<br />
<br />
foreach ($tables as $table)<br />
{<br />
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)<br /> -<h2>$this->dbutil->list_tables();</h2>
-
-<p>Returns an array containing the names of all the tables in the database you are currently connected to. Example:</p>
-
-<code>$tables = $this->dbutil->list_tables()<br />
-<br />
-foreach ($tables as $table)<br />
-{<br />
- echo $table;<br />
-}
-</code>
-
-
-<h2>$this->dbutil->table_exists();</h2>
-
-<p>Sometimes it's helpful to know whether a particular table exists before running an operation on it.
-Returns a boolean TRUE/FALSE. Usage example:</p>
-
-<code>
-if ($this->dbutil->table_exists('table_name'))<br />
-{<br />
- // some code...<br />
-}
-</code>
-
-<p>Note: Replace <em>table_name</em> with the name of the table you are looking for.</p>
-
-
<h2>$this->dbutil->optimize_table('table_name');</h2>
<p>Permits you to optimize a table using the table name specified in the first parameter. Returns TRUE/FALSE based on success or failure:</p>
@@ -245,6 +217,10 @@ echo $this->dbutil->cvs_from_result($query, $config); If you need to write the file use the <a href="../helpers/file_helper.html">File Helper</a>.</p>
+<h2>$this->dbutil->export()</h2>
+
+<p>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.
|