summaryrefslogtreecommitdiffstats
path: root/user_guide/database
diff options
context:
space:
mode:
Diffstat (limited to 'user_guide/database')
-rw-r--r--user_guide/database/configuration.html2
-rw-r--r--user_guide/database/results.html23
2 files changed, 23 insertions, 2 deletions
diff --git a/user_guide/database/configuration.html b/user_guide/database/configuration.html
index e9db5fc87..d71cd34db 100644
--- a/user_guide/database/configuration.html
+++ b/user_guide/database/configuration.html
@@ -134,7 +134,7 @@ for the primary connection, but it too can be renamed to something more relevant
<li><strong>char_set</strong> - The character set used in communicating with the database.</li>
<li><strong>dbcollat</strong> - The character collation used in communicating with the database.</li>
<li><strong>swap_pre</strong> - A default table prefix that should be swapped with <var>dbprefix</var>. This is useful for distributed applications where you might run manually written queries, and need the prefix to still be customizable by the end user.</li>
-<li><strong>autoinit</strong> - Whether or not to automatically initialize the database.</li>
+<li><strong>autoinit</strong> - Whether or not to automatically connect to the database when the library loads. If set to false, the connection will take place prior to executing the first query.</li>
<li><strong>stricton</strong> - TRUE/FALSE (boolean) - Whether to force "Strict Mode" connections, good for ensuring strict SQL while developing an application.</li>
<li><strong>port</strong> - The database port number. To use this value you have to add a line to the database config array.<code>$db['default']['port'] = 5432;</code>
</ul>
diff --git a/user_guide/database/results.html b/user_guide/database/results.html
index 75cb190f9..e9a5cb4cf 100644
--- a/user_guide/database/results.html
+++ b/user_guide/database/results.html
@@ -98,6 +98,18 @@ Query Results
}
</code>
+ <p>You can also pass a string to result() which represents a class to instantiate for each result object (note: this class must be loaded)</p>
+
+ <code>
+ $query = $this->db->query("SELECT * FROM users;");<br />
+ <br />
+ foreach ($query->result('User') as $user)<br />
+ {<br />
+ &nbsp;&nbsp;&nbsp;echo $row->name; // call attributes<br />
+ &nbsp;&nbsp;&nbsp;echo $row->reverse_name(); // or methods defined on the 'User' class<br />
+ }
+ </code>
+
<h2>result_array()</h2>
<p>This function returns the query result as a pure array, or an empty array when no result is produced. Typically you'll use this in a foreach loop, like this:</p>
@@ -133,6 +145,15 @@ Query Results
<code>$row = $query->row(<dfn>5</dfn>);</code>
+ <p>You can also add a second String parameter, which is the name of a class to instantiate the row with:</p>
+
+ <code>
+ $query = $this->db->query("SELECT * FROM users LIMIT 1;");<br />
+ <br />
+ $query->row(0, 'User')<br />
+ echo $row->name; // call attributes<br />
+ echo $row->reverse_name(); // or methods defined on the 'User' class<br />
+ </code>
<h2>row_array()</h2>
@@ -235,4 +256,4 @@ Next Topic:&nbsp;&nbsp;<a href="helpers.html">Query Helper Functions</a>
</div>
</body>
-</html> \ No newline at end of file
+</html>