PHP Postgres - Add Login and Edit Capabilities and Textbox
4719
£75(approx. $94)
- Posted:
- Proposals: 1
- Remote
- #72102
- Archived
Description
Experience Level: Intermediate
We need to add a “Research Synopsis” text box to a page. The text box should go directly after the Email text and before the Download button.
- Just above the text box there should be a text field that says “Research Synopsis”. The content for the text box is in a table “contact” with column “researchsummary” with datatype “character varying”.
- When a user chooses a specific investigator from the dropdown box, the appropriate text in “researchsummary” should be displayed in the text box.
- We have to add a “User Login” button to this page. The button should go directly to the left of the “Admin Login” button. When users click this button it should redirect them to the login.php page, which already exists. When users submit their userid/password it should be authenticated against records in an “authenticate” table, which already exists. If they fail authentication they should be redirected to “checklogin.php”, which already exists. If authentication is successful they should be redirected back to “researchdb.php” and a new “Edit Contact Info” button should be displayed directly below the “Download Publication List” button.
- If users click the “Edit Contact Info” button they should be redirected to a new page where their contact data is shown in an editable state. There should be a Submit button displayed at the bottom of this page that allows users to commit any changes they have made, and a Cancel button next to it. The Submit button should update appropriate records, close the page, and redirect users back to “researchdb.php” where their updated contact data is displayed. The Cancel button should just close the page and redirect users back to “researchdb.php” where their original contact data is displayed.
- End users should be able to Edit their own existing contact data. However, they should not be able to edit any other user’s data. The User Login step should ensure this. The contact data is available in two tables – “contact” and “role”. There is a foreign key constraint from contact to role.
We would like to have the job finished by May 16, if possible.
Deliverables:
1) PHP / Javascript / SQL code that solves the current task.
2) Suggested modifications to the database schema (if any) that are required to support the PHP / Javascript / SQL code.
3) CSS/HTML code that is required to support the PHP code.
- Just above the text box there should be a text field that says “Research Synopsis”. The content for the text box is in a table “contact” with column “researchsummary” with datatype “character varying”.
- When a user chooses a specific investigator from the dropdown box, the appropriate text in “researchsummary” should be displayed in the text box.
- We have to add a “User Login” button to this page. The button should go directly to the left of the “Admin Login” button. When users click this button it should redirect them to the login.php page, which already exists. When users submit their userid/password it should be authenticated against records in an “authenticate” table, which already exists. If they fail authentication they should be redirected to “checklogin.php”, which already exists. If authentication is successful they should be redirected back to “researchdb.php” and a new “Edit Contact Info” button should be displayed directly below the “Download Publication List” button.
- If users click the “Edit Contact Info” button they should be redirected to a new page where their contact data is shown in an editable state. There should be a Submit button displayed at the bottom of this page that allows users to commit any changes they have made, and a Cancel button next to it. The Submit button should update appropriate records, close the page, and redirect users back to “researchdb.php” where their updated contact data is displayed. The Cancel button should just close the page and redirect users back to “researchdb.php” where their original contact data is displayed.
- End users should be able to Edit their own existing contact data. However, they should not be able to edit any other user’s data. The User Login step should ensure this. The contact data is available in two tables – “contact” and “role”. There is a foreign key constraint from contact to role.
We would like to have the job finished by May 16, if possible.
Deliverables:
1) PHP / Javascript / SQL code that solves the current task.
2) Suggested modifications to the database schema (if any) that are required to support the PHP / Javascript / SQL 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