CLASS_MYSQLI::copy_table PHP Method

    function copy_table($table, $table_src, $data, $primary, $comment = "", $engine = "MyISAM")
    {
        $sql = "CREATE TABLE IF NOT EXISTS `" . $table . "` (";
        $values = array();
        foreach ($data as $key => $value) {
            $values[] = "`" . $key . "` " . $value;
        }
        $sql .= implode(",", $values);
        $sql .= ", PRIMARY KEY (`" . $primary . "`)) ENGINE=" . $engine . " DEFAULT CHARSET=" . $this->db_charset . " COMMENT='" . $comment . "' ";
        $sql .= " SELECT ";
        $values = array();
        foreach ($data as $key => $value) {
            $values[] = "`" . $key . "`";
        }
        $sql .= implode(",", $values);
        $sql .= " FROM `" . $table_src . "` WHERE 1=1";
        $this->db_rs = $this->query($sql);
        return $this->db_rs;
    }