Solved

Website Data Integrity

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
In this tutorial viewers will learn how to style a corner ribbon overlay for an image using CSS Create a new class by typing ".Ribbon":  Define the class' "display:" as "inline-block": Define its "position:" as "relative": Define its "overflow:" as …
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now