Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493

    PHP / MySQL based survey system available for free download


    Hi. I've just recently made the first public release of a survey system I've been working on. The Unit Command Climate Assessment and Survey System (UCCASS) is a PHP/MySQL based survey maker that you can install on your site. This was originally developed for use in the Army to conduct annual surveys, but it can be used to conduct any type of survey or questionnaire.

    The system is built using Smarty, so it is easy to modify the templates to fit into your site or create new skins. It also uses the ADOdb database abstraction layer, so alternate databases should work (although none have been tested, as of yet).

    The system allows you to create an unlimited number of surveys, questions, and answers. Surveys and their results can be marked as public or private, where private requires a password. Results are shown as bar graphs and you can customize the images used.

    A key feature is the ability to hide or require questions based upon the answers to previous questions. These are called "dependencies" and allow you to incorporate branching and logic into your survey to tailor it to any kind of audience.

    Another feature is the ability to filter results of the surveys based upon the answers to any question. For example, if you have questions asking the gender, race, and age of your participants, you can later filter the results to view all of the answers but only for those people who said they were "asian females age 24-30". You can base a filter off of any multiple choice question that's asked in the survey. So, instead of knowing that 20% of your company hates the food in the cafeteria, you can dig into the data and figure out that actually, 90% of the people who said that only eat there once a week on average.

    The possibilities are endless. I'd be interested in hearing from anyone that installs the system and hearing any feedback you have. There are still some features that need to be added, I'm sure.

    More information, free source downloads, a live demo, screenshots and forums can be found at http://www.bigredspark.com/survey.html.

    Let me know what you think!

    ---John Holmes...
    Last edited by Sepodati; April 27th, 2004 at 10:24 AM.
    -- Cigars, whiskey and wild, wild women. --
  2. #2
  3. No Profile Picture
    Dev
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2001
    Posts
    1,436
    Rep Power
    41
    Great work! I'm going to download it immediately and check it out - I could definitely use something like that for customer surveys on my site.

    And the fact that you used Smarty is the best part - I use it in every project now.

    How long did you spend on this? It seems pretty advanced especially with features like "dependencies" and filters...
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    Thanks! Smarty and ADOdb. Although I haven't tested it with other databases, in theory, it should work once you get the tables set up.

    You can check the changelog.txt file. I've been working on this thing on and off for the better part of a year. It's gone through a lot of changes and has come out quite nice, I think.

    I was only able to find one other system that implemented a type of dependencies and branching, but it doesn't present any survey results (it exports them and it's left up to you to analyze them in separate software). I've only found one other system that has a type of "filter", too, but it only works on one question at a time whereas this will work with any number of questions.

    I just need to add in a user system where you can control who takes the survey (public, one time only with cookies, username password, by email address, by invitation only, etc). Once that's done, I don't think there'll be any competition.

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  6. #4
  7. No Profile Picture
    Dev
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2001
    Posts
    1,436
    Rep Power
    41
    Just downloaded and installated, went good except I had to replace every occurence of $_SERVER['SERVER_NAME'] with $_SERVER['HTTP_HOST'] since the former doesn't include a port number.. my local machine uses a different port for Apache. Might be something you want to account for.
  8. #5
  9. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    Thanks, I'll take a look at that. Someone else had an issue with $_SERVER['PATH_TRANSLATED'], too.

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  10. #6
  11. Retired Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2004
    Location
    London, UK
    Posts
    6,669
    Rep Power
    147
    Cool work Sep

    Few things which I found:

    Firstly, I had to give write permissions to the whole folder during installation, not just the survey.ini.php file. Once the installation had completed and I got the message telling me to remove the install.php file, I also removed the write permissions. However, I needed to let the index.php file run once before I could remove the write permissions.

    Another thing: I named my survey Edwin's Survey. But from then onwards, the script called it Edwin\' Survey - you may need to add a few strip_slashes().

    The only other thing I found was that my setup wanted permanent write access to the smarty folder. I couldn't see you saying anything about that in the documentation (sorry if you did and I missed it!), but otherwise there were errors occassionally on some pages.

    Apart from that, it worked perfectly. Nice one
  12. #7
  13. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    Thanks for the comment, Edwin. What's your magic_quote_runtime setting? I couldn't replicate the problem with the escaped quotes when I ran tests. I use a function that determines the magic_quotes_gpc setting and properly stripslashes() the data before running htmlentities($str,ENT_QUOTES) on it.

    Also, the only files that the system writes to are survey.ini.php (if you do web installation) and the smarty/templates_c/ directory. Step 8 (web-based) and step 7 (manual) of the installation does say to ensure that directory is writable, also.

    ---John Holmes...
    Last edited by Sepodati; May 2nd, 2004 at 11:37 AM.
    -- Cigars, whiskey and wild, wild women. --
  14. #8
  15. Retired Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2004
    Location
    London, UK
    Posts
    6,669
    Rep Power
    147
    From the phpinfo() function:

    Code:
    magic_quotes_gpc	On	On
    magic_quotes_runtime	Off	Off
    magic_quotes_sybase	Off	Off
    I must have just been reading the manual too quickly. I was too eager to try it out
  16. #9
  17. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    The escape character should have been removed... Where do you see the \'? Everywhere, in the list of surveys, in the survey properties page? I don't know why you'd still be seeing it.

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  18. #10
  19. Retired Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2004
    Location
    London, UK
    Posts
    6,669
    Rep Power
    147
    Yep. It's at the top of every page I think, and in the title bar.
  20. #11
  21. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    I can't replicate it. What do you actually see in your database?

    SELECT name FROM surveys;

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  22. #12
  23. Retired Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2004
    Location
    London, UK
    Posts
    6,669
    Rep Power
    147
    I think we may be talking about different things.

    "SELECT name FROM surveys" returns a list of the surveys which I've created - all of which work nicely. "Edwin's Survey" is the title of the whole site. I've checked and this is the variable stored in survey.ini.php. It had indeed been set as "Edwin\'s Survey". Removing the \ manually worked fine. So perhaps you need a strip_slashes() in the install.php file.
  24. #13
  25. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    I know you posted that a month ago, but I just happened to see it today. I fixed the issue with escape characters showing up in configuration data for the next version.

    For anyone interested, I should be making another release soon (hopefully tonight) that fixes some bugs and adds a few more features.

    ---John Holmes...
    -- Cigars, whiskey and wild, wild women. --
  26. #14
  27. Retired Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2004
    Location
    London, UK
    Posts
    6,669
    Rep Power
    147
    Hey, cool, you've got a Sourceforge project. I think it's the 1.04 version that I've already got, but I'll download the next one and look at it as soon as you release it.
  28. #15
  29. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Location
    Germany
    Posts
    1
    Rep Power
    0

    Cannot write to file: survey.ini.php


    Its a wonderfull I hope it will be helpfull for me
    I'm new on PHP and MYSQL
    I have to creat survey for my thesis work.
    I'm trying to install all but due to lack of knowledge in programming gives me trouble..

    from survey.sql file i'm able to create database
    secondly after copying all files on public_html folder when i tryied to run install.php then it gives text for for updation i did nothing there just entered my user name and password for our MYSQL data base
    after saving details its gives error "cannot write to file:survey.ini.php

    what should I do?
    and please explain me step by step
    Regards
    Imran














    Originally Posted by Sepodati
    Hi. I've just recently made the first public release of a survey system I've been working on. The Unit Command Climate Assessment and Survey System (UCCASS) is a PHP/MySQL based survey maker that you can install on your site. This was originally developed for use in the Army to conduct annual surveys, but it can be used to conduct any


    type of survey or questionnaire.

    The system is built using Smarty, so it is easy to modify the templates to fit into your site or create new skins. It also uses the ADOdb database abstraction layer, so alternate databases should work (although none have been tested, as of yet).

    The system allows you to create an unlimited number of surveys, questions, and answers. Surveys and their results can be marked as public or private, where private requires a password. Results are shown as bar graphs and you can customize the images used.

    A key feature is the ability to hide or require questions based upon the answers to previous questions. These are called "dependencies" and allow you to incorporate branching and logic into your survey to tailor it to any kind of audience.

    Another feature is the ability to filter results of the surveys based upon the answers to any question. For example, if you have questions asking the gender, race, and age of your participants, you can later filter the results to view all of the answers but only for those people who said they were "asian females age 24-30". You can base a filter off of any multiple choice question that's asked in the survey. So, instead of knowing that 20% of your company hates the food in the cafeteria, you can dig into the data and figure out that actually, 90% of the people who said that only eat there once a week on average.

    The possibilities are endless. I'd be interested in hearing from anyone that installs the system and hearing any feedback you have. There are still some features that need to be added, I'm sure.

    More information, free source downloads, a live demo, screenshots and forums can be found at http://www.bigredspark.com/survey.html.

    Let me know what you think!

    ---John Holmes...
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo