diff options
| author | Derek Jones <derek.jones@ellislab.com> | 2011-08-20 15:59:15 +0200 |
|---|---|---|
| committer | Derek Jones <derek.jones@ellislab.com> | 2011-08-20 15:59:15 +0200 |
| commit | d9489e0ca676905c16c7a8c0f03011cc12b634f9 (patch) | |
| tree | 809872634daf234591fabacbca8df2203d35b509 /user_guide/database/queries.html | |
| parent | abccc2fa65eea5f64773952661a8ba79e559333b (diff) | |
| parent | b8c038a3e7742f32915d7f1ab69627075e8d0c39 (diff) | |
Merge branch 'release/v2.0.3'
Diffstat (limited to 'user_guide/database/queries.html')
| -rw-r--r-- | user_guide/database/queries.html | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/user_guide/database/queries.html b/user_guide/database/queries.html index f9f96803f..e7333efc2 100644 --- a/user_guide/database/queries.html +++ b/user_guide/database/queries.html @@ -28,7 +28,7 @@ <div id="masthead"> <table cellpadding="0" cellspacing="0" border="0" style="width:100%"> <tr> -<td><h1>CodeIgniter User Guide Version 2.0.2</h1></td> +<td><h1>CodeIgniter User Guide Version 2.0.3</h1></td> <td id="breadcrumb_right"><a href="../toc.html">Table of Contents Page</a></td> </tr> </table> @@ -80,11 +80,16 @@ It DOES NOT return a database result set, nor does it set the query timer, or co It simply lets you submit a query. Most users will rarely use this function.</p> -<h1>Adding Database prefixes manually</h1> -<p>If you have configured a database prefix and would like to add it in manually for, you can use the following.</p> +<h1>Working with Database prefixes manually</h1> +<p>If you have configured a database prefix and would like to prepend it to a table name for use in a native SQL query for example, then you can use the following:</p> <p><code>$this->db->dbprefix('tablename');<br /> // outputs prefix_tablename</code></p> +<p>If for any reason you would like to change the prefix programatically without needing to create a new connection, you can use this method:</p> +<p><code>$this->db->set_dbprefix('newprefix');<br /><br /> +$this->db->dbprefix('tablename');<br /> +// outputs newprefix_tablename</code></p> + <h1>Protecting identifiers</h1> <p>In many databases it is advisable to protect table and field names - for example with backticks in MySQL. <strong>Active Record queries are automatically protected</strong>, however if you need to manually protect an identifier you can use:</p> |