SurveyPortal

Web survey system

Additional Context

This project focuses on the server-side – the dynamic use of data and database, with the use of PHP and MySQL.

Scope

The following are the scope of the Front-end:

• View Home, Survey, About Us, and Contact Us pages
• Answer surveys made in the back-end
• Submit message to the back-end

The following are the scope of the Back-end:

• View and update texts for the front-end
• View, create and delete survey topics, questions and choices
• View and delete survey records
• View and delete messages
• View, update and delete account information

The following are the scope of the Database:

• Normalized

Note

The following are the notes for the Survey Topics:

• Enter the topic, no. of questions, and no. of choices first
• To set the questions and choices, click the right arrow icon → in the rightmost area of the table
• Choices are the same for all the questions in a topic

The following are the notes for the Survey Records:

• Survey Records will be automatically generated after creating a topic (with 0 respondents)
• To view the records of a topic, click the right arrow icon → in the rightmost area of the table

Screenshot

Language and Tools

• HTML5
• CSS3
• Boostrap
• JavaScript
• PHP
• MySQL
• XAMPP
• Apache
• Any text editor (e.g. VS Code, Sublime)

Note

• XAMPP
  • I am still using XAMPP v3.2.2
  • Since 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL
  • Though MariaDB is a fork of MySQL, I do not know the differences in runtime

Improvements

• Re-designed the user interface
• Applied responsive layout
• Changed the logic for showing the survey data from the database to the front-end

How to Execute

Click here to see the instructions

Want to Contribute?

• Raise an Issue
• Make a Pull Request