| Developed For: |
A small retailer, and CSC Club |
|
Completed In: |
2 weeks |
| Technologies: |
PHP, MySQL, Htaccess |
|
Website Link: |
click here |
I have actually created two web surveys; one for my friend's mom who owns a small scrapbooking business and the
other for the Computer Science Club at BW for a follow up on the High School Programming Contest that we
hosted. Both surveys have the same functionality behind them and that is that the administrator has access to...
- View the number of times an option was selected for each question
- See the individual(s) who selected an option for a question
- Each person's individual answers/responses
- View the answers that required a written response
For security purposes, I have created a
"test" survey for
viewing
purposes which demonstrates all the functionality in the survey since I can't show the actual answers from the real
surveys. The "test" survey can be viewed by
clicking here which is the
same survey for the High School Programming Contest but runs on a different database.
As for the other survey that I
created
for my friends mom's business, well this one
was a lot more complex since they wanted a lot more questions for their customers to answer - 43 to be exact. In fact,
I was approached by my friends who were doing a marketing project and decided to do it on his mom's
company. As I recall, they wanted to have the customers take the survey and based on the results, develop
some gorilla marketing tactics for their project and the business.
My friends first gave me a list of questions that they felt would help with their marketing tactics, so after showing
them what I came up with, they asked if I could change a few things - questions, wording, etc. I did this
and then showed them the survey again and luckily, they were pleased. The next project for me was to create the
database, and the admin pages. The MySQL database that I created was the largest database I have ever created - it
was somewhere around 125+ columns. I was very glad once I knew the submitted information from the survey was inserted
properly into the database.
The preferred way my friends wanted the information from the survey displayed was by a bar graph for each question; however
after explaining to them that it would require a lot more work, they were satisfied with a page that displayed the number
of times an option was selected for each question and a page that displayed the percentages.
I then created a page for them that listed all the customer's e-mails, their name, phone number, and what time they took the
survey since his mom was giving a 10% discount on a customer's order if they took the survey. Also, I created a page that
displayed each person's individual answers and a page that show all the written responses by the customers.
After completeing the survey
and seeing it in action, I was really pleased with what I had created. My friends got an A+ on
their marketing project since the web survey was something unique that no one in their class had, and
my friend's mom was ecstatic with what I created and thankful for all the hard work I had put into it (I don't think my friends
or his mom knew how much time it would take to put something like that together).
|
