Solved

Website Data Integrity

Posted on 2007-03-17
2
170 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Magento: different theme for Pc and for mobile devices 4 31
Undefined variable problem 5 22
ajax to record click 3 16
Giant ibd file for our biggest table on mysql 2 17
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this tutorial viewers will learn how to embed videos in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <video> tag to insert a video. Define the src as the URL of your video; this is similar to …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

839 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