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

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 [url removed, login to view]

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 ([url removed, login to view]) or Comodo ([url removed, login to view]).

• 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

Habilidades: Processamento de dados, Administração de Bancos de Dados, MySQL, PHP, Arquitetura de software

Veja mais: frontend web developer, www website setup org, www cost of account, wordpress website design cost, wordpress web developer support, wordpress software cost, wordpress org developer, wordpress mysql database developer, wordpress developer hourly rate uk, wordpress developer cost uk, wordpress developer cost, web site which help to create software, website procedures, website developer hourly rate, website dev cost, website design procedures, website design procedure, web site designing uk, website designing cost, web site designing cost, website designing and hosting, website debug software, web page developer tool, web page design software download, web page design guidelines

Acerca do Empregador:
( 0 comentários ) United Kingdom

ID do Projeto: #5137753

6 freelancers estão ofertando em média £1342 para esse trabalho


the most difficult part of the project is the query GUI. It would help if you'll have an exact description of: - the form that will pick up the data - the validation required on different fields - the queries you ne Mais

£1052 GBP in 15 dias
(75 Comentários)

Hello there, Let me introduce myself. I am Tahsinul Alam...one of the project manager of Workspace Infotech....software firm situated in Dhaka, Bangladesh. we have 13 different teams to work in different web and d Mais

£1159 GBP in 30 dias
(34 Comentários)

Software Engineer with 13 years of experience, having passed the PHP Level2, HTML, and Javascript exams, I have enough skills to complete your project. I invite you to check inside my profile page the testimonials I' Mais

£1365 GBP in 30 dias
(69 Comentários)

Dear Sir, all is understood and has been done similarly in the past by me for others. Questions: because of two domains/different servers (Linux, Windows) you need two SSL cerfificates. The more expensive option Mais

£1197 GBP in 21 dias
(33 Comentários)

I have MS in Information Security with research interest of Cryptography. I have implemented Cryptography algorithms in Java and C, written security solutions in J2EE and Java, have implemented datastructures in Jav Mais

£1777 GBP in 10 dias
(1 Comentário)

I am a UK-based developer with 15+ years experience building front and back end interfaces. I can create the database for you in SQL Server, and build an interface to view, edit and export data via Wordpress (or standa Mais

£1500 GBP in 14 dias
(0 Comentários)