PHP optionlist函数代码示例

    function loginForm()
    {
        ?>
<table cellspacing="0">
<tr><th><?php 
        echo lang('Server');
        ?>
<td><input type="hidden" name="driver" value="<?php 
        echo $this->driver;
        ?>
"><select name="server"><?php 
        echo optionlist($this->servers, SERVER);
        ?>
</select>
<tr><th><?php 
        echo lang('Username');
        ?>
<td><input id="username" name="username" value="<?php 
        echo h($_GET["username"]);
        ?>
">
<tr><th><?php 
        echo lang('Password');
        ?>
<td><input type="password" name="password">
</table>
<p><input type="submit" value="<?php 
        echo lang('Login');
        ?>
">
<?php 
        echo checkbox("permanent", 1, $_COOKIE["adminer_permanent"], lang('Permanent login')) . "\n";
        return true;
    }

 public function editInput($table, $field, $attrs, $value)
 {
     if ($field["type"] == "enum") {
         $options = array("" => array());
         $selected = $value;
         if (isset($_GET["select"])) {
             $options[""][-1] = lang('original');
         }
         if ($field["null"]) {
             $options[""][""] = "NULL";
             if ($value === null && !isset($_GET["select"])) {
                 $selected = "";
             }
         }
         $options[""][0] = lang('empty');
         preg_match_all("~'((?:[^']|'')*)'~", $field["length"], $matches);
         foreach ($matches[1] as $i => $val) {
             $val = stripcslashes(str_replace("''", "'", $val));
             $options[$i + 1] = $val;
             if ($value === $val) {
                 $selected = $i + 1;
             }
         }
         return "<select{$attrs}>" . optionlist($options, (string) $selected, 1) . "</select>";
         // 1 - use keys
     }
 }

 function selectEmailPrint($emailFields, $columns)
 {
     if ($emailFields) {
         print_fieldset("email", 'E-mail');
         echo "<div onkeydown=\"eventStop(event); return bodyKeydown(event, 'email');\">\n";
         echo "<p>" . 'From' . ": <input name='email_from' value='" . h($_POST ? $_POST["email_from"] : $_COOKIE["adminer_email"]) . "'>\n";
         echo 'Subject' . ": <select name='email_id'><option>" . optionlist(get_key_vals("SELECT {$this->id}, {$this->title} FROM {$this->table} ORDER BY {$this->title}"), $_POST["email_id"], true) . "</select>\n";
         echo "<p>" . 'Attachments' . ": <input type='file' name='email_files[]' onchange=\"this.onchange = function () { }; var el = this.cloneNode(true); el.value = ''; this.parentNode.appendChild(el);\">";
         echo "<p>" . (count($emailFields) == 1 ? '<input type="hidden" name="email_field" value="' . h(key($emailFields)) . '">' : html_select("email_field", $emailFields));
         echo "<input type='submit' name='email' value='" . 'Send' . "' onclick=\"return this.form['delete'].onclick();\">\n";
         echo "</div>\n";
         echo "</div></fieldset>\n";
         return true;
     }
 }

 function editInput($table, $field, $attrs, $value)
 {
     static $foreignTables = array();
     static $values = array();
     $foreignKeys =& $foreignTables[$table];
     if ($foreignKeys === null) {
         $foreignKeys = column_foreign_keys($table);
     }
     foreach ((array) $foreignKeys[$field["field"]] as $foreignKey) {
         if (count($foreignKey["source"]) == 1) {
             $target = $foreignKey["table"];
             $id = $foreignKey["target"][0];
             $options =& $values[$target][$id];
             if (!$options) {
                 $options = array("" => "") + get_vals("SELECT " . idf_escape($id) . " FROM " . table($target) . " ORDER BY 1");
             }
             return "<select{$attrs}>" . optionlist($options, $value) . "</select>";
         }
     }
 }

    function loginForm()
    {
        ?>
<table cellspacing="0">
<tr><th><?php 
        echo lang('Server');
        ?>
<td><input type="hidden" id="username" name="auth[username]" value="root"><input type="hidden" name="auth[password]"><input type="hidden" name="auth[driver]" value="<?php 
        echo $this->driver;
        ?>
"><select name="auth[server]"><?php 
        echo optionlist($this->servers, SERVER);
        ?>
</select>
</table>
<p><input type="submit" value="<?php 
        echo lang('Login');
        ?>
">
<?php 
        echo checkbox("auth[permanent]", 1, $_COOKIE["adminer_permanent"], lang('Permanent login')) . "\n";
        return true;
    }

    /** Prints databases list in menu
     * @param string
     * @return null
     */
    function databasesPrint($missing)
    {
        global $adminer, $connection;
        $databases = $this->databases();
        ?>
<form action="">
<p id="dbs">
<?php 
        hidden_fields_get();
        $db_events = " onmousedown='dbMouseDown(event, this);' onchange='dbChange(this);'";
        echo "<span title='" . lang('database') . "'>DB</span>: " . ($databases ? "<select name='db'{$db_events}>" . optionlist(array("" => "") + $databases, DB) . "</select>" : '<input name="db" value="' . h(DB) . '" autocapitalize="off">');
        echo "<input type='submit' value='" . lang('Use') . "'" . ($databases ? " class='hidden'" : "") . ">\n";
        if ($missing != "db" && DB != "" && $connection->select_db(DB)) {
            if (support("scheme")) {
                echo "<br>" . lang('Schema') . ": <select name='ns'{$db_events}>" . optionlist(array("" => "") + $adminer->schemas(), $_GET["ns"]) . "</select>";
                if ($_GET["ns"] != "") {
                    set_schema($_GET["ns"]);
                }
            }
        }
        echo isset($_GET["sql"]) ? '<input type="hidden" name="sql" value="">' : (isset($_GET["schema"]) ? '<input type="hidden" name="schema" value="">' : (isset($_GET["dump"]) ? '<input type="hidden" name="dump" value="">' : (isset($_GET["privileges"]) ? '<input type="hidden" name="privileges" value="">' : "")));
        echo "</p></form>\n";
    }

