documentation.txt

一个用PHP编写的

    The HeaderFlipType can be set to 'css' or 'faked'. When using 'css' the
    rotation of the header for horizontalflipped is done via CSS. If set to
    'faked' PHP does the transformation for you, but of course this does not
    look as good as CSS.
$cfg[DefaultPropDisplay] string
    When editing/creating new columns in a table all fields normally get lined
    up one field a line. (default: 'horizontal'). If you set this to 'vertical'
    you can have each field lined up vertically beneath each other. You can
    save up a lot of place on the horizontal direction and no longer have to
    scroll.
$cfg[ShowBrowseComments] boolean
    $cfg[ShowPropertyComments] boolean
    By setting the corresponding variable to TRUE you can enable the display of
    column comments in Browse or Property display. In browse mode, the comments
    are show inside the header. In property mode, comments are displayed using
    a CSS-formatted dashed-line below the name of the field. The comment is
    shown as a tool-tip for that field.
$cfg[UploadDir] string
    The name of the directory where SQL files have been uploaded by other means
    than phpMyAdmin (for example, ftp). Those files are available under a
    drop-down box when you click the database name, then the SQL tab.

    If you want different directory for each user, %u will be replaced with
    username.

    Please note that the file names must have the suffix ".sql" (or ".sql.bz2"
    or ".sql.gz" if support for compressed formats is enabled).

    This feature is useful when your file is too big to be uploaded via HTTP,
    or when file uploads are disabled in PHP.

    Please note that if PHP is running in safe mode, this directory must be
    owned by the same user as the owner of the phpMyAdmin scripts.

    See also FAQ 1.16 for alternatives.
$cfg[docSQLDir] string
    The name of the directory where docSQL files can be uploaded for import
    into phpMyAdmin.

    Please note that if PHP is running in safe mode, this directory must be
    owned by the same user as the owner of the phpMyAdmin scripts.
$cfg[SaveDir] string
    The name of the directory where dumps can be saved.

    If you want different directory for each user, %u will be replaced with
    username.

    Please note that the directory has to be writable for user running
    webserver.

    Please note that if PHP is running in safe mode, this directory must be
    owned by the same user as the owner of the phpMyAdmin scripts.
$cfg[TempDir] string
    The name of the directory, where temporary files can be stored.

    This is needed for native MS Excel export, see FAQ 6.23
$cfg[Export] array
    In this array are defined default parameters for export, names of items are
    similar to texts seen on export page, so you can easily identify what they
    mean.
$cfg[Import] array
    In this array are defined default parameters for import, names of items are
    similar to texts seen on import page, so you can easily identify what they
    mean.
$cfg[RepeatCells] integer
    Repeat the headers every X cells, or 0 to deactivate.
$cfg[EditInWindow] boolean
    $cfg[QueryWindowWidth] integer
    $cfg[QueryWindowHeight] integer
    $cfg[QueryHistoryDB] boolean
    $cfg[QueryWindowDefTab] string
    $cfg[QueryHistoryMax] integer
    All those variables affect the query window feature. A SQL link or icon is
    always displayed on the left panel. If JavaScript is enabled in your
    browser, a click on this opens a distinct query window, which is a direct
    interface to enter SQL queries. Otherwise, the right panel changes to
    display a query box.

    The size of this query window can be customized with $cfg
    ['QueryWindowWidth'] and $cfg['QueryWindowWidth'] - both integers for the
    size in pixels. Note that normally, those parameters will be modified in
    layout.inc.php for the theme you are using.

    If $cfg['EditInWindow'] is set to true, a click on [Edit] from the results
    page (in the "Showing Rows" section) opens the query window and puts the
    current query inside it. If set to false, clicking on the link puts the SQL
    query in the right panel's query box.

    The usage of the JavaScript query window is recommended if you have a
    JavaScript enabled browser. Basic functions are used to exchange quite a
    few variables, so most 4th generation browsers should be capable to use
    that feature. It currently is only tested with Internet Explorer 6 and
    Mozilla 1.x.

    If $cfg['QueryHistoryDB'] is set to TRUE, all your Queries are logged to a
    table, which has to be created by you (see $cfg['Servers'][$i]['history']).
    If set to FALSE, all your queries will be appended to the form, but only as
    long as your window is opened they remain saved.

    When using the JavaScript based query window, it will always get updated
    when you click on a new table/db to browse and will focus if you click on
    "Edit SQL" after using a query. You can suppress updating the query window
    by checking the box "Do not overwrite this query from outside the window"
    below the query textarea. Then you can browse tables/databases in the
    background without losing the contents of the textarea, so this is
    especially useful when composing a query with tables you first have to look
    in. The checkbox will get automatically checked whenever you change the
    contents of the textarea. Please uncheck the button whenever you definitely
    want the query window to get updated even though you have made alterations.

    If $cfg['QueryHistoryDB'] is set to TRUE you can specify the amount of
    saved history items using $cfg['QueryHistoryMax'].

    The query window also has a custom tabbed look to group the features. Using
    the variable $cfg['QueryWindowDefTab'] you can specify the default tab to
    be used when opening the query window. It can be set to either 'sql',
    'files', 'history' or 'full'.
