CLASS_MYSQLI::alert_table PHP Method

    function alert_table($table, $data = false, $rename = false)
    {
        $sql = "ALTER TABLE `" . $table . "` ";
        if ($rename) {
            $sql .= " RENAME TO `" . $rename . "`";
        }
        if ($data) {
            $values = array();
            foreach ($data as $key => $value) {
                switch ($value[0]) {
                    case "ADD":
                        $values[] = $value[0] . " COLUMN `" . $key . "` " . $value[1];
                        break;
                    case "DROP":
                        $values[] = $value[0] . " COLUMN `" . $key . "`";
                        break;
                    case "DROP PRIMARY KEY":
                        $values[] = $value[0];
                        break;
                    case "ADD PRIMARY KEY":
                        $values[] = $value[0] . " (`" . $value[1] . "`)";
                        break;
                    case "CHANGE":
                        $values[] = $value[0] . " COLUMN `" . $key . "` `" . $value[2] . "` " . $value[1];
                        break;
                }
            }
            $sql .= implode(",", $values);
        }
        $this->db_rs = $this->query($sql);
        return $this->db_rs;
    }