PHP/Web/Javascript code for CRUD db tables

  • Status: Pending
  • Prize: €300
  • Entries Received: 10
  • Winner: wedecoder

Contest Brief

We are looking for a good universal PHP/Javascript /HTML developer who can build together with us a collection of in-house tools over a longer time period.

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.

VERY IMPORTANT: no external dependencies are allowed. Everything must be self hosted! . No fonts, no javascript , no css or anything else can be loaded from externally. It should be possible to be used in a closed environment without access to the internet.

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).

Recommended Skills

Winner
Featured Contest
Post a Contest Like This

Public Clarification Board

  • Bboysdreamsfell
    Bboysdreamsfell
    • 3 weeks ago

    Please let know whether you have checked (entry #22) this --> https://levioosa.000webhostapp.com/Techie

    • 3 weeks ago
  • Mahediii
    Mahediii
    • 1 month ago

    I am working on the project so can you extend the time for 1 day please? #extended

    • 1 month ago
  • abdullahalmamuna
    abdullahalmamuna
    • 1 month ago

    Please carefully check my entry #8.

    • 1 month ago
  • sqb123web
    sqb123web
    • 1 month ago

    #guaranteed

    • 1 month ago
  • safakerol
    safakerol
    • 1 month ago

    I would build something like this with symfony 6 + easy adminbundle 4. Can be done with an a few hours. But i wouldnt do this as a contest, only by direct hiring

    • 1 month ago
    1. afink
      Contest Holder
      • 1 month ago

      im not familiar with symfony. if it produces php code which fulfills the requirements. the contest is to see whos capable to do something in a way which meets our requirements. so you can submit examples to show of your skills not a full working product

      • 1 month ago
  • rodweb
    rodweb
    • 1 month ago

    Just to know about your contest is only those database fields you mentionned can be used to build this simple GUI ?

    • 1 month ago
    1. afink
      Contest Holder
      • 1 month ago

      you can imagine the fields sn adress database could have. the excercise omis to show off your shining flexible coding which allows adding new fields in a breeze later

      • 1 month ago
  • skreutzer
    skreutzer
    • 1 month ago

    Do you want for this contest, and/or your long-term, exclusive rights on the code? If non-exclusive (as it's generically useful, even if you primarily host instances for your applications/clients), what about libre-free licensing (GNU AGPLv3 + any later)? Yes, no, maybe?

    • 1 month ago
    1. afink
      Contest Holder
      • 1 month ago

      open source or non exclusive is fine as lobg as it allows us to produce a commercial product with it

      • 1 month ago
  • farhankha4548
    farhankha4548
    • 1 month ago

    #guaranteed plz

    • 1 month ago
  • rodweb
    rodweb
    • 1 month ago

    Hello,

    • 1 month ago
  • yousufhusain31
    yousufhusain31
    • 1 month ago

    #guaranteed please

    • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!