$cfg[BrowseMIME] boolean
    Enable MIME-transformations.
$cfg[MaxExactCount] integer
      + For InnoDB tables, determines for how large tables phpMyAdmin should
        get the exact row count using SELECT COUNT. If the approximate row
        count as returned by SHOW TABLE STATUS is smaller than this value,
        SELECT COUNT will be used, otherwise the approximate count will be
        used.
      + For VIEWs, since obtaining the exact count could have an impact on
        performance, this value is the maximum to be displayed.
$cfg[WYSIWYG-PDF] boolean
    Utilizes a WYSIWYG editing control to easily place elements of a PDF page.
    By clicking on the button 'toggle scratchboard' on the page where you edit
    x/y coordinates of those elements you can activate a scratchboard where all
    your elements are placed. By clicking on an element, you can move them
    around in the pre-defined area and the x/y coordinates will get updated
    dynamically. Likewise, when entering a new position directly into the input
    field, the new position in the scratchboard changes after your cursor
    leaves the input field.
    You have to click on the 'OK'-button below the tables to save the new
    positions. If you want to place a new element, first add it to the table of
    elements and then you can drag the new element around.
    By changing the paper size and the orientation you can change the size of
    the scratchboard as well. You can do so by just changing the dropdown field
    below, and the scratchboard will resize automatically, without interfering
    with the current placement of the elements.
    If ever an element gets out of range you can either enlarge the paper size
    or click on the 'reset' button to place all elements below each other.
    NOTE: You have to use a recent browser like IE6 or Mozilla to get this
    control to work. The basic Drag&Drop script functionality was kindly
    borrowed from www.youngpup.net and is underlying so specific license.
$cfg[NaturalOrder] boolean
    Sorts database and table names according to natural order (for example, t1,
    t2, t10). Currently implemented in the left panel (Light mode) and in
    Database view, for the table list.
$cfg[ShowHttpHostTitle] boolean
    Shows the HTTP host name in window's title bar.
$cfg[SetHttpHostTitle] string
    If $cfg['ShowHttpHostTitle'] is TRUE, it shows the real HTTP host name,
    unless an alternate name is set here.
$cfg[ErrorIconic] boolean
    Uses icons for warnings, errors and informations.
$cfg[MainPageIconic] boolean
    Uses icons on main page in lists and menu tabs.
$cfg[ReplaceHelpImg] boolean
    Shows a help button instead of the "Documentation" message.
$cfg[ThemePath] string
    If theme manager is active, use this as the path of the subdirectory
    containing all the themes.
$cfg[ThemeManager] boolean
    Enables user-selectable themes. See FAQ 2.7.
$cfg[ThemeDefault] string
    The default theme (a subdirectory under cfg['ThemePath']).
