Need help with web survey...

[justcrash]

Hey guys, I need to make a webpage, with about 19-20 questions on it, sort of like an interactive survey, or poll. Then I assume I will need a page to calculate the results. Does anyone here know how to go about doing this?

I'm hoping for a java code, but all I've fond only allow me to use one question at a time. I just want peopel to make their choices, then hit submit, then get the results page, or something along those lines. I'm by no means an expert at this stuff. Any help would be great, guys!

[smoseley]

You need a database application for this.... I'm not aware of any free ones, but it should be relatively simple... Here's a little SQL Server Schema that I put together to show you an example of how you might structure a survey database:

CREATE DATABASE survey
GO

USE survey
GO

CREATE TABLE person (
	id int IDENTITY (1, 1) NOT NULL,
	username varchar (255) NOT NULL,
	password varchar (255) NOT NULL,
	full_name varchar(255) NOT NULL,
	ip_address varchar(255) NOT NULL
)
GO

ALTER TABLE person ADD 
	CONSTRAINT PK_person PRIMARY KEY CLUSTERED (id)
GO

CREATE TABLE survey (
	id int IDENTITY (1, 1) NOT NULL,
	name varchar (255) NOT NULL,
	title varchar (255) NOT NULL,
	description varchar(255) NULL 
)
GO

ALTER TABLE survey ADD 
	CONSTRAINT PK_survey PRIMARY KEY CLUSTERED (id)
GO

CREATE TABLE question (
	id int IDENTITY (1, 1) NOT NULL,
	survey_id int NOT NULL,
	number int NOT NULL,
	name varchar (255) NOT NULL,
	value text NOT NULL
)
GO

ALTER TABLE question ADD 
	CONSTRAINT PK_question PRIMARY KEY CLUSTERED (id),
	CONSTRAINT FK_question_survey FOREIGN KEY (survey_id) REFERENCES survey (id)
GO

CREATE TABLE answer (
	id int IDENTITY (1, 1) NOT NULL,
	question_id int NOT NULL,
	number int NOT NULL,
	name varchar (255) NOT NULL,
	value text NOT NULL
)
GO

ALTER TABLE answer ADD 
	CONSTRAINT PK_answer PRIMARY KEY CLUSTERED (id),
	CONSTRAINT FK_answer_question FOREIGN KEY (question_id) REFERENCES question (id)
GO

CREATE TABLE response (
	person_id int NOT NULL,
	question_id int NOT NULL,
	answer_id int NOT NULL
)
GO

ALTER TABLE response ADD 
	CONSTRAINT FK_response_person FOREIGN KEY (person_id) REFERENCES person (id),
	CONSTRAINT FK_response_question FOREIGN KEY (question_id) REFERENCES question (id),
	CONSTRAINT FK_response_answer FOREIGN KEY (answer_id) REFERENCES answer (id)
GO

[justcrash]

Ouch. Me being new, that was realy over whelming...

But thank you for your help, regardless.

[smoseley]

You might want to do a search on google for [searchweb]Free PHP Survey Engine[/searchweb] or something like that. With a little education on PHP, you could probably implement a pre-built app into your site relatively easily.

[justcrash]

Originally posted by transio
You might want to do a search on google for [searchweb]Free PHP Survey Engine[/searchweb] or something like that. With a little education on PHP, you could probably implement a pre-built app into your site relatively easily.

Ok, thank you. I'm trying the search now to see what i can find. I'm not sure if my host does perl though.

[filburt1]

PHP is not Perl.

[justcrash]

Originally posted by filburt1
PHP is not Perl.

DOH! My bad!

I didn't realize this task would be so complicated.

[filburt1]

Check out http://www.hotscripts.com/ . Provided your host supports PHP (virtually every paid host does) it should be easy to do. You can also use ASP and JSP but they're far less common for various reasons.

[smoseley]

You could also search for a Perl/CGI script, although most free scripts these days are PHP. It's the new Internet programming "standard" (if there is such a thing).

[justcrash]

I should probably add I'm using Dreamweaver 3.0, if that helps or hinders any advice I've been given.