PHP/Web/Javascript code for CRUD db tables

  • Status: Closed
  • Prêmio: €300
  • Inscrições Recebidas: 9
  • Vencedor: wedecoder

Síntese do concurso

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

Habilidades Recomendadas

Principais inscrições deste concurso

Ver Mais Inscrições

Painel de Comentários

  • Bboysdreamsfell
    Bboysdreamsfell
    • 1 ano atrás

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

    • 1 ano atrás
  • Mahediii
    Mahediii
    • 1 ano atrás

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

    • 1 ano atrás
  • abdullahalmamuna
    abdullahalmamuna
    • 1 ano atrás

    Please carefully check my entry #8 .

    • 1 ano atrás
  • sqb123web
    sqb123web
    • 1 ano atrás

    #guaranteed

    • 1 ano atrás
  • safakerol
    safakerol
    • 1 ano atrás

    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 ano atrás
    1. afink
      Proprietário do Concurso
      • 1 ano atrás

      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 ano atrás
  • rodweb
    rodweb
    • 1 ano atrás

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

    • 1 ano atrás
    1. afink
      Proprietário do Concurso
      • 1 ano atrás

      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 ano atrás
  • skreutzer
    skreutzer
    • 1 ano atrás

    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 ano atrás
    1. afink
      Proprietário do Concurso
      • 1 ano atrás

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

      • 1 ano atrás
  • rodweb
    rodweb
    • 1 ano atrás

    Hello,

    • 1 ano atrás
  • yousufhusain31
    yousufhusain31
    • 1 ano atrás

    #guaranteed please

    • 1 ano atrás

Mostrar mais comentários

Como começar com concursos

  • Publique seu concurso

    Publique seu Concurso Rápido e fácil

  • Receba muitas inscrições

    Obtenha Toneladas de Inscrições De todo o mundo

  • Premie a melhor inscrição

    Premie a melhor inscrição Baixe os arquivos, é fácil!

Poste um Concurso ou Junte-se a nós Hoje!