$cfg[ThemePerServer] boolean
    Whether to allow different theme for each server.
$cfg[DefaultQueryTable] string
    $cfg[DefaultQueryDatabase] string
    Default queries that will be displayed in query boxes when user didn't
    specify any. Use %d for database name, %t for table name and %f for a comma
    separated list of field names. Note that %t and %f are only applicable to
    $cfg['DefaultQueryTable'].
$cfg[SQP]['fmtType'] string [html|none]
    The main use of the new SQL Parser is to pretty-print SQL queries. By
    default we use HTML to format the query, but you can disable this by
    setting this variable to 'none'.
$cfg[SQP]['fmtInd'] float
    $cfg[SQP]['fmtIndUnit'] string [em|px|pt|ex]
    For the pretty-printing of SQL queries, under some cases the part of a
    query inside a bracket is indented. By changing $cfg['SQP']['fmtInd'] you
    can change the amount of this indent.
    Related in purpose is $cfg['SQP']['fmtIndUnit'] which specifies the units
    of the indent amount that you specified. This is used via stylesheets.
$cfg[SQP]['fmtColor'] array of string tuples
    This array is used to define the colours for each type of element of the
    pretty-printed SQL queries. The tuple format is
    class => [HTML colour code | empty string]
    If you specify an empty string for the color of a class, it is ignored in
    creating the stylesheet. You should not alter the class names, only the
    colour strings.
    Class name key:
      + comment Applies to all comment sub-classes
      + comment_mysql Comments as "#...\n"
      + comment_ansi Comments as "-- ...\n"
      + comment_c Comments as "/*...*/"
      + digit Applies to all digit sub-classes
      + digit_hex Hexadecimal numbers
      + digit_integer Integer numbers
      + digit_float Floating point numbers
      + punct Applies to all punctuation sub-classes
      + punct_bracket_open_round Opening brackets"("
      + punct_bracket_close_round Closing brackets ")"
      + punct_listsep List item Separator ","
      + punct_qualifier Table/Column Qualifier "."
      + punct_queryend End of query marker ";"
      + alpha Applies to all alphabetic classes
      + alpha_columnType Identifiers matching a column type
      + alpha_columnAttrib Identifiers matching a database/table/column
        attribute
      + alpha_functionName Identifiers matching a MySQL function name
      + alpha_reservedWord Identifiers matching any other reserved word
      + alpha_variable Identifiers matching a SQL variable "@foo"
      + alpha_identifier All other identifiers
      + quote Applies to all quotation mark classes
      + quote_double Double quotes "
      + quote_single Single quotes '
      + quote_backtick Backtick quotes `
$cfg[SQLValidator]['use'] boolean
    phpMyAdmin now supports use of the Mimer SQL Validator service, as
    originally published on Slashdot.
    For help in setting up your system to use the service, see the FAQ #6.14.
$cfg[SQLValidator]['username'] string
    $cfg[SQLValidator]['password'] string
    The SOAP service allows you to login with anonymous and any password, so we
    use those by default. Instead, if you have an account with them, you can
    put your login details here, and it will be used in place of the anonymous
    login.
$cfg[DBG]['enable'] boolean
    DEVELOPERS ONLY!
    Enable the DBG extension for debugging phpMyAdmin. Required for profiling
    the code.
    For help in setting up your system to this, see the Developers section.
$cfg[DBG]['profile']['enable'] boolean
    DEVELOPERS ONLY!
    Enable profiling support for phpMyAdmin. This will append a chunk of data
    to the end of every page displayed in the main window with profiling
    statistics for that page.
    You may need to increase the maximum execution time for this to complete
    successfully.
$cfg[DBG]['profile']['threshold'] float (units in milliseconds)
    DEVELOPERS ONLY!
    When profiling data is displayed, this variable controls the threshold of
    display for any profiling data, based on the average time each time has
    taken. If it is over the threshold it is displayed, otherwise it is not
    displayed. This takes a value in milliseconds. In most cases you don't need
    t