Configuring window title

When the navigation and main panels are displayed, the window's title changes to reflect which MySQL server, database, and table are active. These directives control the following amount of information to be displayed: $cfg['TitleDefault'], $cfg['TitleServer'], $cfg['TitleDatabase'], and $cfg['TitleTable'].

If no server is selected, $cfg['TitleDefault'] controls the title. When a server is selected (but no database), $cfg['TitleServer'] controls what is displayed in the title bar. Then if a database is selected, $cfg['TitleDatabase'] enters into play. Finally, $cfg['TitleTable'] is effective if a table is selected.

These directives contain format strings that control which piece of information is shown. For example, here is the default value of one of these directives:

$cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';

The possible format strings and their meaning are described in Documentation.html, FAQ 6.27.

Natural sort order for database and table names

Usually, computers sort items in lexical order, which gives the following results for a list of tables:

table1
table10
table2
table3

phpMyAdmin implements natural sort order by default, as specified by $cfg['NaturalOrder'] being TRUE. Thus the database and table lists in navigation and main panels are sorted as:

table1
table2
table3
table10

Creating site-specific header and footer

Some users may want to display a company logo, a link to their company's helpdesk, or other information on the phpMyAdmin interface. In the main phpMyAdmin directory, for this purpose, we can create two scripts—config.header.inc.php and config.footer.inc.php. We can put our own PHP or XHTML code in these scripts, and it will appear either at the beginning (for header) or at the end (for footer) of the cookie login and the main panel pages.

For example, creating a config.footer.inc.php containing these lines:

<hr />
<em>All the information on this page is confidential.</em>

Using such a sentence in the footer would produce the intended message on all pages as shown in the following screenshot:

Themes

A theme system is available in phpMyAdmin. The color parameters and the various icons are located in a directory structure under the themes sub-directory. For each available theme, there is a sub-directory named after the theme. It contains:

The downloaded kit contains two themes but there are more available at http://phpmyadmin.net/home_page/themes.php. Installing a new theme is just a matter of downloading the corresponding .zip file and extracting it into the themes sub-directory.

Selecting themes

On the home page, we can offer a theme selector to users. Setting $cfg['ThemeManager'] to TRUE (the default) shows the selector as shown in the following screenshot:

To help choose a suitable theme, the Theme / Style link displays a panel containing screenshots of the available themes and a Get more themes link. We can then click on take it under the theme we want. A reference to the chosen theme is stored in a cookie and, by default, is applied to all servers we connect to.

To make phpMyAdmin remember one theme per MySQL server, we set $cfg['ThemePerServer'] to TRUE.

Selecting a language

A Language selector appears on the login panel (if any) and on the home page. The default behavior of phpMyAdmin is to use the language defined in our browser's preferences, if there is a corresponding language file for this version.

The default language used, in case the program cannot detect one, is defined in config.inc.php in the $cfg['DefaultLang'] parameter with'en' (English). This value can be changed. The possible values for language names are defined in the libraries/select_lang.lib.php script in the PMA_langDetails() function.

Even if the default language is defined, each user (especially on a multi-user installation) can choose his/her preferred language from the selector. The user's choice will be remembered in a cookie whenever possible.

We can also force a single language by setting the $cfg['Lang'] parameter with a value, such as'fr' (French). Another parameter, $cfg['FilterLanguages'], is available. Suppose we want to shorten the list of available languages to English and Fran?ais—French, as those are the ones used exclusively by the users of this phpMyAdmin's instance. This is accomplished by building a regular expression indicating which languages we want to display based on the ISO 639 codes of these languages. To continue with our example, we would use:

$cfg['FilterLanguages'] = '^(fr|en)';

In this expression, the caret (^) means "starting with" and the (|) means "or". The expression indicates that we are restricting the list to languages whose corresponding ISO codes start with fr or en.

By default, this parameter is empty, meaning that no filter is applied to the list of available languages.

Slider

On some pages, you will see a small plus sign followed by a controlling label—either Options or Details. A click on the label opens a slider to reveal a section of the interface, which is believed to be less often used in day-to-day work. As few people prefer to immediately see the whole interface at the expense of screen space, there is a configuration parameter that controls how the sliders are initially set:

$cfg['InitialSlidersState'] = 'closed';

The default value of closed means that sliders must be opened by a click on the label; you might have guessed that the reverse value is open. A third value, disabled, can be used by slider-allergic users.

Restricting the list of databases

Sometimes it is useful to avoid showing in the navigation panel, all the databases a user has access to. phpMyAdmin offers two ways of restriction—only_db and hide_db.

To specify the list of what can be seen, the only_db parameter is used. It may contain a database name or a list of database names. Only these databases will be seen in the navigation panel:

$cfg['Servers'][$i]['only_db'] = 'payroll';
$cfg['Servers'][$i]['only_db'] = array('payroll', 'hr);

The database names can contain MySQL wildcard characters such as _ and %. These wildcard characters are described at http://dev.mysql.com/doc/refman/5.1/en/account-names.html. If an array is used to specify many databases, they will be displayed on the interface in the same order they are listed in the array.

Another feature of only_db is that you can use it not to restrict the list, but instead to put emphasis on certain names that will be displayed on top of the list. Here, the myspecial database name will appear first, followed by all other names:

$cfg['Servers'][$i]['only_db'] = array('myspecial', '*');

We can also indicate which database names must be hidden with the hide_db parameter. It contains a regular expression (http://en.wikipedia.org/wiki/Regular_expression) representing what to exclude. If we do not want users to see any database whose name begins with'secret', we would use:

$cfg['Servers'][$i]['hide_db'] = '^secret';

These parameters apply to all users for this server-specific configuration.

Deactivating Ajax

Certain pages are using Asynchronous JavaScript to improve user experience. We can deactivate this behavior by setting $cfg['AjaxEnable'] to false; in this case, the pages for which a non-Ajax behavior has been programmed, will cease using Ajax, performing a full refresh instead. This may be perceived by the user as less fluid.