PHP Postgres - Add Login and Edit Capabilities and Textbox

  • Posted:
  • Proposals: 1
  • Remote
  • #72102
  • Archived
Mat W. has already sent a proposal.
  • 1


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.

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.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.