backend setup of a contact form section on a pre-existing website, i.e. to create a secure contact form going to a database, and provide an interface to view and export the data

CLOSED
Bids
6
Avg Bid (GBP)
£1342
Project Budget (GBP)
£750 - £1500

Project Description:
We are designing a Wordpress website for a commercial wing of a college.
We need help with the backend setup of the contact form section of the website, i.e. to create a secure contact form going to a database, and provide an interface to view and export the data:
- Create a basic MS SQL database on the college web farm (SQL Server 11).
o 10-20 Fields (just capturing the contact form data)
- Link the website form to the database
o The Wordpress website will be hosted on a college linux web farm (PHP 5.3.3)
o We will design the frontend
o You hook it into the database, possibly with something like http://wordpress.org/plugins/db-form/
o We will need to organise SSL cert - college to host for the Wordpress site
o We will need to adhere to college guidelines
- Provide a GUI for listing, filtering, and exporting the data to Excel/CSV
o Could use something like Microsoft Server Management Studio
o Could write something from scratch

Please provide a breakdown of your cost and time estimates. An indication of your rate for hourly support, such as amending the database, would also be helpful.

Contacts database specifications:
• The database needs to store information on individual patients including name, email address, telephone number, date of birth and some additional fields from a drop-down menu
• It is essential that this personal information is secure at all times – at rest and in transit
• Encryption at rest: encrypted database will be stored on College server using Microsoft SQL server (MS SQL farm is running SQL Server 11). Developer is responsible for design of the website interface and form which will directly populate the database.
• Encryption in transit: College recommends obtaining from Globalsign (https://www.globalsign.co.uk/) or Comodo (http://www.comodo.com/?gclid=CMeg7b6G07oCFSrJtAodxT8Aow).
• The database requires an interface to extract relevant patient details for potential studies – i.e. identify which patients would be suitable for specific studies
• Query system for analysis of the database to search for specific patient types will also be the responsibility of the developer:
o A set of Web-based query tool for querying the database and for displaying the data.
o If the web page will allow download the search result to a CSV file this will be a highly desirable feature.
o Minimum solution would be to have a web function/page to generate/update a CSV dump of the database and made available for download, so the database can be post-processed by a general office worker on their own computer


Other information to be factored in:
• Main website (Wordpress) will be reside on the college linux web farm (PHP engine version on the linux web farm is 5.3.3)
• College can provide back-end infrastructure support for hosting the site, providing infrastructure support – i.e. if the web server has failed the College will be responsible for bring it up, updating the database engine and other software engines etc. However they will not have resources to edit or debug the web site; change the database schema or stored procedures etc.
• College are providing a blank canvas – a database creation user account to create any database you need on an instance of the server.
• Developer can create standard query on their own database and refer to them. Stored procedure is a way to standardise the SQL query, so the dev can be sure the query is working properly before using it in a production environment.
• Developer would provide SSL cert to College for hosting

Skills required:
Data Processing, Database Administration, MySQL, PHP, Software Architecture
Qualifications required:
uk_english1 UK English - Level 1
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 1052
in 15 days
£ 1159
in 30 days
£ 1365
in 30 days
£ 1197
in 21 days
£ 1777
in 10 days
Hire shaggy8871
£ 1500
in 14 days