Changeset 2302

Timestamp:

12/16/10 07:04:29 (17 months ago)

Author:

petsagouris

Message:

[Branch 1.5] Better Database::table_exists() and Database::column_exists()

Files:

• branches/1.5/libs/Database.php (modified) (2 diffs)

branches/1.5/libs/Database.php

@@ -349 +349 @@
         public function table_exists($table_name)
         {
-                $tables = $this->get_col("SHOW TABLES", 0);
-                return (bool) in_array(DB_PREFIX.$table_name, $tables);
+                return (bool) $this->query("SHOW TABLES LIKE '".DB_PREFIX.$table_name."'");
         }
 
@@ -364 +363 @@
         public function column_exists($table_name, $column)
         {
-                $sql = "SHOW COLUMNS FROM ".DB_PREFIX.$table_name;
-                foreach ($this->get_col($sql, 0) as $column_name) {
-                        if ($column_name == $column) {
-                                return FALSE;
-                        }
-                }
-
-                return FALSE;
+                return (bool) $this->query("SHOW COLUMNS FROM `".DB_PREFIX.$table_name."` LIKE '".$column."'");
         }