Easy work with the Opencart database via adminer

Most likely, you are already familiar with Adminer, and if not, I recommend trying this excellent tool as a replacement for PHPMyAdmin when you need quick access to a client's or your own database. It's a standard database manager with the ability to modify, import, export, and execute queries in the database. Although it offers fewer features than PHPMyAdmin, it's much simpler to install and use.

Considering that I primarily work with Opencar/OcStore, I wanted to create my own version, a bit more convenient for working with this engine. The entire program is contained in one file, with no installation required. You download the archive file, unpack it, copy the ocdminer.php file to the server, launch it in the browser at yoursite.ru/ocdminer.php, and you are already connected to the database.

What's added:

• Automatic insertion of login, password, and database from config.php for quick database connection.
• Slightly altered appearance.
• On the first launch of the program, the file is automatically renamed to (random characters).php to make unauthorized access more difficult.
• Two hours after modifying or copying the file, the .expired extension is added. A timer counting down to this event is displayed in the program.
• Reset of file minification and decoding of the style string to simplify further modifications and customizations.
• The entire program is a single file, 268 kilobytes in size.

The basis was Adminer version 4.7.7 for MySQL English Only.

Of course, we remind you of the necessity of backing up your database before any changes and recommend deleting the ocdminer file after working with the database.