Today, i met with puan without making any prior appointment to inquire more about the ERD, as i am not sure whether to create a table for cart, or to just use a view to display cart, or neither at all. Puan said that it is up to us, and at the end of the day, i decide that creating a view is the most convenient way to manage to database.

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.