tbl_addfield.php3

Mysql数据库的web管理工具

<?php
/* $Id: tbl_addfield.php3,v 1.11 2000/07/09 09:05:35 tobias Exp $ */

require("header.inc.php3");

if(isset($submit))
{
    $query = '';
    for($i=0; $i<count($field_name); $i++)
    {
        $query .= "$field_name[$i] $field_type[$i] ";
        if($field_length[$i] != "")
            $query .= "(".stripslashes($field_length[$i]).") ";

        if($field_attribute[$i] != "")
            $query .= "$field_attribute[$i] " ;
        if($field_default[$i] != "")
            $query .= "DEFAULT '".stripslashes($field_default[$i])."' ";

        $query .= "$field_null[$i] $field_extra[$i]";

        if($after_field != "--end--")
            if ($i == 0)
                if ($after_field == "--first--")
                    $query .= " FIRST ";
                else
                    $query .= " AFTER ".stripslashes($after_field)." ";
            else
                $query .= " AFTER ".stripslashes($field_name[$i-1])." ";

        $query .= ", ADD ";

    }

    $query = stripslashes(ereg_replace(", ADD $", "", $query));

    $sql_query = "ALTER TABLE $table ADD $query";
    $result = mysql_db_query($db, "ALTER TABLE $table ADD $query");

    $primary = '';
    for($i=0;$i<count($field_primary);$i++)
    {
        $j = $field_primary[$i];
        $primary .= "$field_name[$j], ";
    }
    $primary = ereg_replace(", $", "", $primary);
    if(count($field_primary) > 0)
    {
        $primary = "ADD PRIMARY KEY ($primary)";
        $sql_query .= "\nALTER TABLE $table $primary";
        $result = mysql_db_query($db, "ALTER TABLE $table $primary") or mysql_die();
    }

    $index = '';
    for($i=0;$i<count($field_index);$i++)
    {
        $j = $field_index[$i];
        $index .= "$field_name[$j], ";
    }
    $index = ereg_replace(", $", "", $index);
    if(count($field_index) > 0)
    {
        $index = "ADD INDEX ($index)";
        $sql_query .= "\nALTER TABLE $table $index";
        $result = mysql_db_query($db, "ALTER TABLE $table $index") or mysql_die();
    }
    $unique = '';
    for($i=0;$i<count($field_unique);$i++)
    {
        $j = $field_unique[$i];
        $unique .= "$field_name[$j], ";
    }
    $unique = ereg_replace(", $", "", $unique);
    if(count($field_unique) > 0)
    {
        $unique = "ADD UNIQUE ($unique)";
        $sql_query .= "\nALTER TABLE $table $unique";
        $result = mysql_db_query($db, "ALTER TABLE $table $unique") or mysql_die();
    }
    $query_keys = $primary.$index.$unique;
    $query_keys = ereg_replace(", $", "", $query_keys);

    $message = "$strTable $table $strHasBeenAltered";
    include("tbl_properties.php3");
    exit;
}
else
{
    $action = "tbl_addfield.php3";
    include("tbl_properties.inc.php3");
}

require ("footer.inc.php3");
?>