?? tbl_addfield.php3
字號:
<?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");?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -