Example #1
0
 public function import_from_mysql($table)
 {
     if (!Table::has_id($table)) {
         return -7;
     }
     if (!$this->mysql_delete_Table()) {
         return json_encode(array("result" => -6, "message" => mysql_error()));
     }
     $sql = sprintf("CREATE TABLE `%s` LIKE `%s`", $this->name, $table);
     if (!mysql_query($sql)) {
         return json_encode(array("result" => -6, "message" => mysql_error()));
     }
     $sql = sprintf("INSERT INTO `%s` SELECT * FROM `%s`", $this->name, $table);
     if (!mysql_query($sql)) {
         return json_encode(array("result" => -6, "message" => mysql_error()));
     }
     $this->rename_restricted_columns();
     return 0;
 }