summaryrefslogtreecommitdiffstats
path: root/user_guide
diff options
context:
space:
mode:
authorDerek Allard <derek.allard@ellislab.com>2010-02-04 17:47:01 +0100
committerDerek Allard <derek.allard@ellislab.com>2010-02-04 17:47:01 +0100
commite7f0325af984392aa4c509dc5a5ca409f5e9474a (patch)
tree1fbd61e82de91af494242b33fb812f870da86c4a /user_guide
parent5192e5c8e94f956784063812da6378adb3cb1b7c (diff)
database exists function in dbutil
Diffstat (limited to 'user_guide')
-rw-r--r--user_guide/changelog.html1
-rw-r--r--user_guide/database/utilities.html19
2 files changed, 20 insertions, 0 deletions
diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index fc35cdf7f..88d8a1621 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -74,6 +74,7 @@ SVN Revision: </p>
</li>
<li>Database
<ul>
+ <li>Added <kbd>database_exists()</kbd> to the <a href="database/utilities.html">Database Utilities Class</a>.</li>
<li>Semantic change to db->version() function to allow a list of exceptions for databases with functions to return version string instead of specially formed SQL queries. Currently this list only includes Oracle and SQLite.</li>
<li>Fixed a bug where driver specific table identifier protection could lead to malformed queries in the <kbd>field_data()</kbd> functions.</li>
<li>Fixed a bug where an undefined class variable was referenced in database drivers.</li>
diff --git a/user_guide/database/utilities.html b/user_guide/database/utilities.html
index a26e0f35b..f46db6820 100644
--- a/user_guide/database/utilities.html
+++ b/user_guide/database/utilities.html
@@ -66,6 +66,7 @@ Database Utility Class
<ul>
<li><a href="#init">Initializing the Utility Class</a></li>
<li><a href="#list">Listing your Databases</a></li>
+<li><a href="#exists">Checking for a specific Database</a></li>
<li><a href="#opttb">Optimizing your Tables</a></li>
<li><a href="#repair">Repairing your Databases</a></li>
<li><a href="#optdb">Optimizing your Database</a></li>
@@ -99,6 +100,24 @@ foreach($dbs as $db)<br />
{<br />
&nbsp;&nbsp;&nbsp; echo $db;<br />
}</code>
+
+
+<h2><a name="exists"></a>$this->db->database_exists();</h2>
+
+<p>Sometimes it's helpful to know whether a particular database exists.
+Returns a boolean TRUE/FALSE. Usage example:</p>
+
+<code>
+if ($this->db->database_exists('database_name'))<br />
+{<br />
+&nbsp;&nbsp; // some code...<br />
+}
+</code>
+
+<p>Note: Replace <em>database_name</em> with the name of the table you are looking for.</p>
+
+
+
<h2><a name="opttb"></a>$this->dbutil->optimize_table('table_name');</h2>
<p class="important"><strong>Note:</strong>&nbsp; This features is only available for MySQL/MySQLi databases.</p>