예제 #1
0
 public function create_table($maxtableid)
 {
     if ($maxtableid) {
         XDB::query('SET SQL_QUOTE_SHOW_CREATE=0', 'SILENT');
         $db =& XDB::object();
         $query = XDB::query("SHOW CREATE TABLE %t", array($this->get_table_name()));
         $create = $db->fetch_row($query);
         $createsql = $create[1];
         $createsql = str_replace(XDB::table($this->get_table_name()), XDB::table($this->get_table_name($maxtableid)), $createsql);
         XDB::query($createsql);
         return true;
     } else {
         return false;
     }
 }
예제 #2
0
 public function show_table_columns($table)
 {
     $data = array();
     $db =& XDB::object();
     if ($db->version() > '4.1') {
         $query = $db->query("SHOW FULL COLUMNS FROM " . XDB::table($table), 'SILENT');
     } else {
         $query = $db->query("SHOW COLUMNS FROM " . XDB::table($table), 'SILENT');
     }
     while ($field = @XDB::fetch($query)) {
         $data[$field['Field']] = $field;
     }
     return $data;
 }