summaryrefslogtreecommitdiffstats
path: root/user_guide
diff options
context:
space:
mode:
authoradmin <devnull@localhost>2006-09-30 21:24:45 +0200
committeradmin <devnull@localhost>2006-09-30 21:24:45 +0200
commit3dd978f680076be842bfcb5c9e2cbf35b926373b (patch)
treee4cd05724744ee70eb497118692581e750539548 /user_guide
parent3ed8c51254a5b26d951fa675802fcf69adf9638e (diff)
Diffstat (limited to 'user_guide')
-rw-r--r--user_guide/database/fields.html16
-rw-r--r--user_guide/database/index.html1
-rw-r--r--user_guide/database/table_data.html6
-rw-r--r--user_guide/database/utilities.html32
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 />
&nbsp;&nbsp;&nbsp;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 />
-&nbsp;&nbsp;&nbsp; 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 />
-&nbsp;&nbsp;&nbsp; // 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.