Member Avatar for Trabelsi

Hi, i need to create a people service management application military entreprise.This application must display the list of all the services to be performed, when i click on a service, a list of all people displays with check boxes so i select the persons concerned and finally i have to get a table in my database like this:
service.pngservice.png

i develop my application with php, i really look but i didn't find a satisfactory solution, so if anyone can help me ??

  • 2 Contributors
  • 1 Reply
  • 230 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol

Your first task will be to design the DB.
I would suggest, based on your limited explanation:

TABLES

service: id | label
garde: id | label
personnel: id | name | surname | service_id | garde_id

Do you have any idea which DB system you will be using (MySQL, MSSQL, Oracle, Postgres, etc)?

Look up 'relational databases'.
You will "most likely" be using MySQL.

https://www.google.co.uk/search?q=introduction+to+relational+databases&oq=introduction+to+rela&aqs=chrome.2.69i57j0l5.8868j0j4&sourceid=chrome&es_sm=122&ie=UTF-8#q=introduction+to+relational+databases+mysql

Are you using PHPMyAdmin? Are you using aa stack like XAMPP or WAMP?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.