Universal admin panel

    Good evening everyone!

    I want to talk about my product, but at the same time gently ask readers: how much such a product can be in demand. Somehow it must be called (well, at least in this article), so I came up with a code name for it: "Universal Admin".

    So, first of all, why is this universal admin panel useful.

    Probably, if you are a web developer, then you sometimes (and maybe often) have this problem:
    there is a certain site (self-written or based on CMS) that takes data from the database. This data needs to be periodically edited, and not for you, but for a person who has little understanding in web technologies.
    And the admin on your site is uncomfortable. Or convenient, but there are terrible buttons: “delete”, “explode site”, “explode planet”. Or maybe there’s no admin panel at all.

    A universal admin panel is one way to solve this problem. It can adapt to almost any structure and allows you to edit data in the most convenient way.

    It consists of two parts: the ROOT interface, the administrator (moderator) interface .

    The ROOT interface allows you to determine HOW and what data you will edit.
    That is, you select tables, columns, the rights for them (view / edit / delete / search / sort), set up the internal data type for the columns, determine the relationships between the tables. There are also all kinds of filters, default values ​​and other settings for the database / tables / fields.

    Internal data typeaffects how the fields will look when viewed, how they will be edited. Each data type has its own settings.
    Here are the standard internal data types:
    • text (editable via text field / embedded HTML editor)
    • list of values ​​(edited via checkbox, radiobutton, select)
    • date Time
    • boolean type

    Via the admin interface, you can edit (add / edit / delete) data.
    In addition to standard features, there are several tools in the interface that allow you to:
    • highlight many records
    • quickly change one field without opening the edit form
    • "Fill" with values ​​a lot of fields

    The system has the ability to expand , and in particular:
    • extension of the internal data type (if you want to view and edit the field in a special way)
    • adding a special action on records (for example, publication, ban)

    PS At the moment, not even all the described functions work, so I will not post the source code. At first, only MySQL will be supported. The system is written in PHP =)
    UPDATE! Universal Admin is the code name only. The script does not pretend to be absolute universality (a panacea for all problems!).
    UPDATE! This system does not claim to compete with PhpMyAdmin. PhpMyAdmin is primarily aimed at managing the structure ; my system is aimed at managing data .

    Also popular now: