When accessing database, command line access need skill and you need to write full query. You might needed GUI based database system. Either you can install Workbench, SQLPro database softwares or browser based like phpMyAdmin or Adminer.
Adminer is simple and lightweight database management tool written in PHP. It is simple one php file, so you can easily use and transport. Adminer can be used for MySQL, MongoDB, MariaDB, MS SQL, PostgreSQL, SQLite, Oracle and others databases using third party plugin. You can simply download and put the Adminer.php file in your server and access databases using file.
Suppose you want to access Adminer tool in your Laravel framework, then you can also integrate it using Laravel Adminer Database Manager. Here is few things to use Adminer in Laravel application.
First install package in Laravel application using Composer command.
composer require onecentlin/laravel-adminer
config/app.php file, add the provider class in 'providers' array.
'providers' => [ ... Onecentlin\Adminer\ServiceProvider::class, ... ];
Now add adminer middleware group in
app/Http/Kernel.php. You can add your custom middleware instead of Authenticate.
protected $middlewareGroups = [ ... 'adminer' => [ \App\Http\Middleware\EncryptCookies::class, \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class, \Illuminate\Session\Middleware\StartSession::class, // use laravel default login or add your custom here \Illuminate\Auth\Middleware\Authenticate::class, ], ];
Publish the package configuration file using artisan command.
php artisan vendor:publish --provider="Onecentlin\Adminer\ServiceProvider"
This will copy config/adminer.php and public/adminer.css file.
config/adminer.php file, you can enable or disable autologin and set route_prefix.
<?php return [ 'autologin' => false, 'route_prefix' => 'adminer', ]
You can download theme and set it in
In your browser, you can access Adminer using route.
Install Python 3.8 in UbuntuPython is flexible and powerful open-sou...
Laravel Livewire Multiple File Upload ExampleLarave Livewire is a full-stack web fram...
How to Detect a Click Outside of an Element with jQueryUse the event.target Property...
Node.js MySQL Select from TableIn this article, we will guide you to ho...