0

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
16
Views
2 Years
Discussion Span
Last Post by diafol
0

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?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.