Файл: Na_proverku/PhpMyAdmin/addtable.php
Строк: 1110
<?php
/*
* wap phpmyadmin
* ionutvmi
* pimp-wap.net
*/
include('config.php');
include('head.php');
$vmi=$_GET['vmi'];
echo "<div class='links'><b>".$lang["ADD_TABLE"]."</b><p align='left'><a href='tables.php?k=$k'>".$lang["tables"]."</a>><a href='?k=$k'>".strtolower($lang["ADD_TABLE"])."</a><br/>- - -<br/>";
if (!$vmi) {
echo "
<form action='?k=$k&vmi=ionutvmi' method='post' align='left'>
".$lang["table_name"].":<input name='tn' value='table'><br/>
".$lang["colunm_name"].": <input name='tc' value='id'><br/> ".$lang["type"].": ";
print ' <select name="ct">
<option value="VARCHAR">VARCHAR</option>
<option value="TINYINT">TINYINT</option>
<option value="TEXT">TEXT</option>
<option value="DATE">DATE</option>
<option value="SMALLINT">SMALLINT</option>
<option value="MEDIUMINT">MEDIUMINT</option>
<option value="INT" SELECTED>INT</option>
<option value="BIGINT">BIGINT</option>
<option value="FLOAT">FLOAT</option>
<option value="DOUBLE">DOUBLE</option>
<option value="DECIMAL">DECIMAL</option>
<option value="DATETIME">DATETIME</option>
<option value="TIMESTAMP">TIMESTAMP</option>
<option value="TIME">TIME</option>
<option value="YEAR">YEAR</option>
<option value="CHAR">CHAR</option>
<option value="TINYBLOB">TINYBLOB</option>
<option value="TINYTEXT">TINYTEXT</option>
<option value="BLOB">BLOB</option>
<option value="MEDIUMBLOB">MEDIUMBLOB</option>
<option value="MEDIUMTEXT">MEDIUMTEXT</option>
<option value="LONGBLOB">LONGBLOB</option>
<option value="LONGTEXT">LONGTEXT</option>
<option value="ENUM">ENUM</option>
<option value="SET">SET</option>
<option value="BOOL">BOOL</option>
<option value="BINARY">BINARY</option>
<option value="VARBINARY">VARBINARY</option>';
print "</select><br/>
".$lang["Length"].": <input name='lg'><br/>";
print $lang["Collation"].':<select name="co"> <option value=""> </option>
<optgroup label="armscii8" title="ARMSCII-8 Armenian">
<option value="armscii8_bin" title="Armenian, Binary">armscii8_bin</option>
<option value="armscii8_general_ci" title="Armenian, case-insensitive">armscii8_general_ci</option>
</optgroup>
<optgroup label="ascii" title="US ASCII">
<option value="ascii_bin" title="West European (multilingual), Binary">ascii_bin</option>
<option value="ascii_general_ci" title="West European (multilingual), case-insensitive">ascii_general_ci</option>
</optgroup>
<optgroup label="big5" title="Big5 Traditional Chinese">
<option value="big5_bin" title="Traditional Chinese, Binary">big5_bin</option>
<option value="big5_chinese_ci" title="Traditional Chinese, case-insensitive">big5_chinese_ci</option>
</optgroup>
<optgroup label="binary" title="Binary pseudo charset">
<option value="binary" title="Binary">binary</option>
</optgroup>
<optgroup label="cp1250" title="Windows Central European">
<option value="cp1250_bin" title="Central European (multilingual), Binary">cp1250_bin</option>
<option value="cp1250_croatian_ci" title="Croatian, case-insensitive">cp1250_croatian_ci</option>
<option value="cp1250_czech_cs" title="Czech, case-sensitive">cp1250_czech_cs</option>
<option value="cp1250_general_ci" title="Central European (multilingual), case-insensitive">cp1250_general_ci</option>
<option value="cp1250_polish_ci" title="Polish, case-insensitive">cp1250_polish_ci</option>
</optgroup>
<optgroup label="cp1251" title="Windows Cyrillic">
<option value="cp1251_bin" title="Cyrillic (multilingual), Binary">cp1251_bin</option>
<option value="cp1251_bulgarian_ci" title="Bulgarian, case-insensitive">cp1251_bulgarian_ci</option>
<option value="cp1251_general_ci" title="Cyrillic (multilingual), case-insensitive">cp1251_general_ci</option>
<option value="cp1251_general_cs" title="Cyrillic (multilingual), case-sensitive">cp1251_general_cs</option>
<option value="cp1251_ukrainian_ci" title="Ukrainian, case-insensitive">cp1251_ukrainian_ci</option>
</optgroup>
<optgroup label="cp1256" title="Windows Arabic">
<option value="cp1256_bin" title="Arabic, Binary">cp1256_bin</option>
<option value="cp1256_general_ci" title="Arabic, case-insensitive">cp1256_general_ci</option>
</optgroup>
<optgroup label="cp1257" title="Windows Baltic">
<option value="cp1257_bin" title="Baltic (multilingual), Binary">cp1257_bin</option>
<option value="cp1257_general_ci" title="Baltic (multilingual), case-insensitive">cp1257_general_ci</option>
<option value="cp1257_lithuanian_ci" title="Lithuanian, case-insensitive">cp1257_lithuanian_ci</option>
</optgroup>
<optgroup label="cp850" title="DOS West European">
<option value="cp850_bin" title="West European (multilingual), Binary">cp850_bin</option>
<option value="cp850_general_ci" title="West European (multilingual), case-insensitive">cp850_general_ci</option>
</optgroup>
<optgroup label="cp852" title="DOS Central European">
<option value="cp852_bin" title="Central European (multilingual), Binary">cp852_bin</option>
<option value="cp852_general_ci" title="Central European (multilingual), case-insensitive">cp852_general_ci</option>
</optgroup>
<optgroup label="cp866" title="DOS Russian">
<option value="cp866_bin" title="Russian, Binary">cp866_bin</option>
<option value="cp866_general_ci" title="Russian, case-insensitive">cp866_general_ci</option>
</optgroup>
<optgroup label="cp932" title="SJIS for Windows Japanese">
<option value="cp932_bin" title="Japanese, Binary">cp932_bin</option>
<option value="cp932_japanese_ci" title="Japanese, case-insensitive">cp932_japanese_ci</option>
</optgroup>
<optgroup label="dec8" title="DEC West European">
<option value="dec8_bin" title="West European (multilingual), Binary">dec8_bin</option>
<option value="dec8_swedish_ci" title="Swedish, case-insensitive">dec8_swedish_ci</option>
</optgroup>
<optgroup label="eucjpms" title="UJIS for Windows Japanese">
<option value="eucjpms_bin" title="Japanese, Binary">eucjpms_bin</option>
<option value="eucjpms_japanese_ci" title="Japanese, case-insensitive">eucjpms_japanese_ci</option>
</optgroup>
<optgroup label="euckr" title="EUC-KR Korean">
<option value="euckr_bin" title="Korean, Binary">euckr_bin</option>
<option value="euckr_korean_ci" title="Korean, case-insensitive">euckr_korean_ci</option>
</optgroup>
<optgroup label="gb2312" title="GB2312 Simplified Chinese">
<option value="gb2312_bin" title="Simplified Chinese, Binary">gb2312_bin</option>
<option value="gb2312_chinese_ci" title="Simplified Chinese, case-insensitive">gb2312_chinese_ci</option>
</optgroup>
<optgroup label="gbk" title="GBK Simplified Chinese">
<option value="gbk_bin" title="Simplified Chinese, Binary">gbk_bin</option>
<option value="gbk_chinese_ci" title="Simplified Chinese, case-insensitive">gbk_chinese_ci</option>
</optgroup>
<optgroup label="geostd8" title="GEOSTD8 Georgian">
<option value="geostd8_bin" title="Georgian, Binary">geostd8_bin</option>
<option value="geostd8_general_ci" title="Georgian, case-insensitive">geostd8_general_ci</option>
</optgroup>
<optgroup label="greek" title="ISO 8859-7 Greek">
<option value="greek_bin" title="Greek, Binary">greek_bin</option>
<option value="greek_general_ci" title="Greek, case-insensitive">greek_general_ci</option>
</optgroup>
<optgroup label="hebrew" title="ISO 8859-8 Hebrew">
<option value="hebrew_bin" title="Hebrew, Binary">hebrew_bin</option>
<option value="hebrew_general_ci" title="Hebrew, case-insensitive">hebrew_general_ci</option>
</optgroup>
<optgroup label="hp8" title="HP West European">
<option value="hp8_bin" title="West European (multilingual), Binary">hp8_bin</option>
<option value="hp8_english_ci" title="English, case-insensitive">hp8_english_ci</option>
</optgroup>
<optgroup label="keybcs2" title="DOS Kamenicky Czech-Slovak">
<option value="keybcs2_bin" title="Czech-Slovak, Binary">keybcs2_bin</option>
<option value="keybcs2_general_ci" title="Czech-Slovak, case-insensitive">keybcs2_general_ci</option>
</optgroup>
<optgroup label="koi8r" title="KOI8-R Relcom Russian">
<option value="koi8r_bin" title="Russian, Binary">koi8r_bin</option>
<option value="koi8r_general_ci" title="Russian, case-insensitive">koi8r_general_ci</option>
</optgroup>
<optgroup label="koi8u" title="KOI8-U Ukrainian">
<option value="koi8u_bin" title="Ukrainian, Binary">koi8u_bin</option>
<option value="koi8u_general_ci" title="Ukrainian, case-insensitive">koi8u_general_ci</option>
</optgroup>
<optgroup label="latin1" title="cp1252 West European">
<option value="latin1_bin" title="West European (multilingual), Binary">latin1_bin</option>
<option value="latin1_danish_ci" title="Danish, case-insensitive">latin1_danish_ci</option>
<option value="latin1_general_ci" title="West European (multilingual), case-insensitive">latin1_general_ci</option>
<option value="latin1_general_cs" title="West European (multilingual), case-sensitive">latin1_general_cs</option>
<option value="latin1_german1_ci" title="German (dictionary), case-insensitive">latin1_german1_ci</option>
<option value="latin1_german2_ci" title="German (phone book), case-insensitive">latin1_german2_ci</option>
<option value="latin1_spanish_ci" title="Spanish, case-insensitive">latin1_spanish_ci</option>
<option value="latin1_swedish_ci" title="Swedish, case-insensitive">latin1_swedish_ci</option>
</optgroup>
<optgroup label="latin2" title="ISO 8859-2 Central European">
<option value="latin2_bin" title="Central European (multilingual), Binary">latin2_bin</option>
<option value="latin2_croatian_ci" title="Croatian, case-insensitive">latin2_croatian_ci</option>
<option value="latin2_czech_cs" title="Czech, case-sensitive">latin2_czech_cs</option>
<option value="latin2_general_ci" title="Central European (multilingual), case-insensitive">latin2_general_ci</option>
<option value="latin2_hungarian_ci" title="Hungarian, case-insensitive">latin2_hungarian_ci</option>
</optgroup>
<optgroup label="latin5" title="ISO 8859-9 Turkish">
<option value="latin5_bin" title="Turkish, Binary">latin5_bin</option>
<option value="latin5_turkish_ci" title="Turkish, case-insensitive">latin5_turkish_ci</option>
</optgroup>
<optgroup label="latin7" title="ISO 8859-13 Baltic">
<option value="latin7_bin" title="Baltic (multilingual), Binary">latin7_bin</option>
<option value="latin7_estonian_cs" title="Estonian, case-sensitive">latin7_estonian_cs</option>
<option value="latin7_general_ci" title="Baltic (multilingual), case-insensitive">latin7_general_ci</option>
<option value="latin7_general_cs" title="Baltic (multilingual), case-sensitive">latin7_general_cs</option>
</optgroup>
<optgroup label="macce" title="Mac Central European">
<option value="macce_bin" title="Central European (multilingual), Binary">macce_bin</option>
<option value="macce_general_ci" title="Central European (multilingual), case-insensitive">macce_general_ci</option>
</optgroup>
<optgroup label="macroman" title="Mac West European">
<option value="macroman_bin" title="West European (multilingual), Binary">macroman_bin</option>
<option value="macroman_general_ci" title="West European (multilingual), case-insensitive">macroman_general_ci</option>
</optgroup>
<optgroup label="sjis" title="Shift-JIS Japanese">
<option value="sjis_bin" title="Japanese, Binary">sjis_bin</option>
<option value="sjis_japanese_ci" title="Japanese, case-insensitive">sjis_japanese_ci</option>
</optgroup>
<optgroup label="swe7" title="7bit Swedish">
<option value="swe7_bin" title="Swedish, Binary">swe7_bin</option>
<option value="swe7_swedish_ci" title="Swedish, case-insensitive">swe7_swedish_ci</option>
</optgroup>
<optgroup label="tis620" title="TIS620 Thai">
<option value="tis620_bin" title="Thai, Binary">tis620_bin</option>
<option value="tis620_thai_ci" title="Thai, case-insensitive">tis620_thai_ci</option>
</optgroup>
<optgroup label="ucs2" title="UCS-2 Unicode">
<option value="ucs2_bin" title="Unicode (multilingual), Binary">ucs2_bin</option>
<option value="ucs2_czech_ci" title="Czech, case-insensitive">ucs2_czech_ci</option>
<option value="ucs2_danish_ci" title="Danish, case-insensitive">ucs2_danish_ci</option>
<option value="ucs2_esperanto_ci" title="Esperanto, case-insensitive">ucs2_esperanto_ci</option>
<option value="ucs2_estonian_ci" title="Estonian, case-insensitive">ucs2_estonian_ci</option>
<option value="ucs2_general_ci" title="Unicode (multilingual), case-insensitive">ucs2_general_ci</option>
<option value="ucs2_hungarian_ci" title="Hungarian, case-insensitive">ucs2_hungarian_ci</option>
<option value="ucs2_icelandic_ci" title="Icelandic, case-insensitive">ucs2_icelandic_ci</option>
<option value="ucs2_latvian_ci" title="Latvian, case-insensitive">ucs2_latvian_ci</option>
<option value="ucs2_lithuanian_ci" title="Lithuanian, case-insensitive">ucs2_lithuanian_ci</option>
<option value="ucs2_persian_ci" title="Persian, case-insensitive">ucs2_persian_ci</option>
<option value="ucs2_polish_ci" title="Polish, case-insensitive">ucs2_polish_ci</option>
<option value="ucs2_roman_ci" title="West European, case-insensitive">ucs2_roman_ci</option>
<option value="ucs2_romanian_ci" title="Romanian, case-insensitive">ucs2_romanian_ci</option>
<option value="ucs2_slovak_ci" title="Slovak, case-insensitive">ucs2_slovak_ci</option>
<option value="ucs2_slovenian_ci" title="Slovenian, case-insensitive">ucs2_slovenian_ci</option>
<option value="ucs2_spanish2_ci" title="Traditional Spanish, case-insensitive">ucs2_spanish2_ci</option>
<option value="ucs2_spanish_ci" title="Spanish, case-insensitive">ucs2_spanish_ci</option>
<option value="ucs2_swedish_ci" title="Swedish, case-insensitive">ucs2_swedish_ci</option>
<option value="ucs2_turkish_ci" title="Turkish, case-insensitive">ucs2_turkish_ci</option>
<option value="ucs2_unicode_ci" title="Unicode (multilingual), case-insensitive">ucs2_unicode_ci</option>
</optgroup>
<optgroup label="ujis" title="EUC-JP Japanese">
<option value="ujis_bin" title="Japanese, Binary">ujis_bin</option>
<option value="ujis_japanese_ci" title="Japanese, case-insensitive">ujis_japanese_ci</option>
</optgroup>
<optgroup label="utf8" title="UTF-8 Unicode">
<option value="utf8_bin" title="Unicode (multilingual), Binary">utf8_bin</option>
<option value="utf8_czech_ci" title="Czech, case-insensitive">utf8_czech_ci</option>
<option value="utf8_danish_ci" title="Danish, case-insensitive">utf8_danish_ci</option>
<option value="utf8_esperanto_ci" title="Esperanto, case-insensitive">utf8_esperanto_ci</option>
<option value="utf8_estonian_ci" title="Estonian, case-insensitive">utf8_estonian_ci</option>
<option value="utf8_general_ci" title="Unicode (multilingual), case-insensitive">utf8_general_ci</option>
<option value="utf8_hungarian_ci" title="Hungarian, case-insensitive">utf8_hungarian_ci</option>
<option value="utf8_icelandic_ci" title="Icelandic, case-insensitive">utf8_icelandic_ci</option>
<option value="utf8_latvian_ci" title="Latvian, case-insensitive">utf8_latvian_ci</option>
<option value="utf8_lithuanian_ci" title="Lithuanian, case-insensitive">utf8_lithuanian_ci</option>
<option value="utf8_persian_ci" title="Persian, case-insensitive">utf8_persian_ci</option>
<option value="utf8_polish_ci" title="Polish, case-insensitive">utf8_polish_ci</option>
<option value="utf8_roman_ci" title="West European, case-insensitive">utf8_roman_ci</option>
<option value="utf8_romanian_ci" title="Romanian, case-insensitive">utf8_romanian_ci</option>
<option value="utf8_slovak_ci" title="Slovak, case-insensitive">utf8_slovak_ci</option>
<option value="utf8_slovenian_ci" title="Slovenian, case-insensitive">utf8_slovenian_ci</option>
<option value="utf8_spanish2_ci" title="Traditional Spanish, case-insensitive">utf8_spanish2_ci</option>
<option value="utf8_spanish_ci" title="Spanish, case-insensitive">utf8_spanish_ci</option>
<option value="utf8_swedish_ci" title="Swedish, case-insensitive">utf8_swedish_ci</option>
<option value="utf8_turkish_ci" title="Turkish, case-insensitive">utf8_turkish_ci</option>
<option value="utf8_unicode_ci" title="Unicode (multilingual), case-insensitive">utf8_unicode_ci</option>
</optgroup>
</select><br/>'.$lang["Attributes"].': <select name="at"> <option value="" selected="selected"></option>
<option value="UNSIGNED">UNSIGNED</option>
<option value="UNSIGNED ZEROFILL">UNSIGNED ZEROFILL</option>
<option value="ON UPDATE CURRENT_TIMESTAMP">ON UPDATE CURRENT_TIMESTAMP</option>
</select><br/>NULL <select name="nu"><option value="NOT NULL" selected="selected" >not null</option>
<option value="">null</option></select><br/>'.$lang["Default"].': <input name="df"><br/>'.$lang["Extra"].': <select name="ex"><option value=""> </option>
<option value="AUTO_INCREMENT">auto_increment</option>
</select><br>'.$lang["Field_Key"].': <select name="fk">
<option value="0">---</option>
<option value="1">Primary</option>
<option value="2">Index</option>
<option value="3">Unique</option>
</select><br/>';
print "<input type='submit' value='".$lang["create"]."'></form>";
} else {
$tn=trim($_POST['tn']);
$tc=trim($_POST['tc']);
$ct=trim($_POST['ct']);
$lg=trim($_POST['lg']);
$co=trim($_POST['co']);
$at=trim($_POST['at']);
$nu=trim($_POST['nu']);
$df=trim($_POST['df']);
if($df !="") $df="DEFAULT '$df'";
$ex=trim($_POST['ex']);
$fk=trim($_POST['fk']);
if($fk==0) $fkk="";
if($fk==1) $fkk=",PRIMARY KEY(`$tc`)";
if($fk==2) $fkk=",INDEX(`$tc`)";
if($fk==3) $fkk=",UNIQUE(`$tc`)";
if($lg !="") $lg="($lg)";
$sql ="CREATE TABLE `$tn` (
`$tc` $ct $lg $co $at $nu $df $ex $fkk)";
echo "<center>".$lang["Query"].": <i>".htmlspecialchars($sql)."</i></center><p align='left'>";
$create=mysql_query("$sql");
if ($create) {
printf($lang["table_created"],$tn);
} else {
echo $lang["Error"].": ";
echo mysql_error();
}
}
echo '</div>';
include('foot.php');
?>