Laravel Adminer
Adminer database management tool for your Laravel application.
Table of Contents
- Introduction
- Features
- Installation
- CSRF token middleware
- Usage
- Available plugins
- Available designs
- License
Introduction
What is Adminer?
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. For more information visit Adminer website. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.
What is Laravel Adminer?
This package is a wrapper around Adminer, it makes Adminer easy to setup, configure, customize and use within your Laravel application.
Features
- Current Adminer version used is:
4.7.7. - Supports both Adminer and Adminer Editor.
- Plugins are integrated easily.
- Alternative designs shipped with this package.
- Custom designs are also supported and can be added easily.
- No
VerifyCsrfTokenmiddleware file modification is required.
Installation
Install the package via composer:
composer require moharrum/laravel-adminer
Edit config/app.php, add package service provider (ignore this step if you have package discovery enabled):
'providers' => [
Moharrum\LaravelAdminer\Providers\LaravelAdminerServiceProvider::class,
]
Finally, publish the configuration file:
php artisan vendor:publish --provider="Moharrum\LaravelAdminer\Providers\LaravelAdminerServiceProvider"
CSRF token middleware
If you encounter a TokenMismatchException when opening the page for the first time, or when taking an action after session has expired refresh the page.
Usage
-
Application name
You may specify if you want Laravel Adminer to display application name from
.envfile or a custom value:
'application_defaults' => [
'name' => [
'use_env_default' => false,
'custom' => 'Laravel Adminer',
],
],
-
Adminer Manager
enabledis used to enable or disable automatic route registration, if you wish to register your routes manually, setenabledtofalse. Additionally, you must specify routenameandpathin theroutesection. Optionally, you may specify an alternative design in thestylesection.
'manager' => [
'enabled' => true,
'route' => [
'name' => 'adminer.manager.index',
'path' => 'adminer/manager',
'middleware' => [
'web',
],
],
'style' => 'vendor/laravel-adminer/styles/pepa-linha/adminer.css',
],
-
Adminer Editor
Adminer Editor is both easy-to-use and user-friendly database data editing tool written in PHP. It is suitable for common users, as it provides high-level data manipulation.
'editor' => [
'enabled' => false,
'parameters' => [
'connection' => env('DB_CONNECTION', null),
'database' => env('DB_DATABASE', null),
'host' => env('DB_HOST', null),
'port' => env('DB_PORT', null),
],
'route' => [
'name' => 'adminer.editor.index',
'path' => 'adminer/editor',
'middleware' => [
'web',
],
],
'style' => 'vendor/laravel-adminer/styles/pepa-linha/adminer.css',
],
-
Plugins
A list of plugins is available in the
pluginssection, the list is not yet complete with all Adminer plugins.
Available plugins
-
database-hide Hide some databases from the interface - just to improve design, not a security plugin.
-
designs Allow switching designs.
-
dump-alter Exports one database (e.g. development) so that it can be synced with other database (e.g. production).
-
dump-bz2 Dump to Bzip2 format.
-
dump-date Include current date and time in export filename.
-
dump-json Dump to JSON format.
-
dump-xml Dump to XML format in structure
<database name=""><table name=""><column name="">value. -
dump-zip Dump to ZIP format.
-
edit-foreign Select foreign key in edit form.
-
edit-textarea Use
<textarea>for char and varchar. -
enum-option Use
<select><option>for enum edit instead of<input type="radio">. -
enum-types Use
<select><option>for enum edit instead of regular input text on enum type in PostgreSQL. -
foreign-system Link system tables (in mysql and information_schema databases) by foreign keys.
-
frames Allow using Adminer inside a frame (disables ClickJacking protection).
-
json-column Display JSON values as table in edit.
-
slugify Prefill field containing
_slugwith slugified value of a previous field (JavaScript). -
sql-log Log all queries to SQL file.
-
struct-comments Show comments of sql structure in more places (mainly where you edit things).
-
tables-filter Filter names in tables list.
-
tinymce Edit all fields containing
_htmlby HTML editor TinyMCE and display the HTML in select. -
translation Translate all table and field comments, enum and set values from the translation table (automatically inserts new translations).
-
version-noverify Disable version checker.
-
wymeditor Edit all fields containing
_htmlby HTML editor WYMeditor and display the HTML in select.
Available designs
To view all designs with screenshots click here.
License
This project is licensed under the MIT License - see the LICENSE.md file for details.
9 Nov 15, 2022
2.5k Dec 27, 2022
441 Dec 11, 2022
470 Dec 8, 2022
580 Dec 5, 2022
4k Jan 6, 2023
501 Dec 30, 2022
20 Jun 23, 2021
311 Dec 28, 2022
745 Jan 7, 2023
12 Dec 11, 2022
12 Dec 1, 2021
8 Oct 26, 2022
5.5k Jan 1, 2023
3 Sep 29, 2022
3.3k Dec 30, 2022
41 Dec 14, 2022
249 Dec 13, 2022