Completed the cart interface for the user, and the cart are now able to view their status in their cart, however, i have encountered some problems with the concept of the cart of the website. Firstly, how do i allow user to add items to cart, without confirming the order, and deleting the entries in the cart after the user logs out. In the end i decided to place the delete query at the log out.php to delete all items from the cart for that particular user where the product order are still not confirmed. Even so, i am still having some issues regarding the database for the cart,as it is hard to mange the datas in the cart involving multiple tables. Not to mention, as puan said, the stock quantity in the product have to be updated everytime an order is placed. Puan suggested for us to use trigger to maintain that stock quantity, i shall stick to that idea for now.

Teh

Spent the whole day completing the functionality for the project. What was done today are namely, the functions of the website for the outer layer, where users can see and interact with without logging in, and also sign in and sign up. Changed most of the file formats to .php because most of the pages requires interaction with the database as the website is dynamic.

Other than that, the interface for users who have logged in are completed partially, users are now able to add products to their cart, and the product items are displayed dynamically. The cart for the user where the user can see their order have yet to be completed.

Teh

Met with Puan hidayah today in the morning at 9 am at her office to get clarifications regarding the part 1 part 2 and part 3 of the documentations. Also , we discussed about issues regarding our ERD like whether to put admin in its own table using a view for displaying cart.

Other than that, we have brought up that the table order could not be created with order as a singular, puan suggested us to use other words that could replace the word order. After multiple trial and error and googling, we have concluded and realized that order is actually a reserved word mysql database, hence it is impossible for us to create a table with the table name as order. As a temporary resort, we created the table as orders.

For our database, we start to configure and create table using Appserv base on our ERD .

For interface, we continue to design the other pages that haven done such as individual product description, cart, sign in, sign up, logo of our page, order list, and so on.

after these,we start to do the functionality.

Today we discuss about the storyboard whether if we need to add interface to our P3.
We get to the library discussion room for our discussion at 11am.
At the discussion room, we start doing...
- storyboard
- interface
- researching product description
- design banner

Workshop team member

Date 29.2.2015

First meeting

In the first meeting we had assign each member's responsibility within the group and understand about our job scope .

Beside, during the meeting we set our title,that is Natural Plant Products Online System.

Task complete:

1.Discuss topic of project
2.Create Blog
3.Discuss about the project flow

DATE:20 APRIL 2015

Today we start to create a local host for our database. Using Appserv packages which is My Sql.
First we use the Data Definition Language (DDL) command to create the database table.
Then, we insert our data into the database.

Carolyn