onecentlin/laravel-adminer

Laravel Adminer Database Manager

6.1.1 2023-02-15 16:44 UTC

Requires

• php: >=5.4.0
• illuminate/contracts: ~5.0|~6.0|~7.0|~8.0|~9.0|~10.0
• illuminate/routing: ~5.0|~6.0|~7.0|~8.0|~9.0|~10.0
• illuminate/support: ~5.0|~6.0|~7.0|~8.0|~9.0|~10.0

MIT

• Winnie Lin

• database
• mysql
• sqlite
• management
• adminer
• laravel5
• laravel6
• laravel7
• laravel8
• laravel9
• laravel10

README

Light weight Adminer database management tool integrated into Laravel 5/6/7/8/9.

Various database support: MySQL, SQLite, PostgreSQL, Oracle, MS SQL, Firebird, SimpleDB, MongoDB, Elasticsearch, and etc.

v6.0 New Features

Make life easier with minimized package setup =)

• Enable laravel auto package discovery
• New config setting: middleware (default value: auth)
• Enable env variables to setup adminer config
  • ADMINER_ENABLED
  • ADMINER_AUTO_LOGIN
  • ADMINER_ROUTE_PREFIX

Installation

composer require onecentlin/laravel-adminer

OR

Update composer.json in require section:

"require": {
    "onecentlin/laravel-adminer": "^6.0"
},

Run:

composer update onecentlin/laravel-adminer

Register package

Laravel auto package discovery feature added since package v6.0, you may skip this step.

Update config/app.php

'providers' => [
    ...
    Onecentlin\Adminer\ServiceProvider::class,
];

Publish config and theme file

php artisan vendor:publish --provider="Onecentlin\Adminer\ServiceProvider"

This action will copy two files:

• config/adminer.php - Adminer config file
• public/adminer.css - Adminer theme file

config file: config/adminer.php

<?php

return [
    'enabled' => env('ADMINER_ENABLED', true),
    'autologin' => env('ADMINER_AUTO_LOGIN', false),
    'route_prefix' => env('ADMINER_ROUTE_PREFIX', 'adminer'),
    'middleware' => 'auth',
];

ATTENSION: Please only enable autologin with authenticated protection.

theme file: public/adminer.css

You may download adminer.css from Adminer or create custom style, and place it into public folder.

Setup Access Permission (Middleware)

Package v6.0 allow customized middleware config, you may skip this step or modify to fit your needs.

Laravel 5.2 and above

Setup for middleware group supported for Laravel 5.2 above

Modify config/adminer.php : 'middleware' => 'adminer',

Modify app/Http/Kernel.php file with adminer in $middlewareGroups

protected $middlewareGroups = [
    ...
    'adminer' => [
        \App\Http\Middleware\EncryptCookies::class,
        \Illuminate\Session\Middleware\StartSession::class,
        // TODO: you may create customized middleware to fit your needs
        // example uses Laravel default authentication (default protection)
        \Illuminate\Auth\Middleware\Authenticate::class,
    ],
];

Access adminer

Open URL in web browser

http://[your.domain.com]/adminer

Remarks

Due to function name conflicts of Laravel 5 and Adminer, adminer.php file functions cookie(), redirect() and view() are prefixed with adm_ prefix.

Inspired by miroc