/** Print edit input field
* @param array one field from fields()
* @param mixed
* @param string
* @return null
*/
function input($field, $value, $function)
{
    global $connection, $types, $adminer, $jush;
    $name = h(bracket_escape($field["field"]));
    echo "<td class='function'>";
    if (is_array($value) && !$function) {
        $args = array($value);
        if (version_compare(PHP_VERSION, 5.4) >= 0) {
            $args[] = JSON_PRETTY_PRINT;
        }
        $value = call_user_func_array('json_encode', $args);
        //! requires PHP 5.2
        $function = "json";
    }
    $reset = $jush == "mssql" && $field["auto_increment"];
    if ($reset && !$_POST["save"]) {
        $function = null;
    }
    $functions = (isset($_GET["select"]) || $reset ? array("orig" => lang('original')) : array()) + $adminer->editFunctions($field);
    $attrs = " name='fields[{$name}]'";
    if ($field["type"] == "enum") {
        echo nbsp($functions[""]) . "<td>" . $adminer->editInput($_GET["edit"], $field, $attrs, $value);
    } else {
        $first = 0;
        foreach ($functions as $key => $val) {
            if ($key === "" || !$val) {
                break;
            }
            $first++;
        }
        $onchange = $first ? " onchange=\"var f = this.form['function[" . h(js_escape(bracket_escape($field["field"]))) . "]']; if ({$first} > f.selectedIndex) f.selectedIndex = {$first};\" onkeyup='keyupChange.call(this);'" : "";
        $attrs .= $onchange;
        $has_function = in_array($function, $functions) || isset($functions[$function]);
        echo (count($functions) > 1 ? "<select name='function[{$name}]' onchange='functionChange(this);'" . on_help("getTarget(event).value.replace(/^SQL\$/, '')", 1) . ">" . optionlist($functions, $function === null || $has_function ? $function : "") . "</select>" : nbsp(reset($functions))) . '<td>';
        $input = $adminer->editInput($_GET["edit"], $field, $attrs, $value);
        // usage in call is without a table
        if ($input != "") {
            echo $input;
        } elseif ($field["type"] == "set") {
            //! 64 bits
            preg_match_all("~'((?:[^']|'')*)'~", $field["length"], $matches);
            foreach ($matches[1] as $i => $val) {
                $val = stripcslashes(str_replace("''", "'", $val));
                $checked = is_int($value) ? $value >> $i & 1 : in_array($val, explode(",", $value), true);
                echo " <label><input type='checkbox' name='fields[{$name}][{$i}]' value='" . (1 << $i) . "'" . ($checked ? ' checked' : '') . "{$onchange}>" . h($adminer->editVal($val, $field)) . '</label>';
            }
        } elseif (preg_match('~blob|bytea|raw|file~', $field["type"]) && ini_bool("file_uploads")) {
            echo "<input type='file' name='fields-{$name}'{$onchange}>";
        } elseif (($text = preg_match('~text|lob~', $field["type"])) || preg_match("~\n~", $value)) {
            if ($text && $jush != "sqlite") {
                $attrs .= " cols='50' rows='12'";
            } else {
                $rows = min(12, substr_count($value, "\n") + 1);
                $attrs .= " cols='30' rows='{$rows}'" . ($rows == 1 ? " style='height: 1.2em;'" : "");
                // 1.2em - line-height
            }
            echo "<textarea{$attrs}>" . h($value) . '</textarea>';
        } elseif ($function == "json") {
            echo "<textarea{$attrs} cols='50' rows='12' class='jush-js'>" . h($value) . '</textarea>';
        } else {
            // int(3) is only a display hint
            $maxlength = !preg_match('~int~', $field["type"]) && preg_match('~^(\\d+)(,(\\d+))?$~', $field["length"], $match) ? (preg_match("~binary~", $field["type"]) ? 2 : 1) * $match[1] + ($match[3] ? 1 : 0) + ($match[2] && !$field["unsigned"] ? 1 : 0) : ($types[$field["type"]] ? $types[$field["type"]] + ($field["unsigned"] ? 0 : 1) : 0);
            if ($jush == 'sql' && $connection->server_info >= 5.6 && preg_match('~time~', $field["type"])) {
                $maxlength += 7;
                // microtime
            }
            // type='date' and type='time' display localized value which may be confusing, type='datetime' uses 'T' as date and time separator
            echo "<input" . ((!$has_function || $function === "") && preg_match('~(?<!o)int~', $field["type"]) && !preg_match('~\\[\\]~', $field["full_type"]) ? " type='number'" : "") . " value='" . h($value) . "'" . ($maxlength ? " maxlength='{$maxlength}'" : "") . (preg_match('~char|binary~', $field["type"]) && $maxlength > 20 ? " size='40'" : "") . "{$attrs}>";
        }
    }
}

