📄 documentation.txt
字号:
$cfg['AllowAnywhereRecoding'] boolean Allow character set recoding of MySQL queries. You need recode or iconv support (compiled in or module) in PHP to allow MySQL queries recoding and used language file must have it enabled (by default only these which are in Unicode, just to avoid losing some characters). Setting this to TRUE also activates a pull-down menu in the Export page, to choose the character set when exporting a file.$cfg['RecodingEngine'] string You can select here which functions will be used for character set conversion. Possible values are: + auto - automatically use available one (first is tested iconv, then recode) + iconv - use iconv or libiconv functions + recode - use recode_string function Default is auto.$cfg['IconvExtraParams'] string Specify some parameters for iconv used in charset conversion. See iconv documentation for details. By default //TRANSLIT is used, so that invalid characters will be transliterated.$cfg['AvailableCharsets'] array Available character sets for MySQL conversion. You can add your own (any of supported by recode/iconv) or remove these which you don't use. Character sets will be shown in same order as here listed, so if you frequently use some of these move them to the top.$cfg['TrustedProxies'] array Lists proxies and HTTP headers which are trusted for IP Allow/Deny. This list is by default empty, you need to fill in some trusted proxy servers if you want to use rules for IP addresses behind proxy. The following example specifies that phpMyAdmin should trust a HTTP_X_FORWARDED_FOR (X-Forwarded-For) header coming from the proxy 1.2.3.4: $cfg['TrustedProxies'] = array('1.2.3.4' => 'HTTP_X_FORWARDED_FOR'); The $cfg['Servers'][$i]['AllowDeny']['rules'] directive uses the client's IP address as usual.$cfg['GD2Available'] string Specifies whether GD >= 2 is available. If yes it can be used for MIME transformations. Possible values are: + auto - automatically detect, this is a bit expensive operation for php < 4.3.0 so it is preferred to change this according to your server real possibilities + yes - GD 2 functions can be used + no - GD 2 function cannot be used Default is auto.$cfg['NaviWidth'] integer Navi frame width in pixels. See themes/themename/layout.inc.php.$cfg['NaviBackground'] string [valid css code for background] $cfg['MainBackground'] string [valid css code for background] The background styles used for both the frames. See themes/themename/ layout.inc.php.$cfg['NaviPointerBackground'] string [valid css code for background] $cfg['NaviPointerColor'] string [valid css color] The style used for the pointer in the navi frame. See themes/themename/ layout.inc.php.$cfg['LeftPointerEnable'] boolean A value of TRUE activates the navi pointer (when LeftFrameLight is FALSE).$cfg['Border'] integer The size of a table's border. See themes/themename/layout.inc.php.$cfg['ThBackground'] string [valid css code for background] $cfg['ThColor'] string [valid css color] The style used for table headers. See themes/themename/layout.inc.php.$cfg['BgOne'] string [HTML color] The color (HTML) #1 for table rows. See themes/themename/layout.inc.php.$cfg['BgTwo'] string [HTML color] The color (HTML) #2 for table rows. See themes/themename/layout.inc.php.$cfg['BrowsePointerBackground'] string [HTML color] $cfg['BrowsePointerColor'] string [HTML color] $cfg['BrowseMarkerBackground'] string [HTML color] $cfg['BrowseMarkerColor'] string [HTML color] The colors (HTML) uses for the pointer and the marker in browse mode. The former feature highlights the row over which your mouse is passing and the latter lets you visually mark/unmark rows by clicking on them. See themes/themename/layout.inc.php.$cfg['FontFamily'] string You put here a valid CSS font family value, for example arial, sans-serif. See themes/themename/layout.inc.php.$cfg['FontFamilyFixed'] string You put here a valid CSS font family value, for example monospace. This one is used in textarea. See themes/themename/layout.inc.php.$cfg['BrowsePointerEnable'] boolean Whether to activate the browse pointer or not.$cfg['BrowseMarkerEnable'] boolean Whether to activate the browse marker or not.$cfg['TextareaCols'] integer $cfg['TextareaRows'] integer $cfg['CharTextareaCols'] integer $cfg['CharTextareaRows'] integer Number of columns and rows for the textareas. This value will be emphasized (*2) for SQL query textareas and (*1.25) for SQL textareas inside the query window. The Char* values are used for CHAR and VARCHAR editing (if configured via $cfg['CharEditing']).$cfg['LongtextDoubleTextarea'] boolean Defines whether textarea for LONGTEXT fields should have double size.$cfg['TextareaAutoSelect'] boolean Defines if the whole textarea of the query box will be selected on click.$cfg['CtrlArrowsMoving'] boolean Enable Ctrl+Arrows (Option+Arrows in Safari) moving between fields when editing.$cfg['LimitChars'] integer Maximum number of characters showen in any non-numeric field on browse view. Can be turned off by a toggle button on the browse page.$cfg['ModifyDeleteAtLeft'] boolean $cfg['ModifyDeleteAtRight'] boolean Defines the place where modify and delete links would be put when tables contents are displayed (you may have them displayed both at the left and at the right). "Left" and "right" are parsed as "top" and "bottom" with vertical display mode.$cfg['DefaultDisplay'] string $cfg['HeaderFlipType'] string There are 3 display modes: horizontal, horizontalflipped and vertical. Define which one is displayed by default. The first mode displays each row on a horizontal line, the second rotates the headers by 90 degrees, so you can use descriptive headers even though fields only contain small values and still print them out. The vertical mode sorts each row on a vertical lineup. The HeaderFlipType can be set to 'css' or 'fake'. When using 'css' the rotation of the header for horizontalflipped is done via CSS. If set to 'fake' PHP does the transformation for you, but of course this does not look as good as CSS.$cfg['DefaultPropDisplay'] string or integer 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. If you set this to integer, editing of fewer columns will appear in 'vertical' mode, while editing of more fields still in 'horizontal' mode. This way you can still effectively edit large number of fields, while having full view on few of them.$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 shown 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['SQLQuery']['Edit'] boolean Whether to display an edit link to change a query in any SQL Query box.$cfg['SQLQuery']['Explain'] boolean Whether to display a link to explain a SELECT query in any SQL Query box.$cfg['SQLQuery']['ShowAsPHP'] boolean Whether to display a link to wrap a query in PHP code in any SQL Query box.$cfg['SQLQuery']['Validate'] boolean Whether to display a link to validate a query in any SQL Query box. See also $cfg_SQLValidator.$cfg['SQLQuery']['Refresh'] boolean Whether to display a link to refresh a query in any SQL Query box.$cfg['UploadDir'] string The name of the directory where$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['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-tran
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -