Media Software, LLC
CMS (Content management system) for LLC companyCMS (Content management system) - realised for LLC company in Europe (Trameco). System imported existing databse in MariaDB 5, that already existed with them.
CMS (Content management system) is based on the Editorial system and allows editing in administrator mode (Login, Logout, Search, Edit, Save, Delete)
It also allows editing in Author mode (New article, Save, Search).
Additional advanced admin features:
The system is based on the server by the DB (after Exporting the current DB - click on DB and Export) at the URL with phpmyadmin
(adding a Prefix = simply add a line with a new prefix to the DB in the TABLE rubriky - the application will load it from the DB with the F5 key, i.e. update in the browser),
(adding or deleting a user is similar = just add a line to the DB in TABLE authors - phpmyadmin has direct editing buttons for each item),
(user Author is DB in column leaders = false, but admin has in column leaders = true ),
(password can be set and modified, also in TABLE authors),
Backup DB = Export DB - click on DB and Export with encoding = utf8mb3_czech_ci (UTF-8 no BOM) on URL with phpmyadmin.
The main page is so fast that it takes 5 seconds to search or sort by column. Full loading of the entire page with 12-thousend rows lines is then signaled by a progress bar located in the upper left part of the main page.
The pagination code is ready and already tested for the website, but for single-page crawling, was not implemented here - as requested by this company, whose website is shown in the example.