Simple-admin meant for download and upload database tables, print queries and edit records

Field for use

Web programmers sometimes need to edit databases, search and update records, beforehand made reserve copies of tables. If you rent hosting, the easiest way to work with database might be use web-interface. Despite there are many similar apps, I made my own one, powerful and plain project, cut excess options, let be only necessary things, relied on my own experience, what need for web-programmers.

Supported versions

In this last update, code of project have rewritten for MVC-pattern. App got facilities of shift database in menu, filter records and edit records in modal window.

Admin-app passed tests locally on Open Server v and deployed on hosting, supported versions:

  • Server part
    • Apache-2.4+Nginx-1.17
    • PHP-7.2
    • MySQL-5.6
    • Encoding: HTTP-server - utf-8, mysql-server - utf8_general_ci
  • Code
    • php: mvc-pattern, pure php, no any cms
    • javascript: jQuery
    • css: pure css

Set up project

Clone project from github https://github.com/rightJoint/simple-php-mysql-admin

git clone https://github.com/rightJoint/simple-php-mysql-admin sa.local

or download form this site. I used javascript (googleapis.js, Elegant-Loading-Indicator-jQuery-Preloader), that stored in /source/js, have included in repository.

Options .htaccess

To use admin you must adjust htaccess, redirect http-queries to index.php.

RewriteEngine on
RewriteBase /
DirectoryIndex index.php
RewriteRule . index.php [L]

Configuration Admin:

All settings are described in model_admin.php, change that, if you need others:

  • $pathToConn - json format-file.php where stored connection settings to mySql-server
  • $pathToUsrList - json format-file.php contains logins and password admin users
  • options->pathToTablesList - where stored create tables query files
  • options->pathToDbUpload - where from download/upload tables content
  • options->tableExtFile - create and download/upload files extension
  • options->lower_case_table_names - use true on windows or false on linux

Work with Admin-app

To Log In, use login Admin and password root set as default
Menu Admin. Next you need set up connections
Set up Server connections.
Go to SQL and do query to create database
Choose database and submit form to save settings
When connection established, you will have allowed all modules of admin
Create tables using SQL-queries or create-file. Next you may run actions with tables.
Apply filter. Click on indexed field (link) in row to edit that record
Enter and print join -queries. printQuery-module
Add or delete adminUsers

Comments: 1replies: 1

  • AvatarmrSmith

    Напишите про совместимость админки с вервсиями пхп и сервера, на чем разворачивать проект

    2019-04-29 10:39:56
    • Alexey Pichugin

      В описание проекта добавлены поддерживаемые модули. Также в репозиторий добавлены js, конфиги и картинки чтоб максимально упростить разворачивание проекта.

      2019-04-29 11:46:39
Авторизуйтесь для написания коммента