summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--system/database/DB_export.php38
-rw-r--r--system/database/DB_utility.php2
-rw-r--r--user_guide/database/helpers.html9
3 files changed, 45 insertions, 4 deletions
diff --git a/system/database/DB_export.php b/system/database/DB_export.php
index 195510d9d..1e94c6c97 100644
--- a/system/database/DB_export.php
+++ b/system/database/DB_export.php
@@ -23,19 +23,51 @@
* @link http://www.codeigniter.com/user_guide/database/
*/
class CI_DB_export {
-
+
+
+ function CI_DB_export()
+ {
+ log_message('debug', "Database Export Class Initialized");
+ }
+
/**
- * Some function
+ * Generate CVS
*
* @access public
* @return integer
*/
- function something()
+ function generate_cvs($query, $delim = "\t", $newline = "\n")
{
+ if ( ! is_object($query) OR ! method_exists($query, 'field_names'))
+ {
+ show_error('You must submit a valid result object');
+ }
+
+ $out = '';
+ foreach ($query->field_names() as $name)
+ {
+ $out .= $name.$delim;
+ }
+
+ $out .= $newline;
+
+ foreach ($query->result_array() as $row)
+ {
+ foreach ($row as $item)
+ {
+ $out .= $item.$delim;
+ }
+
+ $out .= $newline;
+ }
+
+
+ return $out;
}
// --------------------------------------------------------------------
+
}
?> \ No newline at end of file
diff --git a/system/database/DB_utility.php b/system/database/DB_utility.php
index f98448adf..41941ae35 100644
--- a/system/database/DB_utility.php
+++ b/system/database/DB_utility.php
@@ -31,6 +31,8 @@ class CI_DB_utility {
// Assign the main database object to $this->db
$obj =& get_instance();
$this->db =& $obj->db;
+
+ log_message('debug', "Database Utility Class Initialized");
}
// --------------------------------------------------------------------
diff --git a/user_guide/database/helpers.html b/user_guide/database/helpers.html
index 1d1fb37ad..8302fe6ee 100644
--- a/user_guide/database/helpers.html
+++ b/user_guide/database/helpers.html
@@ -76,6 +76,14 @@ Query Helpers
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>
+<p>Permits you to determine the number of rows in a particular table. Submit the table name in the first parameter. Example:</p>
+<code>echo $this->db->count_all('<var>my_table</var>');<br />
+<br />
+// Produces an integer, like 25
+</code>
+
+
<h2>$this->db->platform()</h2>
<p>Outputs the database platform you are running (MySQL, MS SQL, Postgre, etc...):</p>
<code>echo $this->db->platform();</code>
@@ -86,7 +94,6 @@ correct number of affected rows. By default this hack is enabled but it can be
<code>echo $this->db->version();</code>
-
<h2>$this->db->last_query();</h2>
<p>Returns the last query that was run (the query string, not the result). Example:</p>