
PHP Postgres - Add drop-down lists to webpage
5532
£125(approx. $167)
- Posted:
- Proposals: 1
- Remote
- #64283
- Archived
Description
Experience Level: Expert
1) Go to http://161.58.72.79/researchdb.php.
2) On this page we need to add three multiple-selection drop-down lists – “Search by Areas of Expertise”, “Search by Interests”, “Search by Diseases”. The database includes four tables - “contact”, “expertise”, “interest”, “disease” – that contain data for the drop-down lists. The drop-down lists should go just below Select Principal Investigator. The list data should be sorted alphabetically. The end user should be able to make single or multiple selections from each drop-down list.
3) If the user makes a selection (or multiple selections) from the Search by Areas of Expertise list OR makes a selection (or multiple selections) from the Search by Interests list OR makes a selection (or multiple selections) from the Search by Diseases list, a new page should be displayed. The new page should include a table showing the results of the selection. The table column headings should be “Last Name”, “First Name”, “Areas of Expertise” OR “Last Name”, “First Name”, “Areas of Interest” OR “Last Name”, “First Name”, “Diseases”, depending on which search list they used. The table should be sorted alphabetically by Last Name. The Areas of Expertise or Areas of Interest or Diseases fields should show multiple results if the user made multiple selections.
4) The tables “contact”, “interest”, “expertise”, and “disease” are currently not in 3rd normal form, i.e. one-to-many referential integrity constraints. They need to be converted to 3rd normal form. The PM will change the DB schema to 3rd normal form based on your advice. Developers have different methods of normalizing databases so the PM will work with you to determine how you want this done.
5) An entity-relationship diagram of the database will be provided so you’ll know what the DB schema is. Unfortunately we cannot provide direct access to the DB for security reasons.
6) We would like to have the job finished by March 28, if possible.
Deliverables:
1) PHP / Javascript code that solves the current task.
2) Suggested modifications to the database schema that are required to support the PHP code.
3) CSS/HTML code that is required to support the PHP code.
2) On this page we need to add three multiple-selection drop-down lists – “Search by Areas of Expertise”, “Search by Interests”, “Search by Diseases”. The database includes four tables - “contact”, “expertise”, “interest”, “disease” – that contain data for the drop-down lists. The drop-down lists should go just below Select Principal Investigator. The list data should be sorted alphabetically. The end user should be able to make single or multiple selections from each drop-down list.
3) If the user makes a selection (or multiple selections) from the Search by Areas of Expertise list OR makes a selection (or multiple selections) from the Search by Interests list OR makes a selection (or multiple selections) from the Search by Diseases list, a new page should be displayed. The new page should include a table showing the results of the selection. The table column headings should be “Last Name”, “First Name”, “Areas of Expertise” OR “Last Name”, “First Name”, “Areas of Interest” OR “Last Name”, “First Name”, “Diseases”, depending on which search list they used. The table should be sorted alphabetically by Last Name. The Areas of Expertise or Areas of Interest or Diseases fields should show multiple results if the user made multiple selections.
4) The tables “contact”, “interest”, “expertise”, and “disease” are currently not in 3rd normal form, i.e. one-to-many referential integrity constraints. They need to be converted to 3rd normal form. The PM will change the DB schema to 3rd normal form based on your advice. Developers have different methods of normalizing databases so the PM will work with you to determine how you want this done.
5) An entity-relationship diagram of the database will be provided so you’ll know what the DB schema is. Unfortunately we cannot provide direct access to the DB for security reasons.
6) We would like to have the job finished by March 28, if possible.
Deliverables:
1) PHP / Javascript code that solves the current task.
2) Suggested modifications to the database schema that are required to support the PHP code.
3) CSS/HTML code that is required to support the PHP code.
Richard C.
0% (0)Projects Completed
11
Freelancers worked with
1
Projects awarded
100%
Last project
16 May 2011
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies