Title: Web Tuition 5A
Description:
Web Tuition 5A is a web based system that provide personal coaching for the students. The content in the web are about our company details (vision,mission and value), hot deals (promotion), tutor, testimonials, and contact us. This website can be accessed by the customer (parent only) and administrator.
Group Discussion (
à Discussion with my group members at Foyer FSKSM.
à Discussion about what topic to develop in the website.
à Divide a task to each group members.
Person In Charge | Task |
Banner + Montage + Database + Admin Page | |
Content + Interface Design + Database + Admin Page | |
Interactive + Interface Design + Database + Customer Page | |
Content + Interface Design + Database + Customer Page |
1) Connection name : our database name = dmx1
2) MySQL server : localhost (automatically)
3) User name : root (automatically)
4) Password : own password using phpMyAdmin
5) Database : select database that already create
6) Click OK.
Create Log in User
1) Server Behavior - Log In User - Database (dmx1)
2) Select customer table - make sure the name of username & password are same in the database
3) If login succeeds, select the next page to view (about us page)
4) If login fails, select the new registration page to register as new customer.
5) Click OK.
Insert Record
1) Server Behavior - Database (dmx1) - Table (customer)
2) Make sure the columns name consist of the right type of field.
Example : Field name_ib = Type text
3) Click OK.
View Record
1) To view the record - click Server Behavior - Recordset
2) Database = dmx1 - Table = customer
3) Click Test button (to view the data)
4) Click OK
Delete Record
1) Server Behavior - Delete Record
2) Select primary key value - Database (dmx1) - Table (customer)
3) Select URL Parameter for primary key value
4) After deleting, select the next page
Update Record
1) Server Behavior - Update Record
2) Connection name = Database (dmx1)
3) Update Table = Table (customer)
4) Make sure the columns name consist of the right type of field.
Example : Field name_ib = Type text
5) Select the next page to go after updating.
6) Click OK.
Create Previous Link
1) Highlight previous text
2) Server Behavior - Move To Previous Page
3) Server Behavior - Show Region If Not First Page
4) Click OK.
Create Next Link
1) Highlight next text
2) Server Behavior - Move To Next Page
3) Server Behavior - Show Region If Not Last Page
4) Click OK.
Figure 1 shows about the administration log in. This page consist of username and password. Admin needs to log in to this page to view the main menu.
Figure 1: Log in page for admin only.
Figure 2 shows about menu for admin such as view record, update record, delete record and add record. After login, admin can do everything.
Figure 2: Admin menu consist of view, update, delete and add records.
Figure 3 shows about delete page for admin only. Admin can view the name list of parents, then click the name that were selected. It's automatically delete the record.
Figure 3: Admin Delete Page - Name list of parents to delete record.
Figure 4 shows about update record for admin only. Admin can update all the records by using selected the name list of parents. So, admin can update about parent and children particular.
Figure 4: Admin Update Page - Admin can update all the records.
Figure 5 shows about view record for admin only. Admin can view all records.
Part 2 : Customer (Parent / Children)
Figure 6 shows about log in page for customer. Customer needs to enter their username and password. In they a new customer, they need to register by clicking the new registration link below login button.
Figure 6: Log in page for customer only.
Figure 7 shows about new registration page for new customer. New customer needs to key in their full name, username and password. The username and password must not more than 8 characters.
Figure 7:New user for registration.
Figure 8 shows all the menu after successful login. The menu are Home, About Us, Hot Deals, Tutor, Testimonials, Contact Us and Log Out.
Figure 8: Details about Tuition 5A.
Figure 9: Hot Deals Page
Figure 10: Product packages and subscription Page
Figure 11: Registration for new customer Page
Figure 12:Customer can see a timetable for all subjects.
Figure 13: Details about tutor from Tuition 5A.
Figure 14: Testimonials from our customers.
Figure 15: Our details about Tuition 5A.
Figure 16: Log out from the page.
