Solved

Website Data Integrity

Posted on 2007-03-17
2
172 Views
Last Modified: 2008-02-20
I have got a simple questionaire hosted on the internet. It simply has a list of questions with ten multiple choice answers per question. I am looking for to ensure that the data is as genuine as possible, i.e. ensuring users only answer the question once. This is my main concern, but any other methods people use to ensure the quality of their data gained via the internet I would be interested in.

The website uses a SQL database, and uses PHP as well.

Any ideas, and lets hear them
0
Comment
Question by:Benjamin297
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Expert Comment

by:under_dog
ID: 18739893
I have a couple of suggestions for you.

First off it's worth saving the IP address of the user when you save their answers to the database. That way you can see if someone has filled out the questionaire more than once. Bear in mind that more than one person might access it from the same location, so don't automatically ignore them.

Make sure your multiple choice questions have an option that is "I don't know" or something similar which is preselected. I have seen many times forms like this that have the first answer selected as default, and if someone submits you don't know if they selected the answer or if they simply did nothing.
0
 
LVL 29

Accepted Solution

by:
rdivilbiss earned 250 total points
ID: 18740145
Recognizing that all methods are subject to abuse-misuse...

IP restrictions could lock out users from dial-up sites, and/or AOL where many people could share an IP.

User Agent detection with IP could help, but I could use any of my multiple browsers to hit your form multiple times.

Your best bet, would be to save the answers in a temp table (or set a flag column) and e-mail the person a unique key. If they respond to the link in the e-mail, let the answers go to the main database (or toggle the waiting for confirmation flag column) and add the persons e-mail address and IP to the row.

Of course, one can have multiple e-mail addresses too.

Storing a cookie when the complete the form and checking for that before letting a new form be completed could help as well.

Everything can be circumvented, but storing IP, UserAgent and e-mail, may help you cull the data before summarizing it.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this tutorial viewers will learn how to code links for mobile sites that, once clicked, send a call or text to a specified number. For a telephone link (once clicked, calls a number), begin with a normal "<a href=" link tag. For the href, specify…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question