home *** CD-ROM | disk | FTP | other *** search
- <?php
- /* $Id: tbl_addfield.php,v 1.11 2000/07/09 09:05:35 tobias Exp $ */
-
- require("header.inc.php");
-
- 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.php");
- exit;
- }
- else
- {
- $action = "tbl_addfield.php";
- include("tbl_properties.inc.php");
- }
-
- require ("footer.inc.php");
- ?>
-