Changeset 655

Timestamp:

10/04/2007 10:54:25 PM (14 months ago)

Author:

zombor

Message:

Add list_tables() and table_exists()

Location:

trunk

Files:

• application/controllers/welcome.php (modified) (1 diff)
• system/libraries/Database.php (modified) (1 diff)
• system/libraries/drivers/Database_Mysql.php (modified) (1 diff)

trunk/application/controllers/welcome.php

@@ -81 +81 @@
                 foreach($query as $item)
                 {
-                        print_r($item);
+                        //echo '<pre>'.print_r($item, true).'</pre>';
                 }
 
-                die;
-
+                echo '<pre>'.print_r($this->db->list_tables(), true).'</pre>';
+                echo $this->db->table_exists('pages');
                 print "Numrows: ".$query->num_rows()."<br/>";
                 print "<pre>".print_r($this->database, TRUE)."</pre><br/>";

trunk/system/libraries/Database.php

@@ -693 +693 @@
                 $this->where = array();
         }
+        
+        /**
+        * Returns an array of table names
+        *
+        * @access      public
+        * @return      array
+        */
+        public function list_tables()
+        {
+                if (!$this->connected) $this->driver->connect($this->config);
+                
+                return $this->driver->list_tables();
+        }
+        
+        /**
+        * Determine if a particular table exists
+        * @access      public
+        * @return      boolean
+        */
+        public function table_exists($table_name)
+        {
+                return ( ! in_array($table_name, $this->list_tables())) ? FALSE : TRUE;
+        }
+        
 
 } // End Database Class

trunk/system/libraries/drivers/Database_Mysql.php

@@ -300 +300 @@
                 return mysql_real_escape_string($str, $this->link);
         }
+        
+        /**
+        * List table query
+        *
+        * Generates a platform-specific query string so that the table names can be fetched
+        *
+        * @access      private
+        * @return      string
+        */   
+        public function list_tables()
+        {
+                $sql = "SHOW TABLES FROM `".$this->db_config['connection']['database']."`";
+                $query = $this->query($sql);
+                $query = $query->result();
+                
+                $retval = array();
+                foreach($query as $row)
+                {
+                        $column = 'Tables_in_'.$this->db_config['connection']['database'];
+                        $retval[] = $row->$column;
+                }
+                
+                return $retval;
+        }
 
 } // End Database_Mysql Class