/** Print table columns for type edit
* @param string
* @param array
* @param array
* @param array returned by referencable_primary()
* @return null
*/
function edit_type($key, $field, $collations, $foreign_keys = array())
{
    global $structured_types, $types, $unsigned, $on_actions;
    $type = $field["type"];
    ?>
<td><select name="<?php 
    echo h($key);
    ?>
[type]" class="type" onfocus="lastType = selectValue(this);" onchange="editingTypeChange(this);"<?php 
    echo on_help("getTarget(event).value", 1);
    ?>
><?php 
    if ($type && !isset($types[$type]) && !isset($foreign_keys[$type])) {
        array_unshift($structured_types, $type);
    }
    if ($foreign_keys) {
        $structured_types[lang('Foreign keys')] = $foreign_keys;
    }
    echo optionlist($structured_types, $type);
    ?>
</select>
<td><input name="<?php 
    echo h($key);
    ?>
[length]" value="<?php 
    echo h($field["length"]);
    ?>
" size="3" onfocus="editingLengthFocus(this);"<?php 
    echo !$field["length"] && preg_match('~var(char|binary)$~', $type) ? " class='required'" : "";
    ?>
 onchange="editingLengthChange(this);" onkeyup="this.onchange();"><td class="options"><?php 
    //! type="number" with enabled JavaScript
    echo "<select name='" . h($key) . "[collation]'" . (preg_match('~(char|text|enum|set)$~', $type) ? "" : " class='hidden'") . '><option value="">(' . lang('collation') . ')' . optionlist($collations, $field["collation"]) . '</select>';
    echo $unsigned ? "<select name='" . h($key) . "[unsigned]'" . (!$type || preg_match('~((^|[^o])int|float|double|decimal)$~', $type) ? "" : " class='hidden'") . '><option>' . optionlist($unsigned, $field["unsigned"]) . '</select>' : '';
    echo isset($field['on_update']) ? "<select name='" . h($key) . "[on_update]'" . (preg_match('~timestamp|datetime~', $type) ? "" : " class='hidden'") . '>' . optionlist(array("" => "(" . lang('ON UPDATE') . ")", "CURRENT_TIMESTAMP"), $field["on_update"]) . '</select>' : '';
    echo $foreign_keys ? "<select name='" . h($key) . "[on_delete]'" . (preg_match("~`~", $type) ? "" : " class='hidden'") . "><option value=''>(" . lang('ON DELETE') . ")" . optionlist(explode("|", $on_actions), $field["on_delete"]) . "</select> " : " ";
    // space for IE
}

    ?>
