Import .sql database files from a folder into Adminer.

folder-import.php

<?php
/**
 * Import SQL files from a directory
 *
 * @author joshcangit, https://github.com/joshcangit
 * @author Roy-Orbison, https://github.com/Roy-Orbison
 */

class AdminerImportFromFolder {

	protected $dir;

	/**
	 * @param string $dir optional directory to read from, other than Adminer's current working dir.
	 */
	function __construct($dir = '') {
		$dir = (string) $dir;
		if ($dir != '') {
			$dir = rtrim($dir, DIRECTORY_SEPARATOR) . DIRECTORY_SEPARATOR;
		}
		$this->dir = $dir;
	}

	protected function _readFiles($gz = false) {
		$mapped = array();
		$glob = "$this->dir*.[Ss][Qq][Ll]";
		if ($gz) {
			$suffix = '.gz'; # lowercase only because of core
			$glob .= $suffix;
			$suffix_cut = -3;
		}
		if ($files = glob($glob)) {
			$from = strlen($this->dir);
			foreach ($files as $file) {
				if ($from) {
					$file = substr($file, $from); # do not expose server paths in output
				}
				if ($gz) {
					$mapped[substr($file, 0, $suffix_cut)] = $file;
				}
				else {
					$mapped[$file] = $file;
				}
			}
		}
		return $mapped;
	}

	function importServerPath() {
		static $posted = null;

		$files = $this->_readFiles();
		if (extension_loaded('zlib')) {
			$files += $this->_readFiles(true); # core prioritises files without .gz
		}
		if (count($files) > 1) {
			ksort($files);
		}

		if ($posted !== null || !isset($_POST['webfile'])) {
			# use existing translation strings
			echo "<fieldset><legend>" . lang('From server') . "</legend><div>";
			echo lang('Webserver file %s', '<select name="webfilename">' . optionlist(array('' => lang('Select')) + $files, $posted, true) . '</select>');
			echo ' <input type="submit" name="webfile" value="' . lang('Run file') . '">';
			echo "</div></fieldset>\n";
			$posted = null;
			return false; # skip core UI
		}

		if (
			empty($_POST['webfilename'])
			|| !is_string($_POST['webfilename'])
			|| !array_key_exists($_POST['webfilename'], $files)
		) {
			$posted = '';
			return 'SELECTED_FILE_DOES_NOT_EXIST'; # can't return empty string because of core file_exists() check
		}

		$posted = $_POST['webfilename'];
		return $this->dir . $posted;
	}
}

Suggestions for improvements are welcome.

Please provide a default value for the parameter in the __construct function to prevent fatal PHP 7.2 error. Using function __construct($folder = null) instead should have it work as it did before while giving newer PHP a default/fallback value since it's always expecting one.

This should now be able to access .sql files in the current directory.
I assumed it should require a folder but I was wrong.

I wonder if anyone knows how to fix that visual glitch.
🤔

Still not perfect, but a little bit better...

<?php
/**
 * Import databases from a folder
 *
 * @author joshcangit, http://github.com/joshcangit/
 */
class AdminerImportFromFolder {
    private $folder;

    /**
    * $folder - directory containing .sql files
    */
    function __construct($folder = null){
        $this->folder = $folder;
    }

    function importServerPath() {
        ?>
        <fieldset>
          <legend>From folder</legend>
          <div>
            <select name="file">
                <option value=""></option>
                <?php
                if ($this->folder)
                    $folder = $this->folder."/";
                else
                    $folder = $this->folder;
                // load all .sql files
                foreach (glob($folder."*.sql") as $path) {
                    $file = preg_replace("~(?:.+\/)?(.+\.sql)~", "$1", $path);
                    ?> <option value="<?php echo $path; if ($_POST['file'] == $path) return $_POST['file']; ?>"><?php echo $file; ?></option>
                    <?php
                }
                ?>
            </select>
        </fieldset>
        <?php
    }
}

Fixed.

Fixed.

Thank you very much! 🙏

In that case, would it be alright to use your code?
The Adminer developer has linked to my gist so I'm thinking of updating my code with yours.

May as well. I emailed Jakub, but I think he's a very busy guy. Better to have one linked solution on the official plugins page.

There's a way to merge gists cleanly. (See my note at the bottom.)

May as well. I emailed Jakub, but I think he's a very busy guy. Better to have one linked solution on the official plugins page.

There's a way to merge gists cleanly. (See my note at the bottom.)

Thought about that for a while. I decided to just copy everthing but keep the filename and class name the same.

👍

Drop that close tag though. You don't want the possibility of breaking someone's Adminer install over a style preference.

Drop that close tag though. You don't want the possibility of breaking someone's Adminer install over a style preference.

Now I realize the closing tag wasn't necessary.

how to increase adminer import file limit

how to increase adminer import file limit

🤔

You will need to edit the upload_max_filesize in the php.ini configuration file if you use the Browse... button to actually upload a sql file larger than 2MB.

Thanks to @Roy-Orbison, this plugin replaces the adminer.sql[.gz] with a drop-down menu to select a sql file found in a folder.
I really didn't like how without this plugin, all the databases would need to be in a single file to be imported.