modular user management system

The simple modular user management system gives you a starting point to develop user management systems with database connection.

You can find templates in /www/templates/. The following templates are currently available:

• login
• profile
• sql editor
• data
• essen verwalten
• essen bestellen
• essen übersicht

Docker setup

• download Docker
• run Docker desktop app
• run docker-compose up to start the nginx server
• open http://127.0.0.1 to go to the user management website
• you can connect to the maria db database with dbeaver:
  • Server-Host: localhost
  • Port: 3306
  • DatabaseName: tutorial
  • Username: tutorial
  • Password: secret

create DB users table

Weitere für die Essensbestellung benötigte Tabelle und Daten findest du beim Template: Essensbestellung

 CREATE TABLE users (
    id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    username varchar(100) DEFAULT NULL,
    password varchar(100) DEFAULT NULL,
    email varchar(100) DEFAULT NULL,
    klasse varchar(10) DEFAULT NULL, -- for Template Essensbestellung
    role varchar(15) DEFAULT NULL
  )

Start Page

Profile Page

SQL Page

Data Page

Infos

• https://www.sitepoint.com/docker-php-development-environment/
• used libraries:
  • Bild von rawpixel.com auf Freepik
  • jQuery
  • bootstrap
  • summernote