intresting scenario(please suggest solution)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
anglina
Forum Newbie
Posts: 3
Joined: Mon Dec 28, 2009 8:57 pm

intresting scenario(please suggest solution)

Post 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.
User avatar
manohoo
Forum Contributor
Posts: 201
Joined: Wed Dec 23, 2009 12:28 pm

Re: intresting scenario(please suggest solution)

Post 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.
Post Reply