Presentation

AdminerTablesFuzzySearch is a plugin for Adminer that add a fuzzy search function on current DB tables. This is really useful when working on hudge databases with tons of tables.

Usage

• use 'F' access key to give focus to fuzzy search input. Depending on browser, it could be alt-shift-F or other key combination
• type fuzzy name of table (without spaces)
• use keyboard keys to select correct match
• press enter to open selected table (or shift-enter to open it into a new tab)

Installation

1. Download and install Adminer tool

2. Create plugins folder next to adminer.php

3. Download plugins.php, this file is needed to load plugins; and place it into plugins folder

4. Download adminer-tables_fuzzy_search.php and place it into plugins folder

   File structure will be:

   - adminer.php
   - plugins
       - plugin.php
   	- adminer-tables_fuzzy_search.php
   	- ... (other plugins you've already installed)
   

5. Edit or create index.php file next to adminer.php and configure plugins and add new AdminerTablesFuzzySearch() to $plugins array :

<?php

	function adminer_object()
	{
		// required to run any plugin
		include_once "./plugins/plugin.php";

		// autoloader
		foreach (glob("plugins/*.php") as $filename) {
			include_once "./$filename";
		}

		$plugins = array(
			// specify enabled plugins here
			new AdminerTablesFuzzySearch(),
		);

		return new AdminerPlugin($plugins);
	}

	// include original Adminer or Adminer Editor
	include "./adminer.php";

Final file structure will be:

- adminer.php
- index.php
- plugins
	- plugin.php
	- adminer-tables_fuzzy_search.php
	- ...

Credits

All fuzzy search is done with the excellent Ben Ripkens's fuzzy.js library.