summaryrefslogtreecommitdiffstats
path: root/user_guide/database
diff options
context:
space:
mode:
authorPhil Sturgeon <email@philsturgeon.co.uk>2011-10-04 18:24:10 +0200
committerPhil Sturgeon <email@philsturgeon.co.uk>2011-10-04 18:24:10 +0200
commit12a1747148175f9cfeb01f99ede42d5039f667e5 (patch)
tree4ddbfbb8871c0ab02674da66086b20da8377e247 /user_guide/database
parent8706a5dd93d7740c30660727b99b554e00b0565b (diff)
parent3fdb613ee7c1968435edb81dcb9a59f42be6de6e (diff)
Merge pull request #282 from timw4mail/develop
PDO driver for Database class.
Diffstat (limited to 'user_guide/database')
-rw-r--r--user_guide/database/connecting.html2
-rw-r--r--user_guide/database/helpers.html4
2 files changed, 4 insertions, 2 deletions
diff --git a/user_guide/database/connecting.html b/user_guide/database/connecting.html
index 309f2bc1a..b18088132 100644
--- a/user_guide/database/connecting.html
+++ b/user_guide/database/connecting.html
@@ -121,6 +121,8 @@ $this->load->database(<samp>$config</samp>);</code>
<p>For information on each of these values please see the <a href="configuration.html">configuration page</a>.</p>
+<p class="important"><strong>Note:</strong> For the PDO driver, $config['hostname'] should look like this: 'mysql:host=localhost'</p>
+
<p>Or you can submit your database values as a Data Source Name. DSNs must have this prototype:</p>
<code>$dsn = 'dbdriver://username:password@hostname/database';<br />
diff --git a/user_guide/database/helpers.html b/user_guide/database/helpers.html
index 6a8aba55b..be6c339b4 100644
--- a/user_guide/database/helpers.html
+++ b/user_guide/database/helpers.html
@@ -64,11 +64,11 @@ Query Helpers
<h2>$this->db->insert_id()</h2>
<p>The insert ID number when performing database inserts.</p>
+<p class="important"><strong>Note:</strong> If using the PDO driver with PostgreSQL, this function requires a $name parameter, which specifies the appropriate sequence to check for the insert id.</p>
<h2>$this->db->affected_rows()</h2>
<p>Displays the number of affected rows, when doing "write" type queries (insert, update, etc.).</p>
-<p>Note: In MySQL "DELETE FROM TABLE" returns 0 affected rows. The database class has a small hack that allows it to return the
-correct number of affected rows. By default this hack is enabled but it can be turned off in the database driver file.</p>
+<p>Note: In MySQL "DELETE FROM TABLE" returns 0 affected rows. The database class has a small hack that allows it to return the correct number of affected rows. By default this hack is enabled but it can be turned off in the database driver file.</p>
<h2>$this->db->count_all();</h2>