WEEK 7

In week 7, we learned on how to create online questionnaire and also create forum. 

Online questionnaire:-

   Create Database

• Go to PHPMyAdmin
• Use existing database 'student'
• Create table in the database and name it as questionnaire

   Create Page for Questionnaire Form

• File > New > Blank Page > PHP
• Type the instruction of the questionnaire
• Insert Form > Radio Group
• Fill up the Radio Group Form as below 
 

 

• For Likert Scale Question, create table first and then type the question in each row.
• Insert Form > Radio Group
• Create radio group for each question and locate it in each column of the scale

• Insert submit button at the bottom of the page
• Then go to panel server behaviour > insert record
• Save the page as questionnaire.php

  

  Create Page for Analysis

• File > New > Blank Page > PHP
• Insert table and type all the item that we want to analyze in the table

 

FORUM

Create database

• We can also using the existing database that we already have
• For this case, I create table at my existing database which name ‘student’
• Create table consist of 3 items which are id, name and post
• Set the id as auto increment and primary

Create forum page

• File > New > Blank Page > PHP
• Insert Form
• Insert table; 2 row and 2 column consist of name and comment
• Insert submit button and name it as Post Comment
• Go to panel server behaviour > insert record

• Add ‘comment from others’ outside the form area
• Type name and comment
• Go to panel server behaviour > recordset
• Choose name and post and match it like the picture below

• Preview in the Firefox and the appearance should be like the picture below:-