home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC World 2001 August
/
PCWorld_2001-08_cd.bin
/
Komunikace
/
phptriad
/
phptriadsetup2-11.exe
/
htdocs
/
phpMyAdmin
/
tbl_properties.inc.php
< prev
next >
Wrap
Text File
|
2000-08-20
|
6KB
|
198 lines
<!-- $Id: tbl_properties.inc.php,v 1.24 2000/07/13 14:04:38 tobias Exp $ */ -->
<form method="post" action="<?php echo $action;?>">
<input type="hidden" name="server" value="<?php echo $server;?>">
<input type="hidden" name="db" value="<?php echo $db;?>">
<input type="hidden" name="table" value="<?php echo $table;?>">
<?php
if($action == "tbl_create.php")
{
?>
<input type="hidden" name="reload" value="true">
<?php
}
elseif($action == "tbl_addfield.php")
{
echo '<input type="hidden" name="after_field" value="'.$after_field."\">\n";
}
?>
<table border=<?php echo $cfgBorder;?>>
<tr>
<th><?php echo $strField; ?></th>
<th><?php echo $strType; ?></th>
<th><?php echo $strLengthSet; ?></th>
<th><?php echo $strAttr; ?></th>
<th><?php echo $strNull; ?></th>
<th><?php echo $strDefault; ?></th>
<th><?php echo $strExtra; ?></th>
<?php
if($action == "tbl_create.php" || $action == "tbl_addfield.php")
{
?>
<th><?php echo $strPrimary; ?></th>
<th><?php echo $strIndex; ?></th>
<th><?php echo $strUnique; ?></th>
<?php
}
?>
</tr>
<?php
for($i=0 ; $i<$num_fields; $i++)
{
if(isset($result))
$row = mysql_fetch_array($result);
$bgcolor = $cfgBgcolorOne;
$i % 2 ? 0: $bgcolor = $cfgBgcolorTwo;
?>
<tr bgcolor="<?php echo $bgcolor;?>">
<td>
<input type="text" name="field_name[]" size="10" value="<?php if(isset($row) && isset($row["Field"])) echo $row["Field"];?>">
<input type="hidden" name="field_orig[]" value="<?php if(isset($row) && isset($row["Field"])) echo $row["Field"];?>"></td>
<td><select name="field_type[]">
<?php
$row["Type"] = empty($row["Type"]) ? '' : $row["Type"];
$Type = stripslashes($row["Type"]);
$Type = eregi_replace("BINARY", "", $Type);
$Type = eregi_replace("ZEROFILL", "", $Type);
$Type = eregi_replace("UNSIGNED", "", $Type);
// $Length = eregi_replace("$Type|\\(|\\)", "", $Type);
// Strange: $Type would always match $Type, so replaced with version below:
// I Huneke (Logica) 29 September 1999
#$Length = eregi_replace("\\(|\\)", "", $Type);
$Length = $Type;
$Type = eregi_replace("\\(.*\\)", "", $Type);
$Type = chop($Type);
// Add test to ensure we're not trying to replace blank with blank
// I Huneke (Logica) 29 September 1999
if(!empty($Type))
{
$Length = eregi_replace("^$Type\(", "", $Length);
$Length = eregi_replace("\)$", "", trim($Length));
}
$Length = htmlspecialchars(chop($Length));
if($Length == $Type)
$Length = "";
for($j=0;$j<count($cfgColumnTypes);$j++)
{
echo "<option value=$cfgColumnTypes[$j]";
if(strtoupper($Type) == strtoupper($cfgColumnTypes[$j]))
echo " selected";
echo ">$cfgColumnTypes[$j]</option>\n";
}
?>
</select>
</td>
<td><input type="text" name="field_length[]" size="8" value="<?php echo $Length;?>"></td>
<td><select name="field_attribute[]">
<?php
$binary = eregi("BINARY", $row["Type"], $test_attribute1);
$unsigned = eregi("UNSIGNED", $row["Type"], $test_attribute2);
$zerofill = eregi("ZEROFILL", $row["Type"], $test_attribute3);
$strAttribute = "";
if($binary)
$strAttribute="BINARY";
if($unsigned)
$strAttribute="UNSIGNED";
if($zerofill)
$strAttribute="UNSIGNED ZEROFILL";
for($j=0;$j<count($cfgAttributeTypes);$j++)
{
echo "<option value=\"$cfgAttributeTypes[$j]\"";
if(strtoupper($strAttribute) == strtoupper($cfgAttributeTypes[$j]))
echo " selected";
echo ">$cfgAttributeTypes[$j]</option>\n";
}
?>
</select></td>
<td><select name="field_null[]">
<?php
if(!isset($row) || !isset($row["Null"]) || $row["Null"] == "")
{
?>
<option value=" not null">not null</option>
<option value="">null</option>
<?php
}
else
{
?>
<option value="">null</option>
<option value="not null">not null</option>
<?php
}
?>
</select></td>
<td><input type="text" name="field_default[]" size="8" value="<?php if(isset($row) && isset($row["Default"])) echo $row["Default"];?>"></td>
<td><select name="field_extra[]">
<?php
if(!isset($row) || !isset($row["Extra"]) || $row["Extra"] == "")
{
?>
<option value=""></option>
<option value="AUTO_INCREMENT">auto_increment</option>
<?php
}
else
{
?>
<option value="AUTO_INCREMENT">auto_increment</option>
<option value=""></option>
<?php
}
?>
</select></td>
<?php
if($action == "tbl_create.php" || $action == "tbl_addfield.php")
{
?>
<td align="center">
<input type="checkbox" name="field_primary[]" value="<?php echo $i;?>"
<?php
if(isset($row) && isset($row["Key"]) && $row["Key"] == "PRI")
echo "checked";
?>
>
</td>
<td align="center">
<input type="checkbox" name="field_index[]" value="<?php echo $i;?>"
<?php
if(isset($row) && isset($row["Key"]) && $row["Key"] == "MUL")
echo "checked";
?>
>
</td>
<td align="center">
<input type="checkbox" name="field_unique[]" value="<?php echo $i;?>"
<?php
if(isset($row) && isset($row["Key"]) && $row["Key"] == "UNI")
echo "checked";
?>
>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
<?php
if($action == "tbl_create.php" && MYSQL_MAJOR_VERSION == "3.23")
{
echo "$strTableComments:<br>";
?>
<input type="text" name="comment" style="width: <?php echo $cfgMaxInputsize;?>" maxlength="80">
<?php
}
?>
<p>
<input type="submit" name="submit" value="<?php echo $strSave;?>">
</p>
</form>
<center><?php print show_docu("manual_Reference.html#Create_table");?></center>