Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. #1
    Junior Member
    Join Date
    Apr 2003
    Posts
    9
    Member #
    1049

    Current Rating

    Visual Appeal:
    0.0 out of 5

    Accessibility:
    0.0 out of 5

    Website Speed:
    0.0 out of 5

    Compatibility:
    0.0 out of 5

    Overall Rating:
    0.0 out of 5

    Rate This Site


    Advertisement (login to hide this!)


    You must be logged in to view this site

    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!

  2.  

  3. #2
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    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:

    Code:
    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

  4. #3
    Junior Member
    Join Date
    Apr 2003
    Posts
    9
    Member #
    1049
    Ouch. Me being new, that was realy over whelming...

    But thank you for your help, regardless.

  5. #4
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    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.

  6. #5
    Junior Member
    Join Date
    Apr 2003
    Posts
    9
    Member #
    1049
    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.

  7. #6
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    PHP is not Perl.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  8. #7
    Junior Member
    Join Date
    Apr 2003
    Posts
    9
    Member #
    1049
    Originally posted by filburt1
    PHP is not Perl.
    DOH! My bad!

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

  9. #8
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    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.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  10. #9
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    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).

  11. #10
    Junior Member
    Join Date
    Apr 2003
    Posts
    9
    Member #
    1049
    I should probably add I'm using Dreamweaver 3.0, if that helps or hinders any advice I've been given.


Page 1 of 2 1 2 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 02:33 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com