Page 1 of 1

intresting scenario(please suggest solution)

Posted: Fri Jan 01, 2010 12:47 pm
by anglina
There are three tables in mysql database
1. Projects
2. Employees
3. Empl_Proj (Assignment of employees to projects


Workflow: Home page display the list of Project to administrator. Administrator click the project which display the page "Employee_project assignment". This page contains list of all employees in the company. (Administrator should be able to distingush which employees from list are already assigned to project and which are not). Administrator can assign employees to project or deassign already assigned employees from project. the final list of assigned employees will be saved in Empl_Proj table of database.

Please suggest the design and code for Employee_project assignment page.

My in-experience opinon was to use the HTML table which have checkbox selected for already assigned employees and uncheck for rest and first delete the records from Empl_Proj table followed by saving the new selected records. but this required java script and looping on html entries and i don't know these both.so if this is the optimal solution please provide code.

Re: intresting scenario(please suggest solution)

Posted: Fri Jan 01, 2010 1:00 pm
by manohoo
It sounds like you are asking for someone to do your job for you.

You already have taken care of the database, post the table structures so that we can take a look.
What have you done so far PHP/HTML wise? Post that code too.