<input type="submit" name="drop" value="<?php 
    echo lang('Drop');
    ?>
"<?php 
    echo confirm();
    ?>
><?php 
}
if (support("partitioning")) {
    $partition_table = preg_match('~RANGE|LIST~', $row["partition_by"]);
    print_fieldset("partition", lang('Partition by'), $row["partition_by"]);
    ?>
<p>
<?php 
    echo "<select name='partition_by' onchange='partitionByChange(this);'" . on_help("getTarget(event).value.replace(/./, 'PARTITION BY \$&')", 1) . ">" . optionlist(array("" => "") + $partition_by, $row["partition_by"]) . "</select>";
    ?>
(<input name="partition" value="<?php 
    echo h($row["partition"]);
    ?>
">)
<?php 
    echo lang('Partitions');
    ?>
: <input type="number" name="partitions" class="size<?php 
    echo $partition_table || !$row["partition_by"] ? " hidden" : "";
    ?>
" value="<?php 
    echo h($row["partitions"]);
    ?>
">

function edit_fields($fields, $collations, $type = "TABLE")
{
    global $inout;
    ?>
<thead><tr>
<?php 
    if ($type == "PROCEDURE") {
        ?>
<td><?php 
        echo lang('IN-OUT');
        ?>
</td><?php 
    }
    ?>
<th><?php 
    echo $type == "TABLE" ? lang('Column name') : lang('Parameter name');
    ?>
</th>
<td><?php 
    echo lang('Type');
    ?>
</td>
<td><?php 
    echo lang('Length');
    ?>
</td>
<td><?php 
    echo lang('Options');
    ?>
</td>
<?php 
    if ($type == "TABLE") {
        ?>
<td><?php 
        echo lang('NULL');
        ?>
</td>
<td><input type="radio" name="auto_increment_col" value="" /><?php 
        echo lang('Auto Increment');
        ?>
</td>
<td><?php 
        echo lang('Comment');
        ?>
</td>
<?php 
    }
    ?>
<td><input type="image" name="add[0]" src="<?php 
    echo preg_replace("~\\?.*~", "", $_SERVER["REQUEST_URI"]) . "?file=plus.gif";
    ?>
" title="<?php 
    echo lang('Add next');
    ?>
" /></td>
</tr></thead>
<?php 
    $column_comments = false;
    foreach ($fields as $i => $field) {
        $i++;
        $display = $_POST["add"][$i - 1] || isset($field["field"]) && !$_POST["drop_col"][$i];
        ?>
<tr<?php 
        echo $display ? "" : " style='display: none;'";
        ?>
>
<?php 
        if ($type == "PROCEDURE") {
            ?>
<td><select name="fields[<?php 
            echo $i;
            ?>
][inout]"><?php 
            echo optionlist($inout, $field["inout"]);
            ?>
</select></td><?php 
        }
        ?>
<th><?php 
        if ($display) {
            ?>
<input name="fields[<?php 
            echo $i;
            ?>
][field]" value="<?php 
            echo htmlspecialchars($field["field"]);
            ?>
" maxlength="64" /><?php 
        }
        ?>
<input type="hidden" name="fields[<?php 
        echo $i;
        ?>
][orig]" value="<?php 
        echo htmlspecialchars($field[$_POST ? "orig" : "field"]);
        ?>
" /></th>
<?php 
        edit_type("fields[{$i}]", $field, $collations);
        if ($type == "TABLE") {
//.........这里部分代码省略.........

/** Print table columns for type edit
* @param string
* @param array
* @param array
* @param array returned by referencable_primary()
* @return null
*/
function edit_type($key, $field, $collations, $foreign_keys = array())
{
    global $structured_types, $types, $unsigned, $on_actions;
    ?>
<td><select name="<?php 
    echo $key;
    ?>
[type]" class="type" onfocus="lastType = selectValue(this);" onchange="editingTypeChange(this);"><?php 
    echo optionlist((!$field["type"] || isset($types[$field["type"]]) ? array() : array($field["type"])) + $structured_types + ($foreign_keys ? array(lang('Foreign keys') => $foreign_keys) : array()), $field["type"]);
    ?>
</select>
<td><input name="<?php 
    echo $key;
    ?>
[length]" value="<?php 
    echo h($field["length"]);
    ?>
" size="3" onfocus="editingLengthFocus(this);"><td class="options"><?php 
    echo "<select name='{$key}" . "[collation]'" . (ereg('(char|text|enum|set)$', $field["type"]) ? "" : " class='hidden'") . '><option value="">(' . lang('collation') . ')' . optionlist($collations, $field["collation"]) . '</select>';
    echo $unsigned ? "<select name='{$key}" . "[unsigned]'" . (!$field["type"] || ereg('(int|float|double|decimal)$', $field["type"]) ? "" : " class='hidden'") . '><option>' . optionlist($unsigned, $field["unsigned"]) . '</select>' : '';
    echo $foreign_keys ? "<select name='{$key}" . "[on_delete]'" . (ereg("`", $field["type"]) ? "" : " class='hidden'") . "><option value=''>(" . lang('ON DELETE') . ")" . optionlist(explode("|", $on_actions), $field["on_delete"]) . "</select> " : " ";
    // space for IE
}

 /** Print order box in select
  * @param array result of selectOrderProcess()
  * @param array selectable columns
  * @param array
  * @return null
  */
 function selectOrderPrint($order, $columns, $indexes)
 {
     print_fieldset("sort", lang('Sort'), $order);
     $i = 0;
     foreach ((array) $_GET["order"] as $key => $val) {
         if (isset($columns[$val])) {
             echo "<div><select name='order[{$i}]'><option>" . optionlist($columns, $val, true) . "</select>";
             echo checkbox("desc[{$i}]", 1, isset($_GET["desc"][$key]), lang('descending')) . "</div>\n";
             $i++;
         }
     }
     echo "<div><select name='order[{$i}]' onchange='selectAddRow(this);'><option>" . optionlist($columns, null, true) . "</select>";
     echo "<label><input type='checkbox' name='desc[{$i}]' value='1'>" . lang('descending') . "</label></div>\n";
     // not checkbox() to allow selectAddRow()
     echo "</div></fieldset>\n";
 }

/** Generate HTML radio list
* @param string
* @param array
* @param string
* @param string true for no onchange, false for radio
* @return string
*/
function html_select($name, $options, $value = "", $onchange = true)
{
    if ($onchange) {
        return "<select name='" . h($name) . "'" . (is_string($onchange) ? ' onchange="' . h($onchange) . '"' : "") . ">" . optionlist($options, $value) . "</select>";
    }
    $return = "";
    foreach ($options as $key => $val) {
        $return .= "<label><input type='radio' name='" . h($name) . "' value='" . h($key) . "'" . ($key == $value ? " checked" : "") . ">" . h($val) . "</label>";
    }
    return $return;
}