- Status: Pending
- Prize: €300
- Entries Received: 10
- Winner: wedecoder
This project is just a small piece to test your skills but something we need in a similar way in many places. So your effort is not wasted and a lot will be built upon the initial work.
The goal is to build an administrative system to deal with data stored in a database. This is to manage customer data, equipment data and other items of a internet provider including its service usage data etc.
For this project we start with a simple table which is a list of customers who have a postal address, phone number, email address, unique customer number etc.
Your task is to write a nice GUI which can Create,Read,Update,Delete (CRUD) entries from a MariadDB database. So you need to present a list form where selective data is shown (list form/ table) , where you can add a new entry (input form), or modify an entry or delete an entry. Some input form fields should have verification checks for validity. for example phone numbers should have + and digits only or email address should be a real email address.
I want to see how you implement such a system in a unified way so it could be adapted to other similar list. Like a unified function where you parametrize in a simple way whats displayed and which checks apply.
This should run on a Debian 11 Linux system with MariaDB, Apache and PHP7
The visuals should be that there is a intuitive and beautiful user interface.
Big frameworks or other bloatware are disrecommended. Use the KISS principle.
Bonus if you include a fine grained access control (For example user type A can see the phone numbers, user type B can modify it, user type C can not even see it etc).
Public Clarification Board
How to get started with contests
Post Your Contest Quick and easy
Get Tons of Entries From around the world
Award the best entry Download the files - Easy!