CINXE.COM

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Adminer - Plugins</title> <link rel="stylesheet" type="text/css" href="/static/style.css" /> <link rel="stylesheet" type="text/css" href="/static/jquery/fancybox/jquery.fancybox-1.3.4.css" media="screen" /> <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" /> <link rel="alternate" type="application/rss+xml" href="https://sourceforge.net/p/adminer/news/feed" title="News" /> <link rel="canonical" href="/en/plugins/" /> <link rel="alternate" lang="cs" href="/cs/plugins/" title="膶e拧tina" /> <link rel="alternate" lang="sk" href="/sk/plugins/" title="Sloven膷ina" /> <link rel="alternate" lang="de" href="/de/plugins/" title="Deutsch" /> <link rel="alternate" lang="pl" href="/pl/plugins/" title="Polski" /> <link rel="alternate" lang="ro" href="/ro/plugins/" title="Rom芒n膬" /> </head> <body> <div id="container"> <div id="header"> <h1><a href="/en/">Adminer <span></span></a></h1> <div id="slogan">Database management in a single PHP file</div> <ul id="languages"> <li><img src="/static/images/flags/en.gif" width="16" height="11" alt="English"></li> <li><a href="/cs/plugins/"><img src="/static/images/flags/cs.gif" width="16" height="11" alt="膶e拧tina"></a></li> <li><a href="/sk/plugins/"><img src="/static/images/flags/sk.gif" width="16" height="11" alt="Sloven膷ina"></a></li> <li><a href="/de/plugins/"><img src="/static/images/flags/de.gif" width="16" height="11" alt="Deutsch"></a></li> <li><a href="/pl/plugins/"><img src="/static/images/flags/pl.gif" width="16" height="11" alt="Polski"></a></li> <li><a href="/ro/plugins/"><img src="/static/images/flags/ro.gif" width="16" height="11" alt="Rom芒n膬"></a></li> </ul> </div> <div id="navbar"> <ul> <li><a href="/en/"><em><span class="icon adminer">Adminer</span></em></a></li> <li><a href="/en/editor/"><em><span class="icon editor">Adminer Editor</span></em></a></li> <li><a href="/en/plugins/" class="current"><em><span class="icon plugin">Plugins</span></em></a></li>  <li><a href="https://sourceforge.net/p/adminer/news/"><em><span class="icon news">News</span></em></a></li> <li><a href="https://sourceforge.net/p/adminer/discussion/"><em><span class="icon forums">Forums</span></em></a></li> <li><a href="https://sourceforge.net/p/adminer/bugs-and-features/"><em><span class="icon bugs">Bugs</span></em></a></li> <li><a href="https://github.com/vrana/adminer/"><em><span class="icon svn">Code</span></em></a></li> </ul> </div> <script type="text/javascript" src="/static/jquery/jquery-1.4.4.js"></script> <script type="text/javascript" src="/static/jquery/fancybox/jquery.mousewheel-3.0.4.pack.js"></script> <script type="text/javascript" src="/static/jquery/fancybox/jquery.fancybox-1.3.4.pack.js"></script> <h2>Adminer - Plugins</h2> <p>Adminer and Adminer Editor can be extended by plugins. <a href="#use">To use a plugin</a></p> <ul> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/plugin.php">plugin</a>: Required to run any plugin</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/database-hide.php">database-hide</a>: Hide some databases from the interface - just to improve design, not a security plugin</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/designs.php">designs</a>: Allow switching designs</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/dump-alter.php">dump-alter</a>: Exports one database (e.g. development) so that it can be synced with other database (e.g. production) (<a href="/en/screencast/">screencast</a>)</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/dump-bz2.php">dump-bz2</a>: Dump to Bzip2 format</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/dump-date.php">dump-date</a>: Include current date and time in export filename</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/dump-json.php">dump-json</a>: Dump to JSON format</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/dump-xml.php">dump-xml</a>: Dump to XML format in structure <code class="jush-xml"><database name=""><table name=""><column name="">value</code></li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/dump-zip.php">dump-zip</a>: Dump to ZIP format</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/edit-calendar.php">edit-calendar</a>: Display <a href="http://jqueryui.com/">jQuery UI</a> <a href="http://trentrichardson.com/examples/timepicker/">Timepicker</a> for each date and datetime field</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/edit-foreign.php">edit-foreign</a>: Select foreign key in edit form</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/edit-textarea.php">edit-textarea</a>: Use <code class="jush"><textarea></code> for <code class="jush-sql">char</code> and <code class="jush-sql">varchar</code></li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/enum-option.php">enum-option</a>: Use <code class="jush"><select><option></code> for <code class="jush-sql">enum</code> edit instead of <code class="jush"><input type="radio"></code></li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/enum-types.php">enum-types</a>: Use <code class="jush"><select><option></code> for <code class="jush-sql">enum</code> edit instead of regular input text on enum type in PostgreSQL</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/file-upload.php">file-upload</a>: Edit fields ending with <code>_path</code> by <code class="jush"><input type="file"></code> and link to the uploaded files from select</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/foreign-system.php">foreign-system</a>: Link system tables (in <code>mysql</code> and <code>information_schema</code> databases) by foreign keys</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/frames.php">frames</a>: Allow using Adminer inside a frame</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/json-column.php">json-column</a>: Display JSON values as table in edit</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/login-otp.php">login-otp</a>: Require One Time Password at login (<a href="/en/plugins/otp/">instructions</a>)</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/login-servers.php">login-servers</a>: Display constant list of servers in login form</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/login-password-less.php">login-password-less</a>: Enable login without password (<a href="https://github.com/vrana/adminer/blob/master/adminer/sqlite.php">example</a>)</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/login-ssl.php">login-ssl</a>: Connect to MySQL using SSL</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/login-table.php">login-table</a>: Authenticate a user from the <code>login</code> table</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/master-slave.php">master-slave</a>: Execute writes on master and reads on slave</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/pretty-json-column.php">pretty-json-column</a>: Pretty print JSON values in edit</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/slugify.php">slugify</a>: Prefill field containing <code>_slug</code> with slugified value of a previous field (JavaScript)</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/sql-log.php">sql-log</a>: Log all queries to SQL file</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/struct-comments.php">struct-comments</a>: Show comments of sql structure in more places (mainly where you edit things)</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/tables-filter.php">tables-filter</a>: Filter names in tables list</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/tinymce.php">tinymce</a>: Edit all fields containing <code>_html</code> by HTML editor <a href="http://tinymce.moxiecode.com/">TinyMCE</a> and display the HTML in select</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/translation.php">translation</a>: Translate all table and field comments, <code class="jush-sql">enum</code> and <code>set</code> values from the <code>translation</code> table (automatically inserts new translations)</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/version-noverify.php">version-noverify</a>: Disable version checker</li> <li><a href="https://raw.github.com/vrana/adminer/master/plugins/wymeditor.php">wymeditor</a>: Edit all fields containing <code>_html</code> by HTML editor <a href="http://www.wymeditor.org/">WYMeditor</a> and display the HTML in select</li> </ul> <h3 id="user">User contributed plugins</h3> <ul> <li><a href="https://github.com/LinkedList/Adminer-Allowed-Prefixes">allowed-prefixes</a> (Martin Macko): Show only tables with user set prefixes</li> <li><a href="https://bitbucket.org/beholder/adminer-checkboxselect/src">checkbox-select</a> (Alexander Shabunevich): Check multiple checkboxes at once by Shift+click.</li> <li><a href="https://github.com/tomgoodsun/adminer-show-column-comment">Column Comment</a> (Tomohito Higuchi)</li> <li><a href="https://github.com/natanfelles/adminer-bootstrap-like">Bootstrap-Like Design</a> (Natan Felles)</li>   <li><a href="https://github.com/smuuf/adminer-colorfields">colorfields</a> (Prema van Smuuf)</li> <li><a href="https://gist.github.com/raw/821510/convention-foreign-keys.php">convention-foreign-keys</a> (Ivan Ne膷as): Links for foreign keys by convention <code>user_id</code> => <code>users.id</code></li> <li><a href="https://raw.github.com/Michal-Mikolas/Adminer-Editor-package/master/plugins/ConventionsForeignKeys.php">convention-foreign-keys</a> (Michal Mikol谩拧): Links for foreign keys by convention <code>user_id</code> => <code>users.id</code></li> <li><a href="https://github.com/adilyildiz/AdminerCopy">AdminerCopy</a> (Adil Yildiz)</li> <li><a href="https://github.com/margenn/adminer-camera-upload-plugin">Camera Upload</a> (Marcelo Gennari)</li> <li><a href="https://gist.github.com/redfish-d86e/bd6e1bb86424bec46c1289a997cfe972">cellformula</a> (Tommy Tan)</li> <li><a href="https://github.com/mmokross/AdminerCustomizeThemeBasedOnServer">CustomizeThemeBasedOnServer</a> (Michael Mokro脽)</li> <li><a href="https://github.com/icyz/adminer/blob/master/plugins/disable-tables.php">Disable tables</a> (Andrea Mariani)</li> <li><a href="https://gist.github.com/scr4bble/b472f3683b7e03200df60c7366f08b97">DisplayForeignKeyName</a> (Bruno Vibert, Peter Hosta膷n媒)</li> <li><a href="https://github.com/sc419/AdminerDumpMarkdownDict">DumpMarkdownDict</a></li> <li><a href="https://github.com/fthiella/adminer-plugin-dump-markdown">dump-markdown</a> (Federico Thiella)</li> <li><a href="https://github.com/Gobie/adminer-plugins">dump-xml-dataset</a> (Michal Bra拧na): Dump to XML format specifically PHPUnit's XML DataSet structure</li> <li><a href="https://github.com/LinkedList/FasterTablesFilter">FasterTablesFilter</a> (Martin Macko)</li> <li><a href="https://openuserjs.org/scripts/knedle/Adminer_-_favorites_tables">favorites tables</a> (Ladislav 艩evc暖j)</li>  <li><a href="https://github.com/icyz/adminer/blob/master/plugins/fk-disable.php">fk-disable</a> (Andrea Mariani)</li> <li><a href="https://github.com/stano/adminer-floatThead">floatThead</a> (Stano Pa拧ka): Floating table header plugin</li> <li><a href="https://gist.github.com/Roy-Orbison/52f20d5b2eacd9ad3b828ca225202982">folder-import</a> (Roy-Orbison)</li> <li><a href="https://github.com/mhucik/AdminerForeignKeysPlugin">ForeignKeys</a> (Marek Hu膷铆k)</li> <li><a href="https://github.com/raitocz/hidePgSchemas">hidePgSchemas</a> Hide schemas with <code>pg_</code> prefix (Martin Jagr)</li> <li><a href="https://github.com/arxeiss/Adminer-HideTables">HideTables</a> (Pavel Kut谩膷)</li> <li><a href="https://github.com/derStephan/AdminerPlugins/blob/master/hideableColumns.php">HideableColumns</a> (Stephan)</li> <li><a href="https://github.com/vlgalik/adminer-imagefields">imagefields</a> (Ladislav G谩lik)</li> <li><a href="https://github.com/arxeiss/adminer-input-uuid-generator">input-uuid-generator</a> (Pavel Kut谩膷)</li> <li><a href="https://github.com/natanfelles/adminer-ispconfig">ispconfig</a> (Natan Felles): Authenticate and auto-check host by ISPConfig Remote API</li> <li><a href="https://gist.github.com/marcbln/22dd713966cbda67af2e6bfc465a5c46">JsonVarDumper</a> (Marc Christenfeldt)</li> <li><a href="https://github.com/Roy-Orbison/adminer-login-external">login-external</a> (Roy Orbison)</li> <li><a href="https://github.com/crazy-max/login-servers-enhanced">login-servers-enhanced</a> (CrazyMax): Fork of the official login-servers Adminer plugin with enhancements</li> <li><a href="https://gist.github.com/3423745">nette-user-login</a> (Mikul谩拧 D铆t臎)</li> <li><a href="https://github.com/giofreitas/one-click-login">one-click-login</a> (S茅rgio Freitas)</li> <li><a href="https://github.com/gremki/AdminerPHPExport">PHP Export</a> (Adrian Andreescu)</li> <li><a href="https://gist.github.com/donwilson/0bc0ec7c3701fb20747777a1a7b4cab4">PHP Serialized Data</a> (Don Wilson)</li> <li><a href="https://gist.github.com/scr4bble/9ee4a9f1405ffc1465f59e03768e2768">readable-dates</a> (Dora Bulkins): Replaces UNIX timestamps with human-readable dates in your local format</li> <li><a href="https://github.com/TiagoGilMarques/adminer.resize">resize</a> (Tiago Gil Marques): Left column (tables) resizer (allow you to resize left table column)</li> <li><a href="https://gist.github.com/NoxArt/8085521">restore-menu-scroll</a> (Ji艡铆 Petru啪elka): Remembers and restores scollbar position of side menu</li> <li><a href="https://github.com/MartinZubek/adminer-schema-default-to-public">SchemaDefaultToPublic</a> (Martin Zubek)</li> <li><a href="https://github.com/derStephan/AdminerPlugins/blob/master/searchAutocomplete.php">SearchAutocomplete</a> (Stephan)</li> <li><a href="https://github.com/andit-ogihara/adminer-show-table-row">Show Table Row</a> (Kazuhiro Ogihara)</li>  <li><a href="https://github.com/derStephan/AdminerPlugins/blob/master/stickyColumns.php">StickyColumns</a> (Stephan)</li> <li><a href="https://github.com/icyz/adminer/blob/master/plugins/suggest-tablefields.php">suggest-tablefields</a> (Andrea Mariani)</li> <li><a href="https://github.com/zhgabor/adminer-table-filter">table-filter</a> (G谩bor Zabojszky-Horvath): Quickly filtering tables, works only with custom themes where table list is floated</li> <li><a href="https://github.com/jnvsor/adminer-table-header-scroll/">table-header-scroll</a> (Jonathan Vollebregt): Makes the table header scroll with the viewport</li> <li><a href="https://github.com/TiagoGilMarques/adminer.tablesCollapse">tablesCollapse</a> (Tiago Gil Marques): Left column tables collapse (allows you to collapse tables, and translations tables with some sufix patterns, like phpmyadmin)</li> <li><a href="https://github.com/brunetton/adminer-tables_fuzzy_search">tables_fuzzy_search</a> (Bruno Duy茅): Fuzzy search (filter) in tables list</li> <li><a href="https://gist.github.com/aoloe/303f314aec36851d4c88">tables-history</a> (Ale Rimoldi)</li> <li><a href="https://github.com/PetroKostyuk/adminer-tree-view">tree-view</a> (Petro Kostyuk)</li> <li><a href="https://github.com/pematon/adminer-plugins">login-servers, json-preview, simple-menu, collations</a> (Pematon)</li> <li><a href="https://github.com/pematon/adminer-theme">Theme for Adminer</a> (Pematon): Responsive touch-friendly theme</li> <li><a href="https://github.com/felladrin/adminer-theme-switcher">Theme Switcher</a> (Victor Nogueira)</li> <li><a href="https://github.com/tomgoodsun/adminer-dump-xlsx">XLSX Dump</a> (Tomohito Higuchi)</li> </ul> <h3 id="use">To use a plugin</h3> <p>Create a PHP file specifying which plugins do you want to use:</p> <pre><code class="jush"><?php function adminer_object() { // required to run any plugin include_once "./plugins/plugin.php"; // autoloader foreach (glob("plugins/*.php") as $filename) { include_once "./$filename"; } // enable extra drivers just by including them //~ include "./plugins/drivers/simpledb.php"; $plugins = array( // specify enabled plugins here new AdminerDumpXml(), new AdminerTinymce(), new AdminerFileUpload("data/"), new AdminerSlugify(), new AdminerTranslation(), new AdminerForeignSystem(), ); /* It is possible to combine customization and plugins: class AdminerCustomization extends AdminerPlugin { } return new AdminerCustomization($plugins); */ return new AdminerPlugin($plugins); } // include original Adminer or Adminer Editor include "./adminer.php"; ?> </code></pre> <p>Then point your browser to this file.</p> <h3 id="create">To create a new plugin</h3> <ol> <li>Create a class containing any methods defined in the <code>Adminer</code> class (<a href="/en/extension/#api">documentation</a>).</li> <li>If these methods return a non-<code class="jush-php">null</code> value then it will be used instead of the original (except <code>dumpFormat</code>, <code>dumpOutput</code>, <code>editFunctions</code> where the return value is appended to the original).</li> <li>Methods can also overwrite their parameters by accepting them by reference: <code class="jush-php">f(&$param)</code>.</li> <li>If you would like to publish the plugin on this page then upload it somewhere (e.g. to <a href="https://gist.github.com/">GitHub Gist</a>) and send the link to: <a href="mailto:jakub@vrana.cz">jakub@vrana.cz</a>.</li> </ol> <script type="text/javascript" src="/static/jush/2.0.0/jush.js"></script> <style> pre a { text-decoration: none; } </style> <script type="text/javascript"> jush.style("\/" + 'static/jush/2.0.0/jush.css'); jush.create_links = false; jush.highlight_tag('code'); </script> <div id="footer"> <p id="author"> <a href="https://www.vrana.cz/">Jakub Vr谩na</a>  </p> <p id="credits"> Design: <a href="mailto:jan@smitka.org">Jan Smitka</a>, <a href="http://www.famfamfam.com/lab/icons/silk/">Silk Icons</a>, Translation: <a href="https://php.vrana.cz/">Jakub Vr谩na</a>, <a href="https://www.vas-hosting.com/?ref=3000">Hosting</a> </p> </div> </div> </